TI to load cube in 9.0?

Eeyore · Post by **Eeyore** » Wed Jul 15, 2009 1:22 pm

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.

wissew · Post by **wissew** » Wed Jul 15, 2009 1:33 pm

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

Steve Rowe · Post by **Steve Rowe** » Wed Jul 15, 2009 2:57 pm

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.

Alan Kirk · Post by **Alan Kirk** » Wed Jul 15, 2009 9:23 pm

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.

lotsaram · Post by **lotsaram** » Wed Jul 15, 2009 10:55 pm

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

Alan Kirk · Post by **Alan Kirk** » Wed Jul 15, 2009 10:58 pm

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.

lotsaram · Post by **lotsaram** » Wed Jul 15, 2009 11:36 pm

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.

Alan Kirk · Post by **Alan Kirk** » Thu Jul 16, 2009 12:06 am

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

Eeyore · Post by **Eeyore** » Thu Jul 16, 2009 1:36 pm

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.

TM1 Forum

TI to load cube in 9.0?

TI to load cube in 9.0?

Re: TI to load cube in 9.0?

Re: TI to load cube in 9.0?

Re: TI to load cube in 9.0?

Re: TI to load cube in 9.0?

Re: TI to load cube in 9.0?

Re: TI to load cube in 9.0?

Re: TI to load cube in 9.0?

Re: TI to load cube in 9.0?