TM1 Function for TI, ViewExtractSkipCalcSet

Skip or include consolidated values when exporting a view using ASCIIOutput.

What is the ViewExtractSkipCalcSet function?

ViewExtractSkipCalcSet skips or includes consolidated values when exporting a view using ASCIIOutput. Use in the Prolog tab.

Where can the ViewExtractSkipCalcSet function be used?


What is the syntax for ViewExtractSkipCalcSet?

ViewExtractSkipCalcSet(CubeName, ViewName, Flag)​;

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

A demonstration on how to use ViewExtractSkipCalcSet

Export the Summary view from the Product Scorecard cube and exclude consolidated elements.