How to create or select a column to store custom member formulas

Analysis Services

Analysis Services

How to create or select a column to store custom member formulas

To create or select a column to store custom member formulas

  1. Access the dimension that will contain the custom member formulas:
    • If the dimension is shared, in the Analysis Manager tree pane, right-click the dimension, and then click Edit.

    • If the dimension is private, in the Analysis Manager tree pane, right-click the cube that contains the dimension, and then click Edit. In the Cube Editor tree pane, expand the dimension to reveal its levels.
  2. In the editor tree pane, select the level for which you want to create custom member formulas.

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

  6. In the Define Custom Member Column dialog box, select Enable Custom Members.

  7. Create or select a column to store the custom member formulas:
    • 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 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 (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_member_formula
      
    • To select an existing column in the dimension table, select Use an existing column, and then in the Existing column box, select the column.

      Caution  If you select an existing column, its contents will be overwritten by the custom member formulas.

  8. In the Define Custom Member 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 member formulas remains in the dimension table.

See Also

Creating Custom Member Formulas