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 wizard opens.
3. Select the column to be featured in the detail report, and then click Next.
4. Select the dimensions to be included in the report.
   
   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.
5. In the Allow Drill Down To column, select the level for each dimension.
6. Click Next.
7. 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.
8. Click Finish.
   
   After the selected dimensions are configured, the list of detail reports 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.