Utiliing TM1 Attributes in Report Studio

[jasnayvarughese]

Hello All,

I am trying to create a BI report using TM1 as a data source. The cube has 4 dimensions. I need a report with lowest level elements for 3 dimensions.

I followed IBM document which shows as how to retrieve lowest level elements from a ragged hierarchy. The link is as shown below:

http://www.ibm.com/developerworks/data/library/cognos/reporting/dimensional_queries/page624.html

The query seems to work for one dimension in a List at a time. If I try to retrieve lowest level elements for all 3 dimensions at the same time, it gives me memory issues.

I read on forums that the filter recommended by IBM can be quite slow if the dimensions are huge.

The forum users are suggesting to create an attribute in TM1 which determines the Level and then using filter statement on the attribute to retrieve Level 0 in Cognos.

I created an numeric attribute in TM1 called Bi-Level.

[All Stock Codes] is hierarchy in [Stock] dimension. The cube name is [RH-Inventory Daily].

I am using following code in Report Studio. But its giving me errors.

filter( [All Stock Codes], [RH-Inventory Daily].[Stock].[Stock].[BI-Level] = 0 )

I am new to Report Studio. Any help will be much appreciated!