Drilling Through

  To drill through from a multi-dimensional database to a relational database:

1. Select a dimension and drill-down to the lowest level.

2. Do one of the following:

   • Double-click the dimension.

   • Select OLAP, then Drill Through.

     The Drill-Through dialog box is displayed enabling you know that there are no additional OLAP levels to drill into.

3. Click Yes to drill through to the relational data source.

   Interactive Reporting creates a new Pivot section (along with associated Query and Results sections) for the relational data.

   Note:

   Interactive Reporting ignores slicers when drilling through to a relational database. If a slicer is present, a message is displayed letting you know that the slicer will be ignored.

   Tip:

   After you drill through on a dimension and create a new Pivot section, you can return to the OLAPQuery section and drill down on additional dimensions if desired. When you drill down on an additional dimension, you can choose whether to create a new Pivot section or update a pivot section with the new dimension data.

   Tip:	If you update a pivot section with new data, ensure that the new data to be added to the Pivot section maps to a Fact Topic that is the same as the Fact Topic in the pivot section.