TM1 Forum

Hello,

I had to change some code element values in a cube. To do this I exported the cube's data, changed the values(update queries), imported the altered data to a new cube.

The issue/mystery is the "Memory Used for Input Data" in the original cube is much larger than it is in the new cube.

Source Cube:
Memory Used for Input Data 1,910,502,400
Number of Populated Numeric Cells 2,550,604
Number of Fed Cells 155,234,934

New Cube:
Number of Populated Numeric Cells 2,552,400
Memory Used for Input Data 225,047,552
Number of Fed Cells 13,344,640

Note: the cube is only 31 MB on disk so I am more comfortable with the new number. The source cube and New cube have the same dimensions. Only the elements of one dimesion were changed.

There is a small variance in the Number of Populated Numeric Cells; this is expected. Since some elements were rollup up to new elements (A, B, C in old cube) is 'D' in the new cube.

The Process:
A) I exported the data from "Cube A" by selecting 'Export to Ascii' with the Skip consolidated Values, Skip Rule Based
Values, and Skip Zero Blank values options selected.

B) Changed a few of the code values by importing the data to a database and running update queries.

C) Imported the file created in step B with a Ti process. No rejects.

I can not account for the large difference in the Memory Used for Input Data.

Thanks,

Walt

I put together a small cube. The cube had 3 dims: Year, Month, Account.

Found the following about the {StatsByCube view.

New Cube - has not data:
Memory Used for Input data: 17408
Number of Populated Number Rows: 0

Added a value to 36 cells- entered '100'
Memory Used for Input data: 33792
Number of Populated Number Rows: 36

Added a Rule (['child0'] = N:2;) to override the 36 values.
Memory Used for Input data: 33792
Number of Populated Number Rows: 36

Removed Rule
Memory Used for Input data: 33792
Number of Populated Number Rows: 36

Adding a rule to an area that had 36 static values resulted in deleting the 36 static values. The values now all contain a value of '0'

The { StatsbyCube view displays the incorrect number of Populated Rows. They are all now zero.
The view also diasplays the incorrect Memory Used for Input data. There is no more input data.
Even after waiting several minutues, the values will not change in the view,

The only way to set these 2 values to their original values is to shut down and restart the server. I tried stopping and restrating Performance Manager.


Restart of Server
Memory Used for Input data: 17408
Number of Populated Number Rows: 0


This answers some of my questions.

I still do not know why the original cube is as large as it is.

Any ideas?

Thanks,

Walt