Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)

Post Reply
escape18in
Posts: 22
Joined: Tue Feb 03, 2015 10:22 am
OLAP Product: IBM Cognos BI
Version: 10.2
Excel Version: Excel 2010

Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)

Post by escape18in » Wed Sep 20, 2017 12:31 pm

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?
Attachments
Img1.JPG
Img1.JPG (164.02 KiB) Viewed 219 times
Last edited by escape18in on Fri Sep 22, 2017 1:29 pm, edited 1 time in total.

User avatar
jim wood
Site Admin
Posts: 3494
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report

Post by jim wood » Wed Sep 20, 2017 1:43 pm

Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

escape18in
Posts: 22
Joined: Tue Feb 03, 2015 10:22 am
OLAP Product: IBM Cognos BI
Version: 10.2
Excel Version: Excel 2010

Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report

Post by escape18in » Thu Sep 21, 2017 4:40 am

jim wood wrote:
Wed Sep 20, 2017 1:43 pm
You might want to look at this:

http://www.tm1forum.com/viewtopic.php?f ... 887#p66832
Tried RefreshMdxHierarchy('') but it did not work for me.

User avatar
Steve Rowe
Site Admin
Posts: 1662
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report

Post by Steve Rowe » Thu Sep 21, 2017 8:20 am

I vaguely remember that this could happen if elements were in more than one consolidation in the dimension.

User avatar
qml
MVP
Posts: 1042
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report

Post by qml » Thu Sep 21, 2017 2:34 pm

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.
Kamil Arendt

escape18in
Posts: 22
Joined: Tue Feb 03, 2015 10:22 am
OLAP Product: IBM Cognos BI
Version: 10.2
Excel Version: Excel 2010

Re: Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)

Post by escape18in » Fri Sep 22, 2017 1:28 pm

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.

Post Reply