Team,
I am getting issues while using TM1 cube as a datasource for cognos Analysis studio reports.
I have a cube with 7 dimensions which includes 1 measure dimension and 1 month dimension. i set the hierarchies in Hierachies control cubes for the dimension levels and imported the cube in cognos frameowrk manager.
while trying to create Analysis studio report using this cube, for two dimensions, it's showing folder icon instead of levels icon. i can't drag and drop these two dimension levels because of this issue.
Please see below screenshot in analysis studio:
Reg, Voy dimensions are displaying with folder icons instead of levels icons. where as other dim's are showing correctly as levels.
Anyone has faced similar issue?
Regards
Nare
Analysis studio reports issue with TM1 cube
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Analysis studio reports issue with TM1 cube
Do you have more than one top node for those dimensions? Have you set the name of for the level in the HierarchyProperties cube?
-
- Posts: 7
- Joined: Thu Apr 11, 2013 3:18 pm
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
- Location: Sydney, Australia
Re: Analysis studio reports issue with TM1 cube
Yes, we have 5 levels in reg dimension and only two levels in Voy dimension. also we have set the level names in Hierarchy properties controle cube.
Still the folder icon is coming, but how come the other dim's are working correctly and only the two dim's are showing folder icons.
Still the folder icon is coming, but how come the other dim's are working correctly and only the two dim's are showing folder icons.
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Analysis studio reports issue with TM1 cube
Its not the levels that creates that. If you have more than one TOP NODE. To the server this means you have more than one hierarchy and therfore it becomes difficult for it to represent so it shows it in a folder to represent more than one item.