COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: cognos05 on 13 Jun 2014 03:28:11 PM

Title: drill down works in TM1 but when published in cognos doesnt work.
Post by: cognos05 on 13 Jun 2014 03:28:11 PM
Hi All,

I created a TM1 cube with 4 dimensions . One of the dimensions being product which has 6 levels.
This is my TI process code to create the product dimension.
DimensionElementInsert(Dimname,'','All Teams','C');
DimensionElementComponentAdd(Dimname,'All Teams',Level5HierarchyID,1.000000);
DimensionElementComponentAdd(Dimname,Level5HierarchyID,Level4HierarchyID,1.000000);
DimensionElementComponentAdd(Dimname,Level4HierarchyID,Level3HierarchyID,1.000000);
DimensionElementComponentAdd(Dimname,Level3HierarchyID,Level2HierarchyID,1.000000);
DimensionElementComponentAdd(Dimname,Level2HierarchyID,Level1HierarchyID,1.000000);
DimensionElementComponentAdd(Dimname,Level1HierarchyID,ItemID,1.000000);

So the tm1 cube drills down on each levels, but when I publish this cube as a package in cognos 10.2.1  and create a report with the levels of product dimension and enable drill down properties, the drill down doesnt work instead it replaces the value the with the same item.

Say my levels look like

10
10-1
10-1-101,10-1-102

so when i click on 10-1, it shows 10-1 itself instead of showing its child 10-1-101,10-1-102

Any suggestions on where could the issue be is appreciated.

I have defined the level names in Hierachy properties of TM1 for the product dimension.


Thanks,
Nithya