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
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
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
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
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
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
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
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
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
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
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
Keen to chat? Book a discovery call!