Exercise - creating a report from the RP005 sample template

Instructions are given for creating a report template. This exercise instructs you how to create report from that template.

The report template contains report variables which reference several of the dimensions of the Analysis cube. In the Report Wizard, the variables are listed as report parameters.

In this exercise, you create a report on the Sales cube. With the exception of Product, the Sales cube has different dimensions from the Analysis cube. Therefore, you must choose similar or equivalent dimensions in the Sales cube.

You will make these assignments:

From Analysis Cube Variable To
Database Alias trv_alias BestPracticesOLAP
Cube trv_cube Sales
Period trv_time_dim Time dimension
trv_time_hie Time hierarchy
Region trv_region_dim Interco dimension
trv_region_hie Interco hierarchy
Measure trv_measure_dim Profit dimension
trv_measure_hie Profit hierarchy
POS trv_analyzedX_dim Unit dimension
trv_analyzedX_hie Unit hierarchy
Product trv_analyzedY_dim Product dimension
trv_analyzedY_hie Product hierarchy

When you map a dimension to the dimension parameter, the hierarchy parameter is automatically mapped. In databases with more than one hierarchy per dimension, you must select the required hierarchy.

The Adventure Works sample database from Microsoft has multiple hierarchies per dimension. To use your template to create a report on the Adventure Works sample, you can make these assignments:

From Analysis Cube Variable To Adventure Works
Database Alias trv_alias Adventure Works
Cube trv_cube Adventure Works
Period trv_time _dim Date dimension
trv_time_hie Date.Fiscal hierarchy
Region trv_region_dim Geography dimension
trv_region_hie City hierarchy
Measure trv_measure_dim Measures dimension
trv_measure_hie Measures hierarchy
POS trv_analyzedX_dim Sales Channel dimension
trv_analyzedX_hie Sales Channel hierarchy
Product trv_analyzedY_dim Product dimension
trv_analyzedY_hie Product Model Categories hierarchy

To use your template to create a report based on the Sales cube:

  1. Create the template as instructed.
  2. In the Report Catalog, right-click the folder in which to create the report and select New > Report.
    The Create Report dialog box is displayed.
  3. Specify a name for the report.
  4. Click Choose template and select RP005 from the list.
  5. Click OK.
    The Report Wizard is displayed.
  6. In the Value field of the trv_alias parameter, select BestPracticesOLAP
    Variable trv_alias is assigned to the BestPracticesOLAP alias.
  7. In the Value field of the trv_cube parameter, select Sales.
    Variable trv_cube is assigned to the Sales cube.
  8. In the Value field of the trv_time_dim parameter, select the Time dimension of the Sales cube.
  9. Select the Time hierarchy as the value of the trv_time_hie parameter.
  10. In the Value field of the trv_region_dim parameter, select the Intercompany dimension of the Sales cube.
  11. Select the Intercompany hierarchy as the value of the trv_region_hie parameter.
  12. In the Value field of the trv_measure_dim parameter, select the Profit dimension of the Sales cube.
  13. Select the Profit hierarchy as the value of the trv_measure_hie parameter.
  14. In the Value field of the trv_analysedX_dim parameter, select the Unit dimension of the Sales cube.
  15. Select the Unit hierarchy as the value of the trv_analysedX_hie parameter.
  16. In the Value field of the trv_analysedY_dim parameter, select the Product dimension of the Sales cube.
  17. Select the Product or Tire Sizes hierarchy as the value of the trv_analysedY_hie parameter.
  18. Click Finish.
  19. To display the report, double-click it in the Report Catalog.