TM1 Forum

hi All,

We use 10.2.2 with fix pack 6 and excel is 32 bit office 365. Server is hosted on 2012 R2.

I am trying to understand usage of CubeUnload function. I am struggling to understand in which scenario I should be using CubeUnload() function.

Whenever I perform CubeUnload on any cube, TM1Instance or TM1sd.exe doesnt release that memory to OS. The RAM consumption by TM1 remains as it is. I am assuming that with CubeUnload() function TM1 takes off space occupied by cube and that space can be re-used by TM1 to perform rule calculation or open views. I am not sure if thats the case. I need your views on it.

Currently our model is occupying 90% of total ram. What should I do to reduce memory footprint of TM1 Instance except deleting unnecessary cubes?

Also, I need to know the any scenarios where CubeUnload can be useful.

Regards!

Hi,

i use CubeUnload if it is necessary to restore just one cube and i don't want to restart the hole tm1 db.

If you want to save RAM, I don't think this will help. Therefor you have to check your rules and feeders - maybe they consume to much RAM.
Check your sturctures - maybe you can reduce them etc..
reorganize the order of the dimensions in your cube (i always to this via the assistant - and it helps)

regards,
orlando

TM1 never hands back memory to the OS.
If you can identify cubes which are not required and also not linked via rules or feeders to cubes you do need, you can set these to Load on Demand and reduce the RAM footprint.
Otherwise I agree with orlando - review your feeders using the Performance Monitor cubes, and look at resequencing your large cubes. You may need conditional feeders.

Or, buy some more memory

If you turn on Performance Monitor and open }Statsbycube cube, you'll see measures:
Memory Used
Memory In Garbage

When you use CubeUnload, the memory used by cube will moved from "Used" to "Garbage". As David said, it will never be released to OS, but it can be used inside TM1 for creating stargates and so on.

For example, you would use CubeUnload (or the equivalent in the user interface) to remove all feeders from a cube. Useful during debugging. Technical requirement: all views must be closed in Architect / Perspectives.

This is not a tool for limiting RAM consumption in a TM1 model. For that, you have to spend more time and review the contents of the rules files (*.rux).