Hello Team,
In an OLAP/DMR Model, the Level names come under each Hierarchy specified for the Cube Structure.
In our Cognos Environment of Cognos BI 10.1 Report studio which as Cognos TM1 as the Source - The Levels names are not appearing under the Hierarchies of the Cube in the Report Package as shown Below
The Package Tree Settings also Set for default: with Members,Levels & Members for Each Level,Member Properties
The Package is re-published again with all the required settings(Framework Manager)
The TM1 services restarted, & also the Hierarchy Properties Set in the TM1 (Level names)(Cube Data Saved).
Please let us know what are we missing, as that the Level Names are not appearing in the Report Package.
Hi,
It looks to me like level names have not been successfully implemented in your TM1 cube.
You might want to check that you have:
a. Edited the {HierarchyProperties system cube to add all the desired names for the levels of each dimension
b. Refresh the desired dimensions/cubes in TI and in the TI process use the RefreshMdxHierarchy([dim name]) function - either for each dimension or RefreshMdxHierarchy('') for all dimensions.
The recommendation is that named levels are used where you have balanced hierarchies with only one member in the root level.
Cheers!
MF.
HI,
Hey that did Work :D adding the above Second Pointer in the TI Process.
Added the RefreshMdxHierarchy('') in one of the TI process..to reflect for all the dimensions.
Thanks a Lot.
;)