TM1 Forum

Hi experts,

Kindly let me know how to delete history of records in TM1 Cube using TI process?

Thanks

You will need the function, applied to a view on a cube. Use the function, and a bunch of other functions.
Most probably, the view creation has been scripted in the same process, but that's not needed.
It could even be a view that you save manually in the cube viewer (it's also possible to clear the data manually in the cube viewer).

Simple example along these lines:

# Create View
sView = cTI|NumberToString(Rand*Rand);

IF( ViewExists( cubDestination, sView ) = 1 );
ViewDestroy( cubDestination, sView );
ENDIF;

ViewCreate( cubDestination, sView );

ViewZeroOut( cubDestination, sView );

Obviously you will have to create subsets for dimension with elements you want to clear e.g. Jun 2013 Budget data..

Check out this link with all Subset function:

http://pic.dhe.ibm.com/infocenter/ctm1/v9r5m0/index.jsp

Try to write a simple ZeroOut process and when you get stuck let us now.

Thanks

ET

@EvgenyT : Thanks a ton.. I was able to achieve my requirement.

You are welcome