TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​​​ViewSuppressZeroesSet

Available In

TurboIntegrator

Definition

ViewSuppressZeroesSet hides or displays all rows and columns containing zero values in a cube view.

Syntax

ViewSuppressZeroesSet(CubeName, ViewName, Flag)​

​CubeName = Cube Name​

ViewName = View Name​

Flag = A binary value where 1 will suppress columns and rows containing zero values. 0 will show the columns and rows with zero values.

Video Demo

​Use ViewSuppressZeroesSet to hide all rows and columns containing zero values in the default view from the Sales Quota cube.​

​​