ViewExtractSkipConsolidatedStringsSet is a new TM1 TurboIntegrator function introduced in TM1 10.2.2 Fix Pack 3 (10.2.2.3).
This function sets an option to exclude strings on consolidated values that are
excluded from a view or any associated view extracts.
This function sets an option to exclude strings on consolidated values that are excluded from a view or any associated view extracts.
TM1® allows the storing of strings on calculated values. When you exclude a calculated value from a view or view extract you may want to exclude the message string also from the view.
This is a TM1 TurboIntegrator function, valid only in TurboIntegrator processes.
A view extract is a TM1 view exported as an ASCII comma-delimited (.cma) file.
Note: This function affects views as they exist on the server. The scope of this function is not restricted to extracts generated from a view.
ViewExtractSkipConsolidatedStringSet (Cube, ViewName, Flag);
|Cube||The parent cube of the view for which you are setting the option.|
|ViewName||The view for which you are setting the option.|
|Flag||A binary value that turns the option on or off. Specify 0 to include strings stored on consolidated values. This is the current and default behavior. Specify 1 to exclude strings stored on consolidated values.|
ViewExtractSkipConsolidatedStringsSet ('99sales', '1st QuarterActuals', 1);
This example turns on the Skip Consolidated String option for the extract created from the 1st Quarter Actuals view. The extract will not include any string on the consolidated value.
15 June 2018