How to: Create a Reporting Action
A reporting action generates a Microsoft SQL Server 2005 Reporting Services (SSRS) report. You add a reporting action to a cube by using the Actions view in Cube Designer. Cube Designer can be accessed from Business Intelligence Development Studio.
You can create an action only if the cube is in a processed state. After you create the action, it becomes available to users after you reprocess the cube. For more information, see Processing in Analysis Services.
To create a reporting action
Open the cube for which you want to create a reporting action, and under View, click Actions.
On the toolbar, click the New Reporting Action button, and then in the expression pane, do the following:
In Name, type a name for the action.
From the Target type drop-down list, select the type of object to which you want to attach the action. The object you select in Target Type determines the objects that are available in Target Object. For more information, see How to: Add a Standard Action.
In Target object, click the arrow at the right of the text box, and in the tree view that opens, click the object to which you want to attach the action, and then click OK.
(Optional.) Under condition, create an MDX expression to limit the scope of the action target. You can either type the expression manually, or you can drag items from the Metadata and Functions tabs.
In Server name, type the name of the report server on which the report will be generated.
In Server path, specify the path to the virtual directory that is used to access the report server. The default location of the virtual directory is http://<servername>/ReportServer.
(Optional.) In Parameters, type parameter names and values to pass to the report.
Note
You can create an MDX expression to pass as a parameter value. After you name the parameter, under Parameter Value, click the query builder button (...) on the right side of the text box to launch the MDX Query Builder. For more information about the MDX Query Builder, see MDX Builder Dialog Box (SSAS).
(Optional.) Expand Additional Properties, and then set any or all of the properties in this section. For more information, see How to: Add a Standard Action.
See Also
Other Resources
Designing and Creating Reports
Administering Reporting Services