Define a Detail Report

Each detail report is available to produce a report that is based on a single dimension and by filtering a single value in that dimension. Detail reports are run from the SAS Profitability Management Web Client and create a cube on the fly. To configure a detail report, perform the following steps:

  1. Activate the Reports workspace, and then select a model.
  2. Click the Detail Reports tab, and then click New detail report definition.

    The New Detail Report Definition window appears.
  1. Select the column to be featured in the report.
  2. Select the report hierarchy containing the column.
  3. Select the report layout to determine the appearance of the report.

    Note: After you select a report hierarchy, the drop-down list of report layouts lists only those layouts belonging to the selected report hierarchy.
  4. Click Next.
  1. Select the dimensions and levels to be featured in the report.

    Note: Three dimensions are automatically selected: the column that you selected in the previous step, the DIM_PERIOD dimension, and the REPORTHIERARCHY dimension. These dimensions are automatically selected and disabled because they are required for the report. However, you can select the levels of these dimensions. For the best response time, select dimensions with a limited number of records.
  2. From the Allow Drill Down To column, select the level for each dimension.
  3. Click Next.
  1. On the Measure page, select the measures to be included in the detail report.

    Note: VALUE is automatically selected and disabled because it is required for the report.
  2. Click Finish.

    After the detail report is generated, it is included in the list of detail reports that is is displayed on the Detail Reports tab of the Reports workspace. This is the same list of detail reports that will be available in the SAS Profitability Management Web Client for viewing.