How to create Levels & Alternative hierarchies in TM1 for C8 BI

[Hevex]

Hi All,

Cognos 8 uses lots of functions which are relating to levels and alternative hierarchies, however I could not find any way of coming up with these in TM1.

Anyone had any more luck?

Thank you
Z

[MFGF]

Hi,

You can define named levels in TM1 for use in Cognos 8 BI.  In Architect or Perspectives, first enable display of the control cubes and dimensions (View -> Display Control Objects), then expand Cubes and double-click the }HierarchyProperties cube.  If not displayed already, set up a view with Dimensions in the rows and }HierarchyProperties in the columns.  For each dimension, you can then enter names for Level000, Level001, Level002 etc.

Finally, make sure that your TI process has the RefreshMdxHierarchy(''); function call - typically in the Prolog.

Hope that helps!

MF.

[Hevex]

Thank you MF for the detailed answer it is working!!!

I had a look at the other control cubes / dimensions, and I think that answered my other question,
there is only one hierarchy as such "hierarchy0" created in the }hierarchies control dimension and
the edit option is disabled, that probably means that this cannot be done.

[dusherwo]

Would be nice - but TM1 doesn't currently support distinct named hierarchies. Wish it did.