I came across this extremely simple method of just zapping the data from a view in a TM1 cube today, ViewZeroOut literally removes all data from a view. .
The syntax is just ViewZeroOut ( cubename, viewname ); where
- cubename – is the name of the cube you want to remove data from, and
- viewname – is the name of the view
sCube = 'Assumption';
sView = 'This Year';
ViewZeroOut ( sCube, sView );
This will remove all data from the view This Year from the Assumption cube.
Want to remove all data from a cube?
If you want to remove all data from a cube, use the CubeClearData function instead.