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?
Unwanted TM1 dimension hierarchy levels showing up in Cognos report(Solved)
-
- 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)
- Attachments
-
- Img1.JPG (164.02 KiB) Viewed 4581 times
Last edited by escape18in on Fri Sep 22, 2017 1:29 pm, edited 1 time in total.
- jim wood
- Site Admin
- Posts: 3952
- 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
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
Tried RefreshMdxHierarchy('') but it did not work for me.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
- Steve Rowe
- Site Admin
- Posts: 2420
- 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
I vaguely remember that this could happen if elements were in more than one consolidation in the dimension.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
- 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
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
-
- 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)
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.