Skip or include strings on consolidated values when exporting a view using ASCIIOutput.
What is the ViewExtractSkipConsolidatedStringsSet function?
ViewExtractSkipConsolidatedStringsSet skips or includes strings on consolidated cells when exporting a view using ASCIIOutput.
Use in the Prolog tab.
Where can the ViewExtractSkipConsolidatedStringsSet function be used?
TurboIntegrator
What is the syntax for ViewExtractSkipConsolidatedStringsSet?
ViewExtractSkipConsolidatedStringsSet(CubeName, ViewName, Flag);
CubeName = Name of the cube
ViewName = Name of the view from the cube
Flag = Boolean flag. 1 to skip strings on consolidated values or 0 to include.
A demonstration on how to use ViewExtractSkipConsolidatedStringsSet
Export the comments view from the Product Scorecard cube to include consolidations and then show the result when consolidations are excluded.
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