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.