Calculating the Number of Populated Cells within a Cube?

[Declanrodger]

Currently in the process of Archiving data and have simply been using a process that does a simple CellGetN and CellPutN from a current cube to its archive version. This however has resulted in problems with some of the larger cubes process' being ridiculously large and crashing the service, for the ones that do this i break the process up by only selecting a handful of elements from one of the dimensions at a time.
I was wondering however if there is a process or similar way anyone knows of that will list the number of populated cells in a cube so i can have a prior idea of which processes need splitting and how many times?

[bihints.com]

Enable the Performance Monitor, you can then look at the }StatsByCube cube that contains the number of populated cells for each cube.

[Declanrodger]

Ok, Thanks for that.

[bskalli]

How kann i Enable the Performance Monitor ?

[bihints.com]

in Server Explorer, right click the server -> Start Performance Monitor

or add this line in your tm1s.cfg to get it to start by default with your server:

Code: Select all

PerformanceMonitorOn=T

[bskalli]

Thank you

[ScottW]

If the performance monitor is on then make sure to turn logging off for the }Stats cubes. If the performance monitor runs for any length of time then the log files will get very very large if cube logging is left on.