Page 1 of 1
Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
Posted: Wed Sep 20, 2017 12:31 pm
by escape18in
Hi All,
My TM1 Cube is used in a Cognos report. i am pulling a leaf level data from TM1 to Cognos report. suddenly one of my dimension showing up unwanted concatenated hierarchy for most of elements instead of leaf level element. Can anyone tell what should be the issue?
Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report
Posted: Wed Sep 20, 2017 1:43 pm
by jim wood
Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report
Posted: Thu Sep 21, 2017 4:40 am
by escape18in
Tried RefreshMdxHierarchy('') but it did not work for me.
Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report
Posted: Thu Sep 21, 2017 8:20 am
by Steve Rowe
I vaguely remember that this could happen if elements were in more than one consolidation in the dimension.
Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report
Posted: Thu Sep 21, 2017 2:34 pm
by qml
Steve is right. Cognos BI needs a single, unique hierarchy path to each element. If there is more than one, because e.g. there are alternate hierarchies, it will use the full path to identify an element. And what is more, from Cognos's perspective each one of the instances of that element in the hierarchy tree will be treated as a different element, even though from TM1's perspective they are all one and the same.
Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
Posted: Fri Sep 22, 2017 1:28 pm
by escape18in
Thanks guys for reply.yes you guys are right there were more than one consolidation in my dimension which was causing this issue i corrected it and everything is fine.