Define Unary Operator Column Dialog Box
Use this dialog box to:
- Enable or disable the use of custom rollup operators.
- Create or select a column to store custom rollup operators. This column is created in or selected from the same dimension table that stores the members to which the custom rollup operators apply.
Custom rollup operators are simple mathematical functions that determine the cell values associated with members, and override the aggregate functions of measures. For write-enabled dimensions, custom rollup operators are created in the member properties pane of Dimension Editor (if the dimension is shared) or Dimension Browser. (This action requires that the write-enabled dimension is included in a cube that was processed since the dimension last changed.) For other dimensions, custom rollup operators are inserted into the dimension table using a tool outside Analysis Manager.
For more information about custom member formulas, see Custom Rollup Operators.
For related procedures and information on the behavior of specific custom rollup operators, see Using Custom Rollup Operators.
The Define Unary Operator Column dialog box appears when, in the tree pane of Dimension Editor or Cube Editor, you select a level, and in the Advanced tab of the properties pane, click the value beside Unary Operators, and then click the edit (...) button.
Options
Enable Unary Operators
Select to enable the use of custom rollup operators. This action sets the level's Unary Operators property to True. Cell values for members with custom rollup operators will be calculated according to the custom rollup operators.
Clear to disable the use of custom rollup operators. This action sets the level's Unary Operators property to False. Custom rollup operators will be ignored; cell values for members will be calculated according to the measures' aggregate functions.
Create a new column
Click to create a new column in which to store custom rollup operators. Specify the column name in the New column name box, which appears only when Create a new column is selected.
Use an existing column
Click to select an existing column in which to store custom rollup operators. Select the column in the Existing column box, which appears only when Use an existing column is selected.
Note If you select an existing column, its contents will be overwritten by the custom rollup operators.
New column name
Type the name of the column that will store custom rollup operators. This option is available only if you select Create a new column.
A dimension table can have multiple columns (one per level) that store custom rollup operators. Therefore, it is recommended that the new column name identify the column that stores the members to which the custom rollup operators apply. For example, if the members are stored in the store_country column, type:
store_country_custom_rollup_operator
Existing column
Select the column that will store custom rollup operators. This option is available only if you select Use an existing column.
OK
Click to temporarily save your changes and close the dialog box. To permanently save your changes, after this dialog box closes, on the File menu, click Save.