OLAP Excel Exercise Steps

  1. Open the application.
  2. Go to Analysis.
  3. Click OLAP Excel reports. The Excel Report Templates screen appears.
  4. Highlight a report.
  5. Read the description under Template Information.
  6. Click Create Workbook. The Save Excel Workbook screen appears.
  7. Enter a name and click Save.
  8. Open the workbook and examine it.
  9. Notice the PivotTable fields.
  10. From Excel's PivotTable Field List screen, experiment by selecting to show additional fields.