
Can TM1 manage multiple hierarchies in cognos package?
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Can TM1 manage multiple hierarchies in cognos package?
Can we have more than one hierarchies in the tm1 10 control cube in package for report studio to use? 

- Michel Zijlema
- Site Admin
- Posts: 713
- Joined: Wed May 14, 2008 5:22 am
- OLAP Product: TM1, PALO
- Version: both 2.5 and higher
- Excel Version: 2003-2007-2010
- Location: Netherlands
- Contact:
Re: Can TM1 manage multiple hierarchies in cognos package?
If your question is whether you can supply different level names for different hierarchies in the same dimension in the }HierarchyProperties cube, than the answer is no.
Although there is a dimension }Hierarchies in this cube with the element 'hierarchy0', suggesting additional hierarchies could labeled, this is the only element TM1/C10 is looking at - manually added hierarchy elements are ignored.
Michel
Although there is a dimension }Hierarchies in this cube with the element 'hierarchy0', suggesting additional hierarchies could labeled, this is the only element TM1/C10 is looking at - manually added hierarchy elements are ignored.
Michel
- sachin
- Posts: 92
- Joined: Fri Jan 15, 2010 9:54 pm
- OLAP Product: Transformer,SSAS, EP, TM1
- Version: 7.3 2005 10.1 10.1.1
- Excel Version: 2013
- Contact:
Re: Can TM1 manage multiple hierarchies in cognos package?
Currently only one hierarchy is supported. I wish/hope newer release of the product does support it. Transformer supports it, so I am hoping in future, we will have alternate hierarchies available in RS from TM1.macsir wrote:Can we have more than one hierarchies in the tm1 10 control cube in package for report studio to use?
Check out my blog for some good information on TM1, SPSS
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: Can TM1 manage multiple hierarchies in cognos package?
TM1 supports - effectively - multiple hierarchies just fine. Sadly, the way it does it does not flow through to Cognos BI at all well. (It's not the only capability that loses much in translation.)
In short, an element in a TM1 dimension can have multiple parents as well as multiple children. So you get the numbers you want, but TM1 does not sort the rollups into distinct hierarchies.
In short, an element in a TM1 dimension can have multiple parents as well as multiple children. So you get the numbers you want, but TM1 does not sort the rollups into distinct hierarchies.
- macsir
- MVP
- Posts: 785
- Joined: Wed May 30, 2012 6:50 am
- OLAP Product: TM1
- Version: PAL 2.0.9
- Excel Version: Office 365
- Contact:
Re: Can TM1 manage multiple hierarchies in cognos package?
Thank you guys for the replies above. But is there any workaround to archieve this in cognos report development?