Export (0) Print
Expand All

How to edit a calculated member in a virtual cube

SQL Server 2000

To edit a calculated member in a virtual cube

  1. In the Analysis Manager tree pane, right-click the virtual cube, and then click Edit.

  2. In the Virtual Cube Editor tree pane, right-click the calculated member, and then click Edit.

  3. In Calculated Member Builder, in the Parent dimension box, select the dimension that will include the calculated member, or select Measures.

  4. In the Parent member box, specify the member that will include the calculated member. Click Change to select a member other than the displayed member. (Change is unavailable if you selected a one-level dimension or Measures in Step 3.)

  5. In the Value expression box, construct an expression to produce the values of the calculated member. Use any combination of the following methods to add to the expression:
    • Drag items from the Data and Functions boxes.

    • Click an item in the Data or Functions box, and then click Insert.

    • Click the arithmetic operator and number buttons.

    • Type.
  6. (Optional.) To register additional function libraries, click Register.

  7. To close Calculated Member Builder, click OK.

  8. To save the calculated member, in Virtual Cube Editor, on the File menu, click Save.

See Also

Editing a Calculated Member in a Virtual Cube

Show:
© 2014 Microsoft