Hi All,
We are using Cognos Tm1 10.2 and are experiencing some weird data formatting in Cube Viewer, Contributor & TM1WEB.
When we open a cube in cube viewer and drag multiple dimensions as rows, duplicate columns are not being separated by the first dimension, refer to attached screenshot.
(FYI - Status dimension has two columns - Cont and Comm).
What we would expect is similar to that of TM1 9.5.2 where status would be displayed as Comm for both rows as they fall under different schools.
Is anyone else having this issue in their environment? Any workarounds or tips?
Thanks in advance!
TM1 Cube Viewer 10.2 Diplay
-
spiderwallet
- Posts: 29
- Joined: Thu Jul 04, 2013 6:13 am
- OLAP Product: Cognos
- Version: 10.2.1
- Excel Version: 2010
TM1 Cube Viewer 10.2 Diplay
- Attachments
-
- example.jpg (17.77 KiB) Viewed 4352 times
-
jim wood
- Site Admin
- Posts: 3960
- 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: TM1 Cube Viewer 10.2 Diplay
Do you get the seperate lines when you export it to Excel? I've not really had chance to play with 10.2 yet so I haven't seen this,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
declanr
- MVP
- Posts: 1830
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 Cube Viewer 10.2 Diplay
What fixpack version are you using?
I do not get this in architect or web cube viewer (in 10.2 or any version). The attachment you've uploaded isn't of a cubeviewer, could you please take a screenshot of the cube view in question and post that?
I do not get this in architect or web cube viewer (in 10.2 or any version). The attachment you've uploaded isn't of a cubeviewer, could you please take a screenshot of the cube view in question and post that?
Declan Rodger
-
PlanningDev
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: TM1 Cube Viewer 10.2 Diplay
Might sound simple but that kind of view leads me to believe zero supression has been turned on and you arent showing all elements for all combinations.
-
spiderwallet
- Posts: 29
- Joined: Thu Jul 04, 2013 6:13 am
- OLAP Product: Cognos
- Version: 10.2.1
- Excel Version: 2010
Re: TM1 Cube Viewer 10.2 Diplay
Perfecto! Turning off Zero Suppression on all rows did the trick! Thanks PlanningDev.PlanningDev wrote:Might sound simple but that kind of view leads me to believe zero supression has been turned on and you arent showing all elements for all combinations.
Apparently this didnt happen with 9.5.2.. Interesting. Im still quite new to the Tm1 development space.
Thanks all.