TM1 Function for TI, ViewExtractSkipZeroesSet

Skip or include zeros when exporting a view using ASCIIOutput.

What is the ViewExtractSkipZeroesSet function?

ViewExtractSkipZeroesSet skips or includes zeros when exporting a view using ASCIIOutput.​

Use in the Prolog tab. 

Where can the ViewExtractSkipZeroesSet function be used?


What is the syntax for ViewExtractSkipZeroesSet?

ViewExtractSkipZeroesSet(CubeName, ViewName, Flag)​;

CubeName = Name of the cube​
ViewName = Name of the view from the cube​
Flag = Boolean flag. 1 to skip zeros or 0 to include.

A demonstration on how to use ViewExtractSkipZeroesSet

Export the view, By Year, from the Product Scorecard cube to exclude zeros then show the result when zeros are included.