Defining independent drill through definitions for crosstabs

By default, you can create only one drill through definition for fact cells in a crosstab, regardless of how many facts there are. This topic describes how to define different drill through definitions for different measures in crosstab fact cells.

For example, a crosstab has Quantity and Revenue as measures. For the Quantity cells, you want to define a drill through definition to a target report that contains more information about quantities sold. For the Revenue cells, you want to define a drill through definition to a different target report that shows details about revenue generated.

Procedure

  1. Open the source report.
  2. Click the More icon the more icon and then click the Locked icon unlock icon.
  3. In the crosstab, click the white space inside one of the fact cells of the measure for which you want to define a drill through definition.

    Do not click the measure text. You want to select the crosstab intersection and not the text item. In the Properties pane title bar, ensure that Crosstab intersection appears.

  4. In the Properties pane, set the Define contents property to Yes.
    The text item in the crosstab intersection disappears.
  5. Click the Data icon the data icon and then click the Data items tab Data items tab icon..
  6. From the crosstab query, drag the measure that disappeared in step 4 to the empty crosstab intersection.
  7. Click the measure in the crosstab intersection and then, in the Properties pane, click Drill-through definitions.
  8. Create the drill through definition.

Results

A drill through definition is defined for the selected measure. Repeat the steps to define different drill through definitions for other measures in the crosstab. When users run the report, clicking values from different measures takes them to a different target report.