Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    ViewAttrInsert function for IBM Planning Analytics (TM1)

      ViewAttrInsert creates a new attribute for a cube view. 

      In this video, ViewAttrInsert will be used to create an attribute, ‘Description’, for the Employee cube.

      Where can the ViewAttrInsert function be used?

      TurboIntegrator

        Which TM1 Server version is the ViewAttrInsert function available for?

        Version 11 and 12

          What is the syntax for ViewAttrInsert?

          ViewAttrInsert(CubeName, PreviousAttributeName, NewAttributeName, AttributeType)

          • ​CubeName = Name of the cube that has the view to receive the attribute.​
          • PreviousAttributeName = Name of the attribute that antecedes the new attribute (order). ​
          • NewAttributeName = Name of the new attribute to be added.​
          • AttributeType = Type of the attribute to be created. The attribute types are:​
            • N: Numeric attribute;
            • S: String attribute;
            • A: Alias attribute

          Relevant Functions

          • ViewAttrDelete = Deletes a view attribute from a cube
          • ViewAttrInsert = Creates a new attribute for a cube view
          • ViewAttrN = Returns a numeric attribute from a cube view
          • ViewAttrNL = Returns a numeric attribute from a cube view for a given language
          • ViewAttrPutN = Inserts a numeric value to an attribute for a cube view
          • ViewAttrPutS = Inserts a string to an attribute for a cube view
          • ViewAttrS = Returns a string from a cube view’s attribute
          • ViewAttrSL = Returns a string from a cube view’s attribute for a given language