Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    AttrInsert function for IBM Planning Analytics (TM1)

      AttrInsert creates a new attribute for a dimension.

      In the video, AttrInsert will be used to create the Gender attribute to the Employee dimension.

      Where can the AttrInsert function be used?

      TurboIntegrator

        Which TM1 Server version is the AttrInsert function available for?

        Version 11 and 12

          What is the syntax for AttrInsert?

          AttrInsert(DimName, PrevAttr, AttrName, Type)

          • DimName = The dimension for which you want to create an element attribute.​
          • PrevAttr = The attribute that precedes the attribute you are creating.​
          • AttrName = The name you want to assign to the new attribute.​
          • Type = The type of attribute. There are three possible values for the Type argument:
            • N – Creates a numeric attribute.​
            • S – Creates a string attribute.​
            • A – Creates an alias attribute.

          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