Report Tables

The following figure identifies the report tables and their relations. Each table is described in the subsequent sections. Lastly, a table is presented showing which report tables are used for each report type.

Reporting Schema

Report
Instance
DbObject

Report
Instance
Param

Report
DbObject

Report
Status

Report
Param

Report
Dimension

Report

This section contains:

• Report Table. Describes the attributes used in the main report definition table.

• ReportDbObject Table. Describes database objects created for use in a static report.

• ReportDimension Table. Describes the attributes used to add a dimension to a report.

• ReportInstanceDbObject Table. Describes instances of database objects created for use in a static report.

• ReportInstanceParam Table. Describes the attributes used to store the parameters entered through the user interface for use in query expressions.

• ReportParam Table. Describes the attributes used to add a parameterized query expression to a static report.

• ReportStatus Table. Describes the attributes used to supply status information about a static report.

• Table Usage by Report Type. Describes report table usage by report type.

All rights reserved.