Scribd
Upload
17 views5 pages

Assignment Using Web PivotTable

Uploaded by

Yuni Silalahi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views5 pages

Assignment Using Web PivotTable

Uploaded by

Yuni Silalahi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Nama : Yuni Sonia Silalahi

Nim : 171402114
Kom : C
Tugas Data Warehouse & Business Intelligence

Module 2 Assignment using Web PivotTable

1. Load the Data Cube

Figure 1: Connect Data Sources Window with OLAP Mode Options

Figure 2: Demo Window after Adding Adventure Works Cube


2. Create the Pivot Table

Figure 3 & 4. Pivot table with complete expansion on the rows and columns with Average Sales Amount
in the cells.
3. Extend the Pivot Table with Filter Changes and Rollups

Figure 5&6: Pivot table with complete expansion of All Periods and All Promotions with January
Average Sales Amount in the cells.
4. Extend the Pivot Table with Filter Changes and Rollups

Figure 7: Modify an MDX statement to change the filter

Figure 8: How to show only the subcategories within the Excess Inventory item
Figure 9&10: Pivot table with Average Sales Amount for All Periods along with a subset of the expansion
of All Promotions for Excess Inventory promotions.

You might also like