AttrN function for IBM Planning Analytics (TM1)

AttrN returns the numeric attribute for a specified element of a dimension. This function can be used to enhance data analysis, improve report quality and create more sophisticated calculations.

In the video, AttrN will be used to retrieve an attribute’s value from the Organisation dimension.

Where can the AttrN function be used?

Rules and TurboIntegrator

Which TM1 Server version is the AttrN function available for?

Version 11 and 12

What is the syntax for AttrN?

AttrN(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

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