<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

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