AttrInsert TM1 Function: Use and Sytax

Sometimes we want to create a new attribute in TM1 dynamically during the execution of a TI process. This function allows us to do that and create either a string, a numeric or an alias attribute.

Syntax of AttrInsert

The syntax is:

AttrInsert ( DimName, PrevAttr, AttrName, Type ); where:

  • DimName – is the name of the dimension that you want to create an attribute on
  • PrevAttr – is the name of the attribute immediately before the new attribute that you want to insert (so you get the attributes in the right order!).
  • AttrName – is the name of the new attribute you are creating
  • Type – is the type of attribute you are creating, either ‘N’, for numeric, ‘S’ for string or ‘A’ for an alias.

Example of AttrInsert

DimName = ‘Employees’;

AttrInsert ( DimName,  ‘Name’,  ‘Status’ , ‘S’ );

Here we have defined a variable called DimName with ‘Employees’ in the Prolog. Then lower down in the Prolog we have used the variable to tell the AttrInsert to create a new String attribute called ‘Status’ in the Employees dimensions after the existing ‘Name’ attribute.

Real World Usage

Interestingly we had immediately prior to this function in our TI used AttrDelete to delete the attribute. This effectively clears out all the values in the attribute before then on the Metadata or Data tab we re-populate it with current information.

Note that if you are going to create an attribute and then populate it in a single TI, you must create the attribute on the Prolog tab and then populate it on either the Metadata or Data tab.

This function can only be used in Turbo Integrator processes.

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.
This entry was posted in TI Functions and tagged AttrInsert. Bookmark the permalink.

One Response to "AttrInsert TM1 Function: Use and Sytax"

Log in to post a comment.