Tables Relating to Drill-Through

Drill-through reports are created in the OLAP Metaoutline main window of the Integration Services Console (refer to online help for information on creating drill-through reports). These reports enable Essbase Spreadsheet Add-in users to view data in the data source database that is not stored in the Essbase database.

Table 5 describes each table in OLAP Metadata Catalog that stores information about drill-through reports. For information about the other tables in OLAP Metadata Catalog, see:

Tables Relating to the OLAP Model
Tables Relating to the Metaoutline
Tables Relating to Hybrid Analysis

Miscellaneous Tables

Table 5. Drill-Through Tables

Table Name	Description
DTR_ATTRIBUTES	Contains information about drill-through columns. This information includes the order in which Essbase Spreadsheet Add-in sorts and displays drill-through information.
DTR_INFO	Contains information about drill-through columns. This information includes the name of the drill-through column, whether the spreadsheet wizard is displayed, and the time or row query governor specified.
MO_INTERSECTION	Contains information about drill-through columns. This information includes system-generated ID numbers for the OLAP model, the drill-through column, and the intersection level on which the column is defined.
MO_PROPERTIES	Contains information about drill-through filters. This information includes the Essbase user name and password, drill-through report name, and metaoutline name.