Pages

Attribute Manipulation TurboIntegrator Functions in Cognos TM1

Attribute Manipulation TurboIntegrator Functions

These functions facilitate the manipulation of attributes.

AttrDelete:
This is a TM1 TurboIntegrator function, valid only in TurboIntegrator processes.
This function deletes an element attribute from the TM1 database.

Syntax:
AttrDelete(DimName, AttrName);

Arguments:
ArgumentDescription
DimNameThe dimension for which you want to delete an element attribute.
AttrNameThe name of the attribute you want to delete.

Example:
AttrDelete('Model', 'InteriorColor');
This example deletes the InteriorColor element attribute for the Model dimension.

AttrInsert:
This is a TM1 TurboIntegrator function, valid only in TurboIntegrator processes.
This function creates a new element attribute for a dimension. The function can create a string, numeric, or alias attribute.

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

Arguments:
ArgumentDescription
DimNameThe dimension for which you want to create an element attribute.
PrevAttrThe attribute that precedes the attribute you are creating.
AttrNameThe name you want to assign to the new attribute.
TypeThe type of attribute. There are three possible values for the Type argument:
  • N - Creates a numeric attribute.
  • S - Creates a string attribute.
  • A - Creates an alias attribute.

Example:
AttrInsert('Model', 'Transmission', 'InteriorColor', 'S');
This example creates the InteriorColor string attribute for the Model dimension. This attribute is inserted after the Transmission attribute.

AttrPutN:
This is a TM1 TurboIntegrator function, valid only in TurboIntegrator processes.
This function assigns a value to a numeric element attribute.

Syntax:
AttrPutN(Value, DimName, ElName, AttrName);

Arguments:
ArgumentDescription
ValueThe value you want to assign to an element attribute.
DimNameThe parent dimension of the element for which you want to assign an attribute value.
ElNameThe element for which you want to assign an attribute value.
AttrNameThe attribute whose value you want to assign.

Example:
AttrPutN(2257993, 'Model', ' S Series 1.8L Sedan ', 'ProdCode');
This example assigns the value 2257993 to the ProdCode attribute of the S Series 1.8L Sedan in the Model dimension.

AttrPutS:
This is a TM1 TurboIntegrator function, valid only in TurboIntegrator processes.
This function assigns a value to a numeric element attribute.

Syntax:
AttrPutS(Value, DimName, ElName, AttrName);

Arguments:
ArgumentDescription
ValueThe value you want to assign to an element attribute.
DimNameThe parent dimension of the element for which you want to assign an attribute value.
ElNameThe element for which you want to assign an attribute value.
AttrNameThe attribute whose value you want to assign.

Example:
AttrPutS('Beige', 'Model', 'S Series 1.8L Sedan', 'InteriorColor');
This example assigns the string Beige to the InteriorColor attribute of the S Series 1.8L Sedan in the Model dimension.

0 comments:

© 2010 Datawarehousing Support | Home | Disclaimer | Privacy Policy