AttrDelete TM1 Function: Syntax and Use

To delete an attribute in TM1 or Cognos Express during the execution of a Turbo Integrator process we use the AttrDelete function.

Syntax of AttrDelete

The syntax is:

AttrDelete ( DimName, AttrName); where:

  • DimName – is the name of the dimension that you want to delete an attribute
  • AttrName – is the name of the new attribute you are deleting

Example

DimName = ‘Employees’;

AttrDelete ( DimName, ‘Status’ );

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 Attr Delete to remove the attribute called ‘Status’ in the Employees dimension.

Real World Usage

Interestingly immediately after to this function in our TI used AttrInsert to re-insert the attribute. The combination of the two functions effectively clears out all the values in the attribute before then on the Metadata or Data tab we re-populate it with current information.

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 AttrDelete. Bookmark the permalink.

One Response to "AttrDelete TM1 Function: Syntax and Use"

Log in to post a comment.