Page 1 of 1
Can TM1 manage multiple hierarchies in cognos package?
Posted: Tue Oct 16, 2012 9:12 am
by macsir
Can we have more than one hierarchies in the tm1 10 control cube in package for report studio to use?
Re: Can TM1 manage multiple hierarchies in cognos package?
Posted: Tue Oct 16, 2012 1:31 pm
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
Re: Can TM1 manage multiple hierarchies in cognos package?
Posted: Tue Oct 16, 2012 1:42 pm
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.
Re: Can TM1 manage multiple hierarchies in cognos package?
Posted: Tue Oct 16, 2012 10:42 pm
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.
Re: Can TM1 manage multiple hierarchies in cognos package?
Posted: Wed Oct 17, 2012 1:08 am
by macsir
Thank you guys for the replies above. But is there any workaround to archieve this in cognos report development?