IBM Support

Use "Make Texts Unique" when importing from SAP datasources to fetch Alias-attribute values.

Product Documentation


Abstract

The Make Texts Unique option is now required in order to fetch Alias attribute values when importing from an SAP-datasource.

Content

When you import a SAP-characteristic there two statements that are always generated for writing an alias attribute automatically, for example:

Prolog: ATTRINSERT('z_mager', '', 'SAP_TEXT', 'A');
Data: ATTRPUTS(V2, 'z_mager', V1_Mod, 'SAP_TEXT' ,1);

V2 is the automatically generated variable which includes the alias attribute value.

In TM1 version 9.5.2 the V2 variable does not contain any values so the only way to make the Alias attribute import is using the "Make Texts Unique" option found on the "Data Source" Characteristic tab.

If Make Text Unique is not checked, no SAP_TEXT value is fetched. 

Alternatively, when Make Text Unique is not checked, you can add DataSourceSAPUsingTexts=1; in the prolog to import the alias attribute values.

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

Document Information

More support for:
Cognos TM1

Software version:
9.5.2

Operating system(s):
Windows

Document number:
627891

Modified date:
17 June 2018

UID

swg27023860

Manage My Notification Subscriptions