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 ...

Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.