How to test an action

Analysis Services

Analysis Services

How to test an action

To test an action in a processed regular or virtual cube

  1. In the Analysis Manager tree pane, right-click the cube, and then click Edit or Browse Data. If you click Edit, select the Data tab in the editor.

  2. If the target object such as a dimension is not visible in the data viewing pane as a column or row heading, drag it from the data slicing pane down to the data viewing pane.

  3. In the data viewing pane, right-click the grid element that corresponds to the action's target object.
    • For the cube, right-click outside the grid area to select.

    • If the target is members of a dimension, right-click any member cell that is beneath the row or column heading corresponding to the highest level of the dimension.

    • If the target is a dimension object, right-click the column or row heading for the dimension's highest level to select the dimension.

    • If the target is members of a level, right-click any member cell that is beneath the row or column heading corresponding to the level name.

    • If the target is a level object, right-click the column or row heading for the level.

    • If the target is cells in the cube, right-click any data cell in the grid.
  4. Point to the action to launch it.

    Note  Actions based on named sets are not executable within Cube Browser, Cube Editor, or Virtual Cube Editor. They are, however, executable within custom applications built in a Component Object Model (COM) Automation language, such as Microsoft®Visual Basic®, that references Microsoft ActiveX® Data Objects (Multidimensional) (ADO MD) or in Microsoft Visual C++® using COM interfaces provided by the Microsoft SQL Server™ 2000 Analysis Services libraries.

See Also

Actions

Creating Actions

Cube Browser

Data Tab (Cube Editor Data View)

PivotTable Service