TM1 Cube Size

Post Reply
pooja11284
Posts: 5
Joined: Wed Apr 06, 2011 3:32 pm
OLAP Product: cognos
Version: 9.5
Excel Version: 2007

TM1 Cube Size

Post by pooja11284 »

Where do we get information about the size of Cube on the TM1 Server
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: TM1 Cube Size

Post by David Usherwood »

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 :) .
User avatar
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

Post by rkaif »

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
Attachments
Cube Size
Cube Size
Cube_Size.jpg (55.63 KiB) Viewed 5266 times
Cheers!
Rizwan Kaif
User avatar
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

Post by jim wood »

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.
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
User avatar
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

Post by wilsonric »

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?
Regards,
Richard
Adam
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

Post by Adam »

wilsonric wrote: Tue Feb 09, 2021 5:26 am 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?
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.
I've started blogging about TM1, check it out: www.havaslabs.com

Take care,
Adam
Post Reply