Archive for December, 2011

Reporting from TM1 – Part3 : ODBC

December 19, 2011

ODBC connections might be a trouble when you are dealing with both Cognos BI and TM1;

you will most probably need 32-bit version of the ODBC Administration Tool (odbcad32.exe) and the 64-bit version.

You will need 64-bit version for your 64-bit TM1 installation, which you can find under \Windows\System32 directory.

And you might need 32-bit version for your BI to integrate it with any 3rd party data sources (not for TM1, but TM1 will never be enough as a data source, so eventually you will need to use other sources with your TM1 cubes) which you can find under  \Windows\SysWow64 directory.


Reporting from TM1 – Part2 : Attributes

December 13, 2011

TM1 cubes need to be published to Cognos Connection (with Framework Manager) in order to develop Cognos BI reports from them. In the publish process you have the option to swap item names in each dimension with an attribute of the dimension (if there are any).  

This is generally a good option because in TM1 cube development process you use codes in the dimensions as the item names and use actual names as attributes, aliases.

Country dimension in the example below consists of country and region codes, but the country names are defined as attributes. So in the publish process in Framework Manager, country names should be swapped instead of codes.

Country names in BI

Country names in TM1

Reporting from TM1 – Part1 : Levels

December 9, 2011

TM1 –Cognos BI integration is getting more common in the market (or sometimes in the form of Cognos Express edition) so I will try to focus on reporting from TM1 for a while.

Let me start with some simple issues.

We use levels in multidimensional reporting, but when we publish TM1 cubes for reporting we will not be able to see levels in the dimensions. We need to specify levels and name them in TM1 before publishing them as a package.

For this in TM1 select View > Display Control Objects from the menu in order to access hidden objects and find 

}HierarchyProperties cube.

This cube gives you the opportunity to name your levels in all your dimension.

Excel Palette

December 6, 2011

In BI Report Development process often you are asked to copy/mimic old excel reports or use them as a base.

And sometimes it is “required” to use excel colours in charts.

You can have total control on your chart palettes in Cognos; just select your chart and select “Palette” from properties.

Then you need select excel palette to be used in your charts.