Calculating the Number of Populated Cells within a Cube?

Post Reply
Declanrodger
Posts: 3
Joined: Mon Sep 08, 2008 8:08 am

Calculating the Number of Populated Cells within a Cube?

Post by 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?
User avatar
bihints.com
Posts: 52
Joined: Tue May 20, 2008 8:56 am
OLAP Product: TM1
Version: 9.0.3
Excel Version: 2003
Contact:

Re: Calculating the Number of Populated Cells within a Cube?

Post by 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
Posts: 3
Joined: Mon Sep 08, 2008 8:08 am

Re: Calculating the Number of Populated Cells within a Cube?

Post by Declanrodger »

Ok, Thanks for that.
bskalli
Posts: 21
Joined: Wed May 14, 2008 7:53 am

Re: Calculating the Number of Populated Cells within a Cube?

Post by bskalli »

How kann i Enable the Performance Monitor ?
User avatar
bihints.com
Posts: 52
Joined: Tue May 20, 2008 8:56 am
OLAP Product: TM1
Version: 9.0.3
Excel Version: 2003
Contact:

Re: Calculating the Number of Populated Cells within a Cube?

Post by 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
Posts: 21
Joined: Wed May 14, 2008 7:53 am

Re: Calculating the Number of Populated Cells within a Cube?

Post by bskalli »

Thank you
ScottW
Regular Participant
Posts: 152
Joined: Fri May 23, 2008 12:08 am
OLAP Product: TM1 CX
Version: 9.5 9.4.1 9.1.4 9.0 8.4
Excel Version: 2003 2007
Location: Melbourne, Australia
Contact:

Re: Calculating the Number of Populated Cells within a Cube?

Post by 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.
Cheers,
Scott W
Cubewise
www.cubewise.com
Post Reply