Set Custom Rollups (Dimension Wizard)

In this step of the wizard, you enable and define custom rollup expressions.

This step is displayed only if you selected Custom rollups in the Select advanced options step of the wizard.

Options

Enable custom rollups

Select to enable custom rollup expressions for the new dimension.

• Operator-defined custom rollup

  Select to use mathematical operators to define the custom rollup.

• Operator column

  Type the name of the existing dimension table column that will store the mathematical operators, or click the edit (...) button to display the Define Custom Member Column dialog box, where you can select an existing column or define a new one.

• MDX-defined custom formula

  Select to use a Multidimensional Expressions (MDX) expression to define the custom rollup.

• Expression column

  Type the name of the existing dimension table column that will store the MDX expressions, or click the edit (...) button to display the Define Custom Member Column dialog box, where you can select an existing column or define a new one.

See Also

Define Custom Member Column Dialog Box