Arrange the Dimensions in Cube

Post Reply
krithika331
Posts: 44
Joined: Thu May 01, 2014 12:46 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Arrange the Dimensions in Cube

Post by krithika331 »

The arranging of order of the dimensions in the Cube should be from the Less sparse to more dense. The Re-order dimension option in the Cube is different from arranging the Dimensions in the Cube?? When I test the re-ordering of dimensions option I got the percentage as 0 % and when I selected the User option and shuffled the dimensions , I got as 18 % . Does this mean that this changed order is occupying more RAM space and is this suggestible?? I am new to TM1.


Thanks in Advance !!
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Arrange the Dimensions in Cube

Post by lotsaram »

You want to achieve a NEGATIVE % number as the difference. A positive change indicates the new dimension order arrangement is consuming more memory and is therefore less efficient than the current ordering.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
BariAbdul
Regular Participant
Posts: 424
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: IBM TM1, Planning Analytics, P
Version: PAW 2.0.8
Excel Version: 2019

Re: Arrange the Dimensions in Cube

Post by BariAbdul »

Hi krithika331,You might also find below link useful:
http://publib.boulder.ibm.com/infocente ... 81156.html
"You Never Fail Until You Stop Trying......"
Post Reply