Cognos BI

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.

How to Change TM1 to use Cognos Security (CAM)

Posted on Apr 6, 2018 by John

Configuring TM1 to use Cognos security allows you to use your corporate directory server (like Microsoft’s Active Directory) and move the addition of users and placement of users into groups...

Setting Dimension Order for a TM1 Cube

Posted on Oct 3, 2017 by John

One of the key areas to think about when designing a TM1 model is dimension order in cubes. This can be important as it has impact on how your model...

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...

How to Rename a TM1 Model

Posted on Jan 13, 2017 by John

Renaming a TM1 model is relatively easy. To change the name of a TM1 model (or instance or server name) do the following: Open tm1s.cfg for the model concerned. Find “ServerName”...

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