TI Functions

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

Available In



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

Use in the Prolog tab. 


ViewExtractSkipConsolidatedStringsSet(CubeNameViewName, 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.