Exploring TM1 - a Chartertech Company
Search
Close this search box.

AttrDelete TM1 Function: How to Use and Syntax

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 we used this function in our TI, we added an AttrInsert to re-insert the attribute. The combination of the two functions was meant to effectively clear the contents of the attribute before then re-populating it with current information on the Metadata or Data tab. However, when we applied it to an alias, we got an error saying the alias values were not unique. It appears this is an issue internal to the TM1 engine that can only be overcome by either clearing the alias values, saving and restarting the TM1 model, or deleting the alias in one TI and adding it back in a separate TI with the new values.

Notes

This function can only be used in Turbo Integrator processes.

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In