AttrNL function for IBM Planning Analytics (TM1)
AttrNL returns the value from a numeric attribute for a specified element of a dimension from a different language.
In the video, ATTRNL will be used to retrieve an attribute’s value from the Weekday dimension.
Where can the AttrNL function be used?
TurboIntegrator
Which TM1 Server version is the AttrNL function available for?
Version 11 and 12
What is the syntax for AttrNL?
AttrNL(Dimension, Element, Attribute)
- Dimension = Dimension name
- Element = Element name to retrieve the attribute from
- Attribute = The attribute for which you want to retrieve the value
- LangLocaleCode = the language locale code to which the value applies. It’s an optional parameter. When it’s omitted, the base attribute value is updated.
Relevant Functions
- AttrDelete = Deletes an attribute for a dimension
- AttrInsert = Creates a new attribute for a dimension
- AttrN = Returns the numeric attribute for a specified element of a dimension
- AttrNL = Returns a numeric attribute for an element in a dimension for a different language
- AttrPutN = Uploads a value to a numeric attribute for an element.
- AttrPutS = Uploads a string into an attribute to an element
- AttrS = Returns the string attribute for a specified element of a dimension
- AttrSL = Returns a string attribute for an element for a different language