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 order. All good. Now I look at the resulting report and there is no formatting of different elements. Simple formatting like a single line above […]
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 it. For example, in TM1 I have a PnL dimension and is viewed normally with Net Profit after Tax at the bottom, Tax Expense just […]
Add a TM1 cube to BI in Cognos Express
This is quite easy. Just go to Cognos Express Manager (https://servername:19300/cognos_express/manager/), click on Data, Select the Data Source Type as TM1, then enter the name you want to call it in BI, the servername as the Administration Host, the TM1 server name (“CXMD”), the TM1 cube name you want to add to BI and finally […]
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 then usually create Aliases in TM1 as well. Those aliases are visible through in Cognos BI. Therefore when defining a dimension in TM1 when it […]
Setting Default Element and Level Names in TM1 for use in Cognos BI
How to set the default member and set level names for a TM1 dimension to be used in Cognos Analytics. This means you don’t need every dimension defined in a Cognos report and gives useful names for levels in Cognos hierarchies.