Key Performance Indicators, Actions, and the DRILLTHROUGH Statement - Microsoft SQL Server 2008 Analysis Services - page 284

In addition to the standard properties of an Action object, a Drillthrough Action object
has two additional properties, as described in Table 15.9.

TABLE 15.9

Properties of Drillthrough Actions

Name Description

Defines an array of columns to be used in the RETURN clause of the
DRILLTHROUGH statement. This property is defined as a metadata Binding
object of a dimension attribute or a measure. (For information about bindings,
refer to Chapter 18, “DSVs and Object Bindings.”)

Column

Defines a Drillthrough action as the default action. If the action is defined
as the default, the columns it specifies will be appended to any DRILLTHROUGH
statement without a RETURN clause.

DEFAULT

Let's use BI Dev Studio to create a default Drillthrough action that targets to the
Warehouse measure group and returns the columns Product , Store , and Unit Shipped :

1. In BI Dev Studio, open the FoodMart 2008 project.
2. In the Solution Explorer, double-click the Warehouse and Sales cube to open the
cube editor.
3. On the Actions tab, right-click anywhere in the Action Organizer and choose New
Drillthrough Action from the resulting menu.
4. Type the name of your action— Shipping Details —in the Name text box.
5. Choose Warehouse as an action target; TargetType CELLS will be automatically
assigned to this action by BI Studio.
6. Assign columns to the action by choosing appropriate attributes Store and
Products , and measure Units Shipped in the drillthrough columns editor. (You
don't need to specify any conditions.)
7. Set these additional properties: Default as True, Maximum Rows as 15, Description as
Details of the Shipping, Caption Is MDX as False, and Caption as Shipping Details,
as shown in Figure 15.8.