TI Functions

TM1 Function for TI – ​​​​​​​​​​​​​​​ViewExtractSkipConsolidatedStringsSet 

Available In

TurboIntegrator

Definition

ViewExtractSkipConsolidatedStringsSet skips or includes strings on consolidated values when exporting a view using ASCIIOutput.​

Use in the Prolog tab. 

Syntax

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.

Video Demo

Export the comments view from the Product Scorecard cube to include consolidations and then show the result when consolidations are excluded.

​