Actions are predefined definitions stored in the SSAS Cube that sends commands to client application to perform certain operations based on what the user selects in his client.
Actions are added per cube and include a name, description, type, target type, target setting, condition, invocation type, caption and other specific settings described below.
|
Command Line |
Returns a command that the client can run. |
|
Drill Through |
Executes a MDX DrillThrough statement. |
|
URL |
Returns an url address that the client can launch. |
|
HTML |
Returns an html script that the client can render. |
|
Dataset |
Returns a data set to the client. |
|
Rowset |
Returns a row set to the client. |
|
Statement |
Returns a statement that the client can run as an OLE DB command. |
|
Report |
Sends a URL statement to SQL Server Reporting Services, |
|
Proprietary |
Returns client specific operation. |
|
Cube |
Target will then be set to CURRENTCUBE (the only valid target of this type). Result will be that the action is associated with the current cube. |
|
Cells |
Target will then be set to ALLCELLS (the only valid target of this type). Result will be that the action is associated with cells restricted by Condition expression. |
|
Dimension Members |
Target must be set to a single dimension. Result will be that the action is associated with all members of the dimension. |
|
Hierarchy |
Target must be set to a single hierarchy in a dimension. Result will be that the action is associated with the hierarchy object only. |
|
Hierarchy Members |
Target must be set to a single hierarchy in a dimension. Result will be that the action is associated with the all the members of this hierarchy. Note: Attribute Hierarchy Enabled and Visible must be set to true – se dimension editing. |
|
Level |
Target must be set to a single level in a hierarchy in a dimension. Result will be that the action is associated with the level object only. |
|
Level Members |
Target must be set to a single level in a hierarchy in a dimension. Result will be that the action is associated with the members of this level. |
|
Attribute Members |
Target must be set to a single attribute. The result will be all members of this attribute. |
Target content can be selected based on target type by entering expression manually or using the supplied dialog.
Optional condition limits when this action is available. Enter as MDX manually or use the supplied mdx editor. The result of this expression must be true/false.
|
Interactive |
Calls the action when a user performs an action. |
|
On Open |
Calls the action when the cube opens. |
|
Batch |
Calls the action from a batch command. |
Optional application name that handle the action.
Caption shown I client. This can be static text or an MDX expression. Use checkbox to specify as mdx.
Depending on action type this is where the mdx/url/html expression etc. is entered. Mdx editor is available.
Select columns of the underlying data to do drill through on.
Server must contain the report action server.
Path must contain a valid path to the report.
Parameters is optionally report action parameters (parameter/value sets).
Format Parameters is optionally report format parameters (parameter/value sets),