HierarchyAttrPutS function for IBM Planning Analytics (TM1)

Where can the HierarchyAttrPutS function be used?

TurboIntegrator

Which TM1 Server version is the HierarchyAttrPutS function available for?

Version 11 and 12

What is the syntax for HierarchyAttrPutS?

HierarchyAttrPutS(Text, Dimension, Hierarchy, Attribute, [Locale])

• text = string
• Dimension = Name of dimension
• Hierarchy = Name of hierarchy
• Attribute = Name of numeric attribute
• Locale = language locale code corresponding to the international language codes list in the }Cultures control dimension. If no locale is defined, the user’s current locale is used. An example of a language code is fr-CA, which is French-Canada.

Relevant Functions

• TM1GlobalSandbox = Returns the active sandbox for the user
• TM1Info = Returns information on the TM1 client
• TM1PrimaryDBName = Returns the primary TM1 server name the user is authenticated in
• TM1User = Returns the user logged in
• TM1Val = A hierarchy-aware formula that reads, writes, or clears a cell which works with TM1 Web and IBM Planning Analytics for Excel