Advanced Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 434

measure group target can be included. Many-to-many dimensions and refer-
enced dimensions are also supported, so attributes from these special dimen-
sions are available for drill-through return columns as well.
In Analysis Services 2000, you explicitly had to set the Enable drillthrough
flag in the Drillthrough options dialog for each cube. This flag to allow drill
through is deprecated in Analysis Services 2005. Cube designers in Analysis
Services 2005 can allow or deny drill through by defining a security role on
each cube. Only an Analysis Services 2005 administrator can perform drill
through against any cube without explicit permissions. If a user does not have
drill through rights on a specific cube, then the drill-through will not execute
and an error message displays
In addition, the cubes and partitions properties DrillthroughFilter, Drill-
throughFrom, and DrillthroughJoin in Analysis Services 2000 are no longer
valid in Analysis Services 2005. The same functionality can now be achieved
using Data Source View.
Follow the steps below to understand an existing drillthrough action in the Ad-
venture Works DW sample database and enhance it.
1. With the Adventure Works DW sample project still open in BIDS,
click the Actions tab.
2. Click Finance Details in the Action Organizer, as shown in Figure
9-42 .