Editing a Calculated Member in a Virtual Cube
To edit a calculated member in a virtual cube, use the Calculated Member Manager and Calculated Member Builder.
To edit a calculated member in a virtual cube
- In the OLAP Manager tree view, right-click the virtual cube, and then click Manage Calculated Members.
- In the Calculated Member Manager, right-click the calculated member, and then click Edit Calculated Member.
- In the Calculated Member Builder:
- In the Parent dimension box, select the dimension that will include the calculated member, or select Measures.
- 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 a.)
- 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. This method is required to add functions from libraries other than the OLAP Services function library.
- To register additional function libraries, click Register.
- To close the Calculated Member Builder, click OK.
- To save the calculated member, in the Calculated Member Manager, on the File menu, click Save.
Note Calculated members in virtual cubes are not visible in the OLAP Manager tree view or HTML pane. To create and access them, you must first display the Calculated Member Manager.
(c) 1999 Microsoft Corporation. All Rights Reserved.