Database Reference
In-Depth Information
There are three types of actions:
•
Generic action
: This is a general purpose action with a specific action type,
which can be:
° URL
° Rowset
° DataSet
° Proprietary
° Statement
•
Reporting action
: This action generates a link to a report stored in an
instance of
SQL Server Reporting Services
(
SSRS
), and passes parameters
to that report that are generated using context-sensitive MDX expressions
•
Drillthrough action
: This action executes a
DRILLTHROUGH
query using the
cell on which the action has been called as a reference for the drillthrough
URL and Reporting actions are commonly used to link external reporting systems to
cubes, and allow you not to have to worry too much about which client will be used
to navigate the cube.
Drillthrough actions are useful to bring data back into the client tool, instead of for
linking to an external resource. For example, when calling a drillthrough action in
Excel, a
DRILLTHROUGH
query is executed and a new worksheet is created to display
what it returns to the end user.
It is not our goal to cover action types other than drillthrough; for more information
on them, please refer to Books Online.
Search WWH ::
Custom Search