Importing an Action into a Virtual Cube

To import an action into a virtual cube, invoke the Import actions Dialog box from the Virtual Cube editor. Actions can be imported only from cubes that are in the same database as the edited virtual cube. If the imported action has the same name as an action already in the virtual cube, the imported action is given a new name consisting of its old name and a numeric suffix. An error message is displayed if the imported action's definition includes a measure, dimension, or other object that is not in the virtual cube or if there are syntax errors. The action is not included in the virtual cube data displayed to end users as long as the error exists. To correct the error, the user must add the missing measure, dimension, or object to the virtual cube and process it. To add a measure or dimension, use the Virtual Cube Wizard. To start Virtual Cube Wizard from within Virtual Cube Editor, on the Edit menu, click Structure... (Wizard).

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

In Virtual Cube Editor, on the Edit menu, point to Import, and then click Actions.

In the Import Actions dialog box, select the check box beside the action, and then click OK. (To select all the actions in a cube, select the check box beside the cube.)

In Virtual Cube Editor, on the File menu, click Save.

Editing an Action in a Virtual Cube

To edit an action in a virtual cube, use Virtual Cube Editor and the Action Wizard.

In the Analysis Manager tree pane, right-click the virtual cube, and then click Edit.
In the Virtual Cube Editor tree pane, right-click the action, and then click Edit. The action wizard is invoked.

Follow the steps of the action wizard.

Note that Actions in virtual cubes are not visible in the Analysis Manager tree pane. To create and access them, you must first display Virtual Cube Editor.

First Page: Tutorial 60: MSAS - Defining and Creating Auctions