TM1 Function for TI, ViewSuppressZeroesSet
Hides or displays all rows and columns containing zero values in a cube view.
What is the ViewSuppressZeroesSet function?
ViewSuppressZeroesSet hide or display all rows and columns containing zero values in a cube view.
Where can the ViewSuppressZeroesSet function be used?
TurboIntegrator
What is the syntax for ViewSuppressZeroesSet?
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.
A demonstration on how to use ViewSuppressZeroesSet
Use ViewSuppressZeroesSet to hide all rows and columns containing zero values in the default view from the Sales Quota cube.