Actions are powerful way of extending the value of SSAS cubes for the end user. They can CLICK on a cube or portion of a cube to start an application with the selected item as a parameter, or to RETRIEVE information about the selected item.

One of the objects supported by a SQL Server Analysis Services cube is the action. An action is an event that a user can initiate when accessing cube data. The event can take a number of forms. For example, a user might be able to view a Reporting Services report, open a WEB page, or drill through to detailed information related to the cube data

Analysis Services supports three types of actions..

• Report action: Report action Returns a Reporting Services report that is associated with the cube data on which the action is based.
• Drill through: Drillthrough Returns a result set that provides detailed information related to the cube data on which the action is based.
• Standard: Standard has five action subtypes that are based on the specified cube data.

• Dataset: Returns a multidimensional dataset.
• Proprietary: Returns a string that can be interpreted by a client application.
• Rowset: Returns a tabular rowset.
• Statement: Returns a command string that can be RUN by a client application.
• URL: Returns a URL that can be opened by a client application, usually a browser.

Actions are powerful way of extending the value of SSAS cubes for the end user. They can click on a cube or portion of a cube to start an application with the selected item as a parameter, or to retrieve information about the selected item.

One of the objects supported by a SQL Server Analysis Services cube is the action. An action is an event that a user can initiate when accessing cube data. The event can take a number of forms. For example, a user might be able to view a Reporting Services report, open a Web page, or drill through to detailed information related to the cube data

Analysis Services supports three types of actions..