The file Adventure Works.cub contains sales data on biking and related products. It was created in Microsoft SQL Server software and stored as an offline cube. There are two dimension hierarchies, Product Model Categories and Product Model Lines, that categorize the products in slightly different ways. Create a pivot table that shows Internet Sales Amount for all products in the Mountain line in the Rows area, broken down by all product model categories in the Columns area. Then do whatever is necessary to find the percentage of all Internet Sales Amount in the Mountain line due to Tires and Tubes Accessories.

a. Select From Microsoft Query from the From Other Sources dropdown list in the Get External Data group on the Data ribbon.

b. Click the OLAP Cubes tab, then , then OK.

c. Give the source a name such as Ad Works Cube, select the latest OLAP provider, and click Connect.

d. Click the Cube file option and browse for the Adventure Works.cub file.

e. Click Finish, then OK, and then OK to back out to an Import Data dialog.

f. Select PivotTable Report and a location such as cell A1 on a worksheet, and you'll be all set to go?