Database Reference
In-Depth Information
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 differ-
ence 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 diffi-
cult at best. Discussion of SSRS report development is beyond the scope of this topic,
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:
1. Right-click on
Action Organizer
, and choose
New Reporting Action
.
Provide a descriptive name for the action.
2. Set the action's
target type
to
Level Members
and
target object
to
Product.[Product Categories].[Category]
.
3. Provide the SSRS settings:
Server Name
and
Report Path
.
Server Name
is
the host/computer on which SSRS is running;
Report Path
should include the
report server URL and the
path to the actual report
you wish to display.
4. Provide the parameter name to be passed to the SSRS report. In this case,
the parameter name is
ProductCategory
and set the parameter value
to
the
current
member's
unique
name,
as
in
[Product].[Category].CurrentMember.UniqueName
.
5. Set the
Invocation
property to
interactive
, the
Caption is MDX
prop-
erty to
True,
and
Caption
to the following:
"Sales Reason Comparisons for " +
[Product].[Category].CurrentMember.Member_Caption
6. Click on the
Save
button to save the action.
Search WWH ::
Custom Search