Sample Drill-Through

The sample below shows the drill through feature applied to a CubeQuery with multiple dimensions in the rows.

The initial CubeQuery section includes:

Rows

Jan, Feb, March

100 (children)

200 (children)

Columns

East (children)

Filters

Sales

Cogs

Sample drill through

The relational section includes:

Image shows relational query used for a drill through.

The initial results of the relational query are:

Image show results of the relational query used for a drill through.

The following topic mappings are defined on the Set Drill Through dialog:

Table 49. Topic Mappings defined in the Set Drill Through Dialog

OptionValue
Relational QueryQuery1
TopicDetails
DimensionYear
Topic State
AllEnabled
Enabled Cell DrillEnabled
Enable IndicatorsEnabled
Drill ToExisting Results

When drill on the first top/left cell, the context of New York, 100-10 and Jan. is passed as a filter from the CubeQuery to the relational query:

Image shows drill on the first top/left cell, the context of New York is 100-10, and Jan. is passed as a filter from the CubeQuery to the relational query.