Can TM1 manage multiple hierarchies in cognos package?

Post Reply
User avatar
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?

Post by macsir »

Can we have more than one hierarchies in the tm1 10 control cube in package for report studio to use? :?:
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
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?

Post by Michel Zijlema »

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
User avatar
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?

Post by sachin »

macsir wrote:Can we have more than one hierarchies in the tm1 10 control cube in package for report studio to use? :?:
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.
Check out my blog for some good information on TM1, SPSS
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Can TM1 manage multiple hierarchies in cognos package?

Post by David Usherwood »

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.
User avatar
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?

Post by macsir »

Thank you guys for the replies above. But is there any workaround to archieve this in cognos report development?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply