You design a SQL Server 2008 Analysis Services (SSAS) solution that contains a cube. The solution has a measure group that contains different measures aggregated by different dimensions. Users often browse the cube by using Microsoft Excel. You need to enable users to view additional row-level information of the aggregated measures from Excel by using the minimum amount of development effort.
Which Action should you create?
A.
DataSet
B.
Statement
C.
Proprietary
D.
Drillthrough
Explanation:
Tip: "row-level information … development effort" = "Drillthrough"Drillthrough Action Defines a dataset to be returned as a drillthrough to a more detailed level.
Creating Drillthrough Actions
For the most part, Drillthrough Actions have the same properties as Actions. Drillthrough Actions do not have Target Type or Target Object properties. In their place, the Drillthrough Action has the following:
– Drillthrough Columns Defines the objects to be included in the drillthrough dataset.