Export (0) Print
Expand All

How to create a custom rollup operator for a shared dimension

SQL Server 2000

To create a custom rollup operator for a shared dimension

  1. Access the dimension that will contain the custom rollup operator by right-clicking the dimension, and then click Edit.

  2. In Dimension Editor, in the tree pane, click the level for which to create the custom rollup operator.

  3. If the properties pane is not expanded, expand it by clicking Properties beneath the tree pane.

  4. In the properties pane, click the Advanced tab.

  5. Click the value beside Unary Operators, and then click the edit (...) button.

  6. In the Define Unary Operator Column dialog box, select the Enable Unary Operators check box to enable custom rollup operators for the level.

  7. Create or select an existing column to store the custom rollup operators:
    • To create a new column in the dimension table, select Create a new column, and then in the New column name box, type the name of the 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 (that is, the column for the level selected in Step 2.) For example, if in Step 2 you selected the Store Country level, and its members are stored in the store_country column, in the New column name box, type:

      store_country_custom_rollup_operator
      

      Note  If the dimension is not write-enabled, you must use a tool other than Dimension Editor or Analysis Manager to add values to the new column.

    • To select an existing column in the dimension table, select Use an existing column, and then in the Existing column box, select the column.
  8. In the Define Unary Operator Column dialog box, click OK.

  9. On the File menu, click Save.

    After you perform this procedure once for a level, you do not need to repeat it as long as the column that stores the custom rollup operators remains in the dimension table.

  10. (Optional.) To browse your custom rollup operators, click the Data tab, and then expand the dimension members pane. Custom rollup operators are indicated next to member names. If you created a new, unpopulated column in Step 7, the plus operator (+), which is the default rollup operator, will display beside the member names.

  11. (Optional.) To edit custom rollup operators in a write-enabled parent-child dimension, select a dimension member from the dimension members pane, and then select an operator in the column beside UNARY_OPERATOR in the member properties pane.
    • After editing, click Save on the File menu to commit changes to the dimension table.

      Note  Before you can edit the write-enabled dimension, it must be included in a cube, and then the cube must be processed.

Show:
© 2014 Microsoft