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?
TurboIntegrator
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.