TM1 Cube Size
-
- Posts: 5
- Joined: Wed Apr 06, 2011 3:32 pm
- OLAP Product: cognos
- Version: 9.5
- Excel Version: 2007
TM1 Cube Size
Where do we get information about the size of Cube on the TM1 Server
-
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
Re: TM1 Cube Size
Many ways:
Select the Cubes item. The RAM footprint of the cube is over on the right. You can click on the column heading to sort.
Run Performance Monitor, and look at }StatsbyCube. This gives you more detail about what is using the RAM ie input data, feeders, etc.
To find the disc footprint of the cube, look in the server directory - maybe I'm being a bit too obvious here
.
Select the Cubes item. The RAM footprint of the cube is over on the right. You can click on the column heading to sort.
Run Performance Monitor, and look at }StatsbyCube. This gives you more detail about what is using the RAM ie input data, feeders, etc.
To find the disc footprint of the cube, look in the server directory - maybe I'm being a bit too obvious here

- rkaif
- Community Contributor
- Posts: 328
- Joined: Fri Sep 05, 2008 6:58 pm
- OLAP Product: IBM Cognos TM1
- Version: 9.1 or later
- Excel Version: 2003 or later
Re: TM1 Cube Size
In the Server Explorer, Click on the Cubes and then in the Properties Window it will tell you the size of the cubes.
See the attached screenshot
See the attached screenshot
- Attachments
-
- Cube Size
- Cube_Size.jpg (55.63 KiB) Viewed 5262 times
Cheers!
Rizwan Kaif
Rizwan Kaif
- jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: TM1 Cube Size
As far as I am aware that is the size upon load. It doesn't tell you the actual cube size including cache and updates,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- wilsonric
- Posts: 15
- Joined: Mon Jan 10, 2011 4:36 am
- OLAP Product: TM1
- Version: 2.0.9
- Excel Version: 365 MSO 16-0-13127
- Location: Sydney, Australia
Re: TM1 Cube Size
We have found this list also includes cubes that are flagged to load on demand.
So they should not be consuming any RAM? Or at least very little?
So they should not be consuming any RAM? Or at least very little?
Regards,
Richard
Richard
-
- Posts: 124
- Joined: Wed Apr 03, 2019 12:10 am
- OLAP Product: IBM PA
- Version: 2.0.9.x
- Excel Version: Microsoft 365 x64
Re: TM1 Cube Size
I think any detailed analysis on RAM, as you suggest, should be done using performance monitor. It will give you quite granular breakdown. ROT is that TM1, to date, does not give back any memory once it takes it from the OS.