TM1 Forum

There is a CubeUnload TI function in ver 9.0, but no CubeLoad counterpart. Is there a simple way to trigger an unloaded cube to reload using a TI process? I want to setup the unload/reload in a chore to run after hours. Thanks.

If you have a rule on the cube you and a rule worksheet you can use RuleLoadFromFile to load the cube to memory. See the help files for the syntex.

I'm quite curiuos as to why you are unloading the cube in the process.

Wes

I think there is a ViewConstruct function that will reload the cube too, depends what you want todo. Any reference to the cube should I think reload it.

Eeyore wrote:There is a CubeUnload TI function in ver 9.0, but no CubeLoad counterpart. Is there a simple way to trigger an unloaded cube to reload using a TI process? I want to setup the unload/reload in a chore to run after hours. Thanks.

As I think Steve was alluding to, all you need to do is use a CellGetN call (in any of the tabs) to retrieve any value out of the cube. That automatically reloads it into memory.

... but the question remains as to why you would want to unload the cube in the first place, if only to reload it.

lotsaram wrote:... but the question remains as to why you would want to unload the cube in the first place, if only to reload it.

My guess is that it's a quick and dirty but certain way to dump all of the calulated values.

Memory matters, especially to those of us still on 32 bits.

Ah yes 32 bit using v7 and v8, the server crashing when memory was exceeded and users being locked out which someone else calculated an big view or ran a process.

Yes those were the days, and do I miss them? NO NOT ONE LITTLE BIT.

lotsaram wrote:Ah yes 32 bit using v7 and v8, the server crashing when memory was exceeded and users being locked out which someone else calculated an big view or ran a process.

Yes those were the days, and do I miss them? NO NOT ONE LITTLE BIT.

Nor would I. But alas, in the current economic climate my CFO would miss the $xx,xxx that we'd need to upgrade both hardware and software more...

Thank you all for your input. RuleLoadFromFile does not appear to work; rule reloads but cube does not. The CellGetN call method does the trick.

As to why, Alan is correct - I purged a lot of old data out of a cube on a full server and was looking for the least disruptive way to release memory. Cube has a lot of rules and a long load time, which is why I wanted a way to schedule it to happen during non-working hours.

And yes, system upgrades are an idle fantasy these days.