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

HierarchyAttrPutS function for IBM Planning Analytics (TM1)

    HierarchyAttrPutS uploads text to a string attribute from a dimension’s hierarchy.

    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