Define Custom Member Column Dialog Box

Analysis Services

Analysis Services

Define Custom Member Column Dialog Box

Use this dialog box to:

  • Enable or disable the use of custom member formulas.

  • Create or select a column to store custom member formulas. This column is created in or selected from the same dimension table that stores the members to which the custom member formulas apply.

Custom member formulas are expressions in Multidimensional Expressions (MDX) that determine the cell values associated with members and override the aggregate functions of measures. For write-enabled dimensions, custom member formulas are created in the custom member formula 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, they are inserted into the dimension table using a tool other than Analysis Manager.

For more information about custom member formulas, see Custom Rollup Formulas and Custom Member Formulas.

For more information about related procedures, see Creating Custom Member Formulas.

The Define Custom Member 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 Custom Members, then click the edit (...) button.

Options

Enable Custom Members

Select to enable the use of custom member formulas. This action sets the level's Custom Members property to True. Cell values for members with custom member formulas will be calculated according to the custom member formulas.

Clear to disable the use of custom member formulas. This action sets the level's Custom Members property to False. Custom member formulas 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 member formulas. 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 member formulas. 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 member formulas.

New column name

Type the name of the column that will store custom member formulas. 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 member formulas. Therefore, it is recommended that the new column name identify the column that stores the members to which the custom member formulas apply. For example, if the members are stored in the store_country column, type:

store_country_custom_member_formula

Existing column

Select the column that will store custom member formulas. 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.