Chapter AE, Problem AE9.1

Explanation of Solution

a.

Open the excel file Ch09Ex01__U10e.xlsx:

The excel file spreadsheet contains the following column names: VendorName, EmployeeName, Date, Year, and Rating.

Press Ctrl+O to open the excel file...

Explanation of Solution

b.

Under the INSERT ribbon in Excel, click pivot Table:

Click the pivot table option in excel which is displayed as:

The screen shot of Ch09Ex01__U10e...

Explanation of Solution

c.

Place pivot in a new worksheet:

When the system asks to put a data range one needs to drag the mouse over the column...

Explanation of Solution

d.

Drag and drop VendorName into area named ROWS:

Excel will create a field list on the right hand side of spreadsheet under which a grid labelled DragFields between areas below would appear.

• The field name VendorName is dragged and dropped into area named rows...

Explanation of Solution

e.

Drop Year under Employee and then move year above employee and move year below vendor.

OLAP cubes are readily displayed in excel pivot tables but OLAP cubes are actually based on thousand or more rows of data.

First one needs to drop Year under Employee. Then followed by it move year above employee. The last step is to move year below vendor.

The resulting OLAP cubes are shown below:

The screen shot of Ch09Ex01__U10e.xlsx: