ViewAttrSL

ViewAttrSL returns an attribute's string value for a specified view with respect to a given locale.

This function is valid in TM1® TurboIntegrator processes only.

Syntax

ViewAttrSL(CubeName, ViewName, AttrName, [LangLocaleCode]);

Argument

Description

CubeName

The parent cube of the view for which you want to return an attribute value.

ViewName

The view for which you want to return an attribute value.

AttrName

The attribute for which you want to retrieve a value. This argument must be a valid attribute of the view.

LangLocaleCode

This optional parameter specifies the language locale code for which you want to return a value.

Valid LangLocaleCode values correspond to the international language codes listed in the }Cultures control dimension.

When the LangLocaleCode is not specified or is omitted, the user's current locale is used as the LangLocaleCode argument.

If an attribute value does not exist for the LangLocaleCode, the value for an associated parent LangLocaleCode is returned. If an attribute value does not exist for an associated parent LangLocaleCode, the base attribute value is returned.

For example if the LangLocaleCode is fr-CA, the function returns the attribute value for the fr-CA (French-Canada) locale if available. If the attribute value for fr-CA is not available, the function attempts to return the attribute value for the parent fr (French) locale. If the attribute value for fr is not available, the base attribute value is returned

Example

In this example, the function returns the string value of the Manager attribute of the Sales view of the Plan_Business_Unit cube, for the French-Canada locale.

ViewAttrSL('Plan_Business_Unit', 'Sales', 'Manager', 'fr-CA');