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

The relational section includes:

The initial results of the relational query are:

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

The topic mappings are defined on the Set Drill Through dialog.

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

Option	Value
Relational Query	Query1
Topic	Details
Dimension	Year
Topic Item	State
All	Enabled
Relational	Details, State; Details, Product; Details, Month (selected)
OLAP	Market, Product, Year (selected)
Enabled Cell Drill	Enabled
Enable Indicators	Enabled
Drill To	Existing Results

Drill-through on the first top/left cell, and 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.