TM1 Function for TI, ViewExtractSkipConsolidatedStringsSet

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?


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.