Hi,
I nested many dimensions in columns in TM1 cube viewer in Architect and it draw the cells but, after about 250 columns, it does not display any numbers in the cells. It just displays the cells blank. Do you know if there is a way to increase this maximum number of columns displayed?
If I ran a viewconstruct for a view that has more than 250 columns, does that mean that the view is not fully constructed in TM1's memory for quick access?
Any comments will be appreciated.
Regards,
Maximum Number of Columns in Tm1 cube viewer
-
Christopher Kernahan
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
Re: Maximum Number of Columns in Tm1 cube viewer
Hi mce,
TM1 will still be calculating these numbers - you can check this by exporting it to ASCII/text file (Right click on View, Export as ASCII/text) and reviewing the file. It may be a GUI bug, if you scan across to somewhere where there are no numbers and press recalculate, will they display?
Why are you nesting them in columns? I tend to find that it is better to nest in rows given Excel has more rows available if you need to slice.
TM1 will still be calculating these numbers - you can check this by exporting it to ASCII/text file (Right click on View, Export as ASCII/text) and reviewing the file. It may be a GUI bug, if you scan across to somewhere where there are no numbers and press recalculate, will they display?
Why are you nesting them in columns? I tend to find that it is better to nest in rows given Excel has more rows available if you need to slice.