TM1 Function for TI, ViewSuppressZeroesSet

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

Available In

TurboIntegrator

Definition

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

Syntax

ViewSuppressZeroesSet(CubeNameViewName, 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.