x

The following objects appear on the Cube View tab.

Object	Description
	Characteristics. Contains the Properties and Hierarchies folders.
	Optional variable.
	Mandatory variable that is not satisfied (selection criteria has not been created).
	Mandatory variable that is satisfied (selection criteria has been created).
	Measure Group.
	Measure.
	Hierarchy.
	Hierarchy Field. Represents a leaf node in a parent/child hierarchy. A leaf node is a member of a hierarchy that does not have any children.
	Attribute Folder.
	Attribute.
	Virtual Attribute or Virtual Measures Folder.
	Virtual Attribute Folder.

For more information about other standard objects that may appear in the Synonym Editor, see Synonym Editor Main Attributes.

x

To edit field names and titles:

1. From the Projects or Data Servers area, open a synonym by double-clicking a Cube Master File from the Master Files folder.

   Note: You may also right-click the synonym and select Edit in Synonym Editor.

   By default, the Synonym Editor opens to the last view used.

2. Select an attribute from the Cube View tab.

   Note: The attributes available depend on the type of synonym.

3. Click FIELD NAME, TITLE, or CAPTION on the right-hand side of the workspace.

   Note: The Synonym Editor does not let you make any changes that would render the Master File unusable. Therefore, you cannot edit any value field that is highlighted gray.

4. Manually edit the Field Name, Title, or Caption by typing in the value field.

   The edits are updated instantaneously in the Cube View tab.

5. Click Save to save the synonym.
6. To close the synonym, select Close from the File menu or click the control button in the upper-right corner.

x

To edit the title for multiple languages:

1. From the Projects or Data Servers area, open a synonym by double-clicking a Cube Master File from the Master Files folder.

   By default, the Synonym Editor opens to the last view used.

2. Select an attribute from the Cube View tab.
3. Click the browse (...) button, located on the far right of the TITLE or CAPTION value field.

   The Multilingual Titles dialog box opens.

4. You may add, edit, or delete a title for this field.

   To add an additional language for the title:

   1. Select a language from the drop-down list.
   2. Click Add.
   3. Type a description for the title field.

      

   To edit an existing specified title:

   1. Select the title and click Edit.

      You may also double-click the title.

   2. Manually type a title name.

   To delete a specified title:

   1. Select the title and language to be deleted.
   2. Click Delete.
5. Click OK to close the Multilingual Titles dialog box.
6. Click Save from the File menu to save the synonym.
7. To close the synonym, select Close from the File menu or click the control button in the upper-right corner.

x

To delete measures, dimensions, or parent/child hierarchies:

1. From the Projects or Data Servers area, open a synonym by double-clicking a Cube Master File from the Master Files folder.

   By default, the Synonym Editor opens to the last view used.

2. Select the attribute name that you want to delete.
3. Right-click and select Delete from the context menu.

   The attribute is deleted from the Cube View tab.

4. Click Save to save the synonym.
5. To close the synonym, select Close from the File menu or click the control button in the upper-right corner.

x

To create virtual measures with COMPUTE fields:

1. From the Projects or Data Servers area, open a synonym by double-clicking a Cube Master File from the Master Files folder.

   By default, the Synonym Editor opens to the last view used.

2. Open the Measures folder from the Cube View tab.
3. Right-click the Virtual Measures folder, select Insert, and then Virtual Measure.

   

   The Compute Calculator opens.

   

4. From the Compute Calculator, type a name for the column in the Name field.
5. You may type a descriptive title for the measure (COMPUTE) in the Title field.
6. Use the Expression tab and the calculator buttons to build the expression for the Measure (COMPUTE field).

   or

   Use the Relational Expression tab to build the expression.

   1. From the Relational Expression tab, click the Add New Row button.
   2. Use the drop-down lists to select the Field, Relation, and Type.

      Note: Parameters are not supported.

   3. Click the browse (...) button at the right of the Value input field.

      

      The Value Selection dialog box opens.

   4. Select from the available values and use the arrows to add or remove values.
   5. Click OK to close the Value Selection dialog box and return to the Relational Expression tab.

      The expression is added to the virtual measure.

   6. To add another expression, double-click a measure or dimension from the Fields/Variables tab on the right side of the Compute Calculator. The expression is added to the Relational Expression tab, where you can add the expression value.
   7. To delete an expression, select the number or field column of the expression and click the Delete button, or right-click it and select Delete selected row(s). The expression is removed from the Relational Expression tab.
7. You may click the Check expression and Sample Data buttons, located on the top right of the Compute Calculator, to verify that the expression is valid and to view sample data for the filter.
8. Click OK to close the Compute Calculator and return to the Synonym Editor.

   Note: To edit the Compute, Title, or Expression, you may do so directly from the Synonym Editor or you may click the browse (...) button at the right of the EXPRESSION value field to relaunch the Compute Calculator.