Reporting from TM1 – Part1 : Levels

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.


Tags: , ,

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: