Cognos Analytics

We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.

Forcing Cognos BI to Use Native TM1 Engine

Posted on Feb 24, 2017 by John

There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop…

Restart Order for Cognos and TM1 Servers

Posted on Feb 23, 2017 by John

What order do I use to restart Cognos BI and TM1 servers in a distributed environment? We are currently doing a project where there is a TM1 server, two Cognos…

Integrating TM1 with Cognos Workspace

Posted on Feb 16, 2017 by John

One of the really cool features of the integration between TM1 and Cognos is the ability to import views of Perspectives worksheets from TM1 into Cognos BI where they can…

TM1/Cognos Security Integration Gremlin

Posted on Feb 16, 2017 by John

Weird. That’s all I can say. We have been doing a significant project with complex calculations done in TM1 and a front end with Cognos BI reports. We now have…

TI Connection Error to Cognos BI Report

Posted on Aug 8, 2016 by John

We sometimes recommend using a Cognos BI Package and BI report as the source for TM1. We usually do this when we have both TM1 and BI deployed at a…

Automatically Add Formatting to a Cognos Report on a TM1 Cube

Posted on Apr 21, 2015 by John

So I have my TM1 cube successfully published to Cognos BI.  I have the sort order defined so that I have my elements of my PnL appearing in the right…

Sort Order of a TM1 Dimension in Cognos BI

Posted on Apr 21, 2015 by John

This morning I have been working with Cognos BI over a TM1 cube.  I was frustrated that I couldn’t work out how to sort a dimension the way I wanted…

Add a TM1 cube to BI in Planning Analytics

Posted on Apr 21, 2015 by John

This is quite easy. Just go to Planning Analytics Manager (http://servername:19300/cognos_express/manager/), click on Data, Select the Data Source Type as TM1, then enter the name you want to call it…

Using TM1 Aliases in Cognos BI

Posted on Apr 21, 2015 by John

Often we build a TM1 dimension using codes or ID’s from another system.  For example Product ID’s or Customer Codes.  These are not particularly usable to most people, so we…

Setting Up Level Names in TM1 for use in Cognos BI

Posted on Apr 21, 2015 by John

I am in the middle of setting TM1 up for use with Cognos BI.  One of the things I like in BI is being able to present levels with business…

Need help with TM1?
We're here for you

Categories

Tags

Popular Articles

Keen to chat? Book a discovery call!

pen