MSAS: Creating Custom Rollups Page - 3

Creating a custom rollup operator for a private dimension

1. Access the cube with the private dimension that will contain the custom rollup operator by right-clicking the cube, and then click Edit.
2. In Cube 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.

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.

In the Define Unary Operator Column dialog box, click OK.

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.

(Optional.) To browse custom rollup operators stored in an existing column, click the Schema tab, right-click the dimension table containing the stored operator, and then click Browse Data. Custom rollup operators are indicated in the respective column indicated in Step 7 for the first 1000 rows of data.

(Optional.) To edit custom rollup operators of a writable dimension, right-click the dimension in the Cube Editor tree pane and click Browse to display Dimension Browser. In the Dimension Browser tree pane, select the dimension member that has the custom rollup operator that you want changed. Click the value next to UNARY_OPERATORS in the member properties pane to modify the value for the selected member.

Note If a dimension with a custom rollup operator is included in a cube that has a measure where the value of its Aggregate Function property is set to Distinct Count, an error will occur when the cube is saved. This is due to invalid cube structure.