ViewAttrInsert

ViewAttrInsert creates a new attribute for views of a specific cube on your TM1® server. The function can create a string, numeric, or alias attribute.

This function is valid in TM1 TurboIntegrator processes only.

Note: If you update an existing view attribute, you must first delete the existing attribute using the function ViewAttrDelete. You can then use ViewAttrInsert to recreate the attribute with your desired changes. If you attempt to update an existing attribute without first deleting it, the insert fails without a warning or error. The existing attribute remains unchanged; it is neither updated nor overwritten.

Syntax

ViewAttrInsert( CubeName, PrevAttrName, NewAttrName, AttrType);

Argument

Description

CubeName

 The parent cube for which you want to insert a view attribute.

PrevAttrName

The attribute that precedes the attribute you are creating. If there is no previous attribute or you want the new attribute to be the first attribute for views, leave this argument empty.

NewAttrName

The name you want to assign to the new view attribute.

AttrType

The type of attribute. There are three possible values for the AttrType argument:

  • N - Creates a numeric attribute.
  • S - Creates a string attribute.
  • A - Creates an alias attribute.

Example

This example creates the Description string attribute for views of the Sales cube. This attribute is inserted after the Owner attribute.

ViewAttrInsert('Sales', 'Owner', 'Description', 'S');