ViewZeroOut TM1 Function: Syntax and Use

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

Syntax

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

Example

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.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.
This entry was posted in TI Functions, TM1 Admin. Bookmark the permalink.