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?
Calculating the Number of Populated Cells within a Cube?
-
- Posts: 3
- Joined: Mon Sep 08, 2008 8:08 am
- 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?
Enable the Performance Monitor, you can then look at the }StatsByCube cube that contains the number of populated cells for each cube.
-
- Posts: 3
- Joined: Mon Sep 08, 2008 8:08 am
Re: Calculating the Number of Populated Cells within a Cube?
Ok, Thanks for that.
Re: Calculating the Number of Populated Cells within a Cube?
How kann i Enable the Performance Monitor ?
- 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?
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:
or add this line in your tm1s.cfg to get it to start by default with your server:
Code: Select all
PerformanceMonitorOn=T
-
- 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?
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.