Export (0) Print
Expand All
Expand Minimize

Define Custom Member Options Dialog Box

SQL Server 2000

Define Custom Member Options Dialog Box

Use this dialog box to:

  • Enable or disable the use of custom member options.

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

Custom member options are cell properties defined for custom members. Custom member options can be used to change the font, display format, and other characteristics of the cells for the specified custom member. For more information about cell properties, see Using Cell Properties.

This property is available only when the Custom Members property for the level is set to True. This property is ignored for any member not defined as a custom member. In other words, no Multidimensional Expressions (MDX) expression has been defined for a given member in the custom member column.

The Custom Member Options property accepts a column reference containing, for each member, a comma-delimited list of cell properties. The cell properties are represented as string expressions. For more information, see Custom Member Options in Using Cell Properties.

The Define Custom Member Options dialog box appears when, in the tree pane of Dimension Editor (if the dimension is shared) or Cube Editor (if the dimension is private), you select a level, and in the Advanced tab of the properties pane click the value beside Custom Member Options, and then click the edit (...) button. This button is available only when the Custom Members property is set to True.

Options

Enable Custom Member Options

Select to enable the use of custom member options to determine the cell properties of custom members. This action sets the Custom Member Options property of the level to True.

Clear to make the use of custom member options unavailable. This action sets the Custom Member Options property of the level to False. Custom member options will be ignored.

Create a new column

Click to create a new column in which the cell properties for custom members will be stored. 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 cell properties for custom members. 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 cell properties of custom members.

New column name

Type the name of the column that will store the cell properties for custom members. This option is available only if you select Create a new column.

A dimension table can have multiple columns (one per level) that store cell properties for custom members. Therefore, it is recommended that the new column name identify the column that stores the members to which the custom member options apply. For example, if the members are stored in the store_country column, type:

store_country_custom_member_options

Existing column

Select the column that will store the cell properties for custom members. 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.

Show:
© 2014 Microsoft