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

You have so far successfully created a pivot table and were able to analyze
the Sales data for customers in various countries for various fiscal years. As-
sume you want to analyze the data for the United States. Because you are in-
terested in the Sales data for customers in the United States, you are not in-
terested in the customers from other countries. The most obvious thing is to
restrict the data. To restrict the data for United States customers, click the
drop-down arrow next to the hierarchy Country. You will see all the members
of the Country hierarchy in Customers dimensions. The boxes next to each
member act as toggle switches. If a tick mark is within the box that means the
specific member is selected. To select or deselect all members, Excel
provides you with a check box for (Show All). Click the box next to (Show All)
to deselect all the members and then select the member United States, as
shown in Figure 15-13 . Click OK. You will now see the Sales data for United
States for various years.
Figure 15-13
Excel generates the following MDX query when you restrict the data analysis
to United States:
SELECT NON EMPTY HIERARCHIZE (
Except ({AddCalculatedMembers (
Except (
{AddCalculatedMembers (