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.