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.
See how Cubewise can help you
We would love to show you how a set of applications could help you forecast, budget and plan better.
Book
