Exercise - creating a report from the RP005 sample template

This exercise uses Report template RP005 which is included with the Best Practices sample database.

See Connecting to the sample database.

You can either:

Return to this exercise and create a report.

Report template RP005 was created on the Analysis cube of the Best Practices sample database. RP005 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, RP005 is used to create a report on the Sales cube of the Best Practices sample database. With the exception of Product, the Sales cube has different dimensions from the Analysis cube. We will have to choose similar or equivalent dimensions in the Sales cube.

These assignments will be made:

From Analysis Cube Variable To
Database Alias trv_alias Best Practices OLAP
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
The Best Practices sample database has only one hierarchy per dimension. 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 template RP005 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 Report Template RP005 to create a report based on the Sales cube:

  1. Either:
  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 Best Practices OLAP
    Variable trv_alias is assigned to the Best Practices OLAP 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.
    Time is automatically selected as the value of the hierarchy parameter.
  9. In the Value field of the trv_region_dim parameter, select the Interco dimension of the Sales cube.
    Interco is automatically selected as the value of the hierarchy parameter.
  10. In the Value field of the trv_measure_dim parameter, select the Profit dimension of the Sales cube.
    Profit is automatically selected as the value of the hierarchy parameter.
  11. In the Value field of the trv_analysedX_dim parameter, select the Unit dimension of the Sales cube.
    Sales is automatically selected as the value of the hierarchy parameter.
  12. In the Value field of the trv_analysedY_dim parameter, select the Product dimension of the Sales cube.
    Product is automatically selected as the value of the hierarchy parameter.
  13. Click Finish.
  14. To display the report, double-click it in the Report Catalog.
Parent topic: Creating a report from a report template
Related topics