TM1 Function for TI, ​CubeAttrNL

Retrieves data from a numeric attribute for a cube by language locale.

What is the CubeAttrNL function?

CubeAttrNL retrieves data from a numeric attribute for a cube by language locale.

Where can the CubeAttrNL function be used?

TurboIntegrator

What is the syntax for CubeAttrNL ?

CubeAttrNL(CubeName, AttributeName, [LangLocaleCode]);​

​CubeName = Cube to have the numeric attribute retrieved.​
AttributeName = Name of the attribute to pull the information from.​
LangLocaleCode = Specifies the language code the attribute will be retrieved from (ISO 639-1).​
– If blank or ignored, TM1 will pull the user’s current locale.​
– If attribute value does not exist for the given locale, TM1 will pull the value from its parent. If attribute value for the parent does not exist,TM1 will pull the base value.  

A demonstration on how to use …

Use CubeAttrNL to retrieve data from the numeric attribute, Number of Dimensions, for the Employee cube.