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

Post Reply
escape18in
Posts: 26
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 »

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 4388 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: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

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

Post by jim wood »

Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
escape18in
Posts: 26
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 »

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: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe »

I vaguely remember that this could happen if elements were in more than one consolidation in the dimension.
Technical Director
www.infocat.co.uk
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

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

Post 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.
Kamil Arendt
escape18in
Posts: 26
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 »

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