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

John Vaughan

John Vaughan

John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

Leave a Reply

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

Log In