Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 798

Figure 15-22
The MDX query generated to see the results shown in Figure 15-21 is quite
long because the query needs to exclude all the states in the United States
except Arizona, Alabama, and California. In order to understand the type of
MDX query sent by Excel while drilling down to member details, we will use
an example where you select all the countries in the column axes and apply
drill down only for the first fiscal quarter of 2002. The following MDX query is
sent to the Analysis Services to retrieve the results shown in Figure 15-21 .
SELECT NON EMPTY HIERARCHIZE (
AddCalculatedMembers ({
DrillDownLevel ({[Customer].[Customer
Geography].[All Customers]})}
) // AddCalculatedMembers
) //Hierarchize
DIMENSION PROPERTIES PARENT_UNIQUE_NAME ON COLUMNS ,
NON EMPTY HIERARCHIZE (
AddCalculatedMembers (
{DrillDownMember ({{
DrillDownMember ({
DrillDownLevel
({[Date].[Fiscal].[All Periods]}