Setting Drill-through Options

Drill-through options define the mapping between a multi-dimensional database and a relational database.

  To set drill-through options:

  1. Select OLAP, then Set Drill Through.

    The Set Drill-Through dialog box is displayed.

  2. Select options in the Set Drill-Through dialog box and click OK.

    Table 47. OLAPQuery Drill Through Options

    Option

    Description

    Dimensions

    The dimensions in the current OLAP query. Click a dimension to select it.

    Selected Dimension

    The dimension selected by the user. This is the dimension to use for mapping.

    Specify Relational Query

    The relational query sections that are currently available. To specify a relational query, click the arrow to the right of the drop-down list and select a query from the list that is displayed.

    Relational Topics

    The topics contained in the selected relational query. Click a topic to select it.

    Selected Topic

    The topic selected by the user. This is the topic to use for mapping. The selected topic should have topic items with names corresponding to the selected dimension levels.

    Map/UnMap Dimension

    Maps the selected dimension to a topic (or unmaps the selected dimension from a topic). When you map a dimension to a topic, Interactive Reporting stores an internal link between the dimension and the selected topic.

    Specify Fact Topic

    The topic used to map to the OLAP measures. The selected topic should have topic items with names corresponding to the OLAP measures.

    To specify a topic, click the arrow to the right of the drop-down list and select a topic from the list that is displayed. The topics that appear are the topics available in the selected query.

    Tip:

    To drill-down to any level in the relational data, enable the “Set as Dimension” property for the relational topics that represent the OLAP dimension data. To do this, right-click the topic in the original relational query section Contents pane, select Properties, and click the checkbox next to “Set as Dimension” in the Topic Item Properties dialog box.