Selecting Data Items

You can select which data items you want to include as rows and columns in the crosstab report, and how you want them formatted.

Procedure

  1. Using the Query Explorer, select Query1.
  2. From the Insertable Objects pane, drag and drop the following data items into the data items pane of the crosstab:
    • DEFAULT|[DEFAULT_REL]|GRC_OBJECTS|[SOXCONTROL]|ID_FIELDS| [CN_CONTROL_ID]
    • DEFAULT|[DEFAULT_REL]|GRC_OBJECTS|[SOXCONTROL]| ENUMERATION_FIELDS|OPERATING_EFFECTIVENES (ENUMERATION)| [CN_OPERATING_EFFECTIVENES]
    • DEFAULT|[DEFAULT_REL]|GRC_OBJECTS|SOXBUSENTITY_FOLDER| [SOXBUSENTITY_GPC]|[SOXBUSENTITY_GPC]|[CEN_NAME00]
  3. Drag and drop the [CN_OPERATING_EFFECTIVENES] into the columns area from the Data Items tab of the Insertable Objects pane.
  4. Drag and drop the [CEN_NAME00] into the rows area from the Data Items tab of the Insertable Objects pane.
  5. Drag and drop the [CN_CONTROL_ID] into the measures area from the Data Items tab of the Insertable Objects pane.
  6. Select the measures area, and complete the following steps in the Properties pane.
    1. Under the Data Item, set the Aggregate Function to Count Distinct.
    2. Set the Rollup Aggregate Function to Automatic.
  7. Run the report.
    Tip: To sort the rows in ascending order, click the rows column and then click the Sort icon Sort icon. To add summaries to the rows and columns, click the Summation icon Summation icon and select Total.