In the following task, you
browse the Analysis Services Tutorial cube. Because our analysis compares
measure across multiple dimensions, you will use an Excel PivotTable to browse
your data. Using a PivotTable lets you place customer, date, and product
information on different axes so that you can see how Internet Sales change
when viewed across specific time periods, customer demographics, and product
lines.
To browse the deployed cube
1.
To switch to Cube Designer in SQL Server Data Tools,
double-click the Analysis Services Tutorial cube in the Cubes folder of the Solution Explorer.
2.
Open the Browser tab,
and then click the Reconnect button
on the toolbar of the designer.
3.
Click the Excel icon to launch Excel using the workspace database
as the data source. When prompted to enable connections, click Enable.
4.
In the PivotTable Field List, expand Internet Sales,
and then drag the Sales Amountmeasure to the Values area.
5.
In the PivotTable Field List, expand Product.
6.
Drag the Product Model Lines user
hierarchy to the Columns area.
7.
In the PivotTable Field List, expand Customer,
expand Location,
and then drag theCustomer Geography hierarchy from the Location display
folder in the Customer dimension to the Rows area.
8.
In the PivotTable Field List, expand Order Date,
and then drag the Order Date.Calendar Date hierarchy to the Report Filter area.
9.
Click the arrow to the right of the Order
Date.Calendar Date filter
in the data pane, clear the check box for the (All) level,
expand 2006,
expand H1 CY
2006, expand Q1 CY 2006, select the check box for February 2006,
and then click OK.
Internet
sales by region and product line for the month of February, 2006 appear as
shown in the following image.

No comments:
Post a Comment