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

1. Create a pivot table to Adventure Works cube of Adventure Works
DW database by creating a new connection. Drag and Drop
Date.Fiscal on the row axes, the Customer Geography hierarchy on
the column axes, the Product Categories hierarchy on the Page
axes, and the Internet Sales Amount on the data area.
2. Click the drop-down Pivot table in the Pivot table toolbar and select
Pivot Chart or click the chart icon in the Pivot table toolbar. A new
data sheet is created in Excel that represents the data shown in the
pivot table, as shown in Figure 15-30 . You do have the pivot table
toolbar available within the pivot chart. The hierarchy on rows is rep-
resented on the X-axis of the chart. The sales amount corresponding
to a specific year is shown as a bar graph. The members of the cus-
tomer geography hierarchy are represented as a legend, and the
sales amount for various years for a specific country are shown in
the same color. The Internet Sales Amount representing a specific
year is shown in different colors proportional to the value for various
countries. The total Internet Sales Amount indicated as a bar is the
total Internet Sales Amount for a specific year. Similar to the drop-
down for hierarchies on page axes in a pivot table, you can select
specific product categories to analyze the Internet Sales Amount for
a specific product or products. If you want to see the Internet Sales
Amount based on countries rather than Fiscal Years, you can inter-
change the levels of the Country and Fiscal Year of the hierarchies
Customer Geography and Date.Fiscal respectively. To do so you
need to drag and drop Country from legend to X-axis and Fiscal Year
from X-axis to legend. Any changes made within the pivot chart are
automatically reflected in the pivot table.