TI Functions

TM1 Function for TI – ​​​CubeATTRNL

Available In



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


CubeATTRNL(CubeNameAttributeName, [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.
Video Demo

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