Creating Actions in Regular Cubes

The cube editor or the Action Wizard can be used to create an action for a regular cube.

In the Analysis Manager tree pane, under the database in which you want to create the action, expand the Cubes folder.

Right-click the cube in which you want to create the action, and then click Edit.

In Cube Editor, on the Insert menu, click Action.

In the Action Wizard, in Welcome step, click Next.

In the Select target step, select the object to which the action is attached. Generally, in client applications, the action is displayed when end users select the target object; however, the client application determines which end-user operation displays actions. Click Next.

In the Select the action type step, select the type of action. The type indicates the kind of operation performed by the action. Click Next

In the Define the Action Syntax step, specify the parameters that are passed when the action is executed. The syntax must evaluate to a string. Click Next.

In the Finish step, specify the action name. Click Finish.

This leaves us in the Cube editor with the data displayed on the right pane.

To save the action, in Cube Editor, on the File menu, click

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

Next Page: Tutorial 60: MSAS - Defining and Creating Auctions - Page 3