Add Area

You can build a Value expression by combining parameters, operations, functions, and literals. Use the fields and button in this area of the form to build the Value expression:

• In the Type field, select one of these options and then select the appropriate row from the grid:
  • Attribute Text: The grid lists the available attributes. When selected, the attribute name is displayed. In the Value text box, this appears as A(attribute). Using literals can be used to develop strings based on a concatenation of string values. This results in consistent descriptions that can be modified across dimensions.
  • Attribute Value: The grid lists the available attributes. When selected, the attribute value displays. In the Value text box, this appears as V(attribute).
  • Parameter: The grid displays a list of the available tables and columns that were defined for this object on the Dimension Table Joins form. Select a table and column from the list. Use the Table field to filter the grid for a specific table.
  • Operation: The grid displays a list of available operations.
  • SQL Function: The grid displays a list of the functions defined on the Dimension Functions form.
• Click Add to add your selection to the Value text box. This button is enabled only if the currently selected attribute’s Type is set to Function.
• Literals must be typed in the text box and are designated as L(value). Literals can be concatenated with V(Attribute). For example, you could create the attribute Account Number with a value of A(Account) + L(-) + V(Account). This attribute is displayed as, for example, Account-11200.