IBM Support

The ViewExtractSkipConsolidatedStringsSet function sets an option to exclude strings on consolidated values

Fix Readme


Abstract

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.

Content

ViewExtractSkipConsolidatedStringsSet
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.


Syntax
ViewExtractSkipConsolidatedStringSet (Cube, ViewName, Flag);
Argument
Description
CubeThe parent cube of the view for which you are setting the option.
ViewNameThe view for which you are setting the option.
FlagA 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.
Example
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.

[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Turbo Integrator","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21701954