Defining reporting actions
Reporting actions can launch a SQL Server Reporting Services (SSRS) report passing the currently selected dimension member as a parameter. Reporting actions are conceptually similar to drillthrough actions in the sense that both types of actions typically display additional detail about the data cell exposed by the cube. The difference is that drillthrough is not as feature-rich as an SSRS report could be, and an SSRS report could retrieve data from the relational source, whereas drillthrough must retrieve detailed data directly from the cube. An SSRS report could contain links to additional resources, whereas enhancing drillthrough data set to include links is difficult at best. Discussion of SSRS report development is beyond the scope of this book, but you will review the reporting action defined within the sample database.
How to do it...
To learn how to define a reporting action, review the Sales Reasons Comparison action. The procedure will be as follows:
Right...
