TM1 Forum

Good Day !

Hi Everyone,

I just want to ask what'd be the best way, easiest and fastest, to delete all cubes' data in a single TM1 instance (about 20+ cubes). Although I'm thinking the best way is to loop (using TI) in the control object containing all the cube names and just create a view to zeroout the contents. This is assuming that no single dimension is common to all of the cubes. I know 9.5 has this CubeClearData, I tried that in 9.4, didn't work.

So, am I correct, is that the best way?

Thanks for the help guys.

Bunch

Not sure if you would consider this as the best. will enter 'c' on the the highest consolidation element in the cube help ?
else you will be spending time developing something which you will only you once.

Hi Sir!

I'm sorry, but I didn't quite understand.

Can you please elaborate?

Thanks very much Sir!

It will only make sense to use this method if you have only one highest consolidation element across all dimension.
eg, All Customers, All Periods, All Measures. If you have many highest consolidation element, then it will be equally time consuming as you have to enter 'C' across all cross point..

entering 'c' onto the cell will clear data at that level and all level below it.

or probably you can try ViewDestroy, ViewCreate and viewzeroout. I believe this should be supported in 9.4.

I get it now Sir.

I never knew that entering 'c' on the intersections of the all the highest consolidated elements per dimension of a cube would clear the data. Is that another trick? Because based on my and others' experience, it would be an error to input a value on a consolidated element, but this one is 'c'.

Winsonlee wrote:

or probably you can try ViewDestroy, ViewCreate and viewzeroout. I believe this should be supported in 9.4.

Yes Sir, this is what I'm trying to explain on my first message. A TI will look up on the control object containing all cube names, then after every cube name, I'll create a view, then zero it out.

I'm just wondering, if there are other better ways to do that.

Give it a try. usually you wont be able to write anything on a consolidated element. But 'c' is an exceptional character.

bunchukokoy wrote:I get it now Sir.

I never knew that entering 'c' on the intersections of the all the highest consolidated elements per dimension of a cube would clear the data. Is that another trick? Because based on my and others' experience, it would be an error to input a value on a consolidated element, but this one is 'c'.

bunchukokoy wrote:Good Day !

Hi Everyone,

I just want to ask what'd be the best way, easiest and fastest, to delete all cubes' data in a single TM1 instance (about 20+ cubes). Although I'm thinking the best way is to loop (using TI) in the control object containing all the cube names and just create a view to zeroout the contents. This is assuming that no single dimension is common to all of the cubes. I know 9.5 has this CubeClearData, I tried that in 9.4, didn't work.

So, am I correct, is that the best way?

Thanks for the help guys.

Bunch

If you do nothing more than create a view with TI and don't assign any subsets then the default subset for each dimension in the view will be 'ALL'. Therefore if you want to delete all cube data you don't need much more code with ViewZeroOut than you would with CubeClearData. This is definitely better than doing a top down clear spread for each cube.