Module 2 Assignment Using Web Pivottable: 1. Load The Data Cube
Module 2 Assignment Using Web Pivottable: 1. Load The Data Cube
Module 2 Assignment Using Web Pivottable: 1. Load The Data Cube
Before starting this assignment, you should read the Web pivot table tutorial. The
tutorial demonstrates the usage of WebPivotTable and the OLAP cube source used for this
assignment. It also demonstrates MDX to specify a pivot table. If you have not read the tutorial
yet, please refer to it prior to starting this assignment.
b. Take some time exploring the data cube before beginning on the details of the
assignment.
b. Select “Promotions” field inside the “Promotions” dimensions in the Rows area.
g. Take a screen snapshot and paste it into a document as the snapshot for part 2
of the WebPivotTable assignment. The snapshot should show All Promotions and
All Periods with complete expansion on the rows and columns with Average
Sales Amount in the cells.
b. Create a filter such that the pivot table displays value only for “Canadian Dollar”
and “US Dollar”.
c. Take a screen snapshot and paste it into a document as the snapshot for part 3
of WebPivotTable assignment. The snapshot should show a complete expansion
of All Periods and All Promotions with January Average Sales Amount in the cells.
b. Collapse all reseller promotions except for Excess Inventory. Show only the
subcategories within the Excess Inventory item.
c. Remove the pivot chart so that the sheet only displays the pivot table.
d. Take a screen snapshot and paste it into a document as the snapshot for part 4
of the WebPivotTable assignment. The snapshot should show the Average Sales
Amount for All Periods along with a subset of the expansion of All Promotions for
Excess Inventory promotions.