Share via

  • Article

Drillthrough Context Parameter Values

Report Builder users can create reports and drill through to them from other Report Builder reports. To use a Report Builder report as a drillthrough report, the Report Builder user must select the Drillthrough check box in the Report Properties dialog box. This sets the EnableDrillthrough property to True for the semantic query. In addition, a drillthrough context parameter is added to the Report Definition Language (RDL). This parameter is passed through to the semantic query. Once the property is set in Report Builder, you can set one of the drillthrough properties of an entity to point to the report by using Report Manager.

A drillthrough context parameter is a top-level element. The structure of a drillthrough context parameter value is as follows:

<DrillthroughContext>
   <SemanticQuery>...</SemanticQuery>
   <SelectedItems>
      <SelectedItemName>ItemName</SelectedItemName>
      ...
   </SelectedItems>
   <SelectedPath>Path</SelectedPath>
   <GroupingValues>
      <GroupingValue Name="GroupingName">Value</GroupingValue>
      ...
   </GroupingValues>
</DrillthroughContext>

The following table describes the items within the structure.

Item

Description

SemanticQuery

An element that contains the source query from which the filter expression for the drillthrough should be derived. This element cannot contain parameters.

ItemName

The name of an expression that determines what data is drilled into and displayed to the user. The ItemName corresponds to the name of an expression in the query. SelectedItems must contain a reference to a single grouping expression, or references to expressions that are all in the same measure group or in the same Details collection.

Path

The XML for the Path from the selected item(s) to the target entity that is being drilled to.

GroupingName

The name of a grouping element whose value is needed to identify the selected instance of the selected item.

Value

The value of the grouping for the selected item. To specify null as the value of a grouping, do not specify the Value, and add xsi:nil="true" to the GroupingValue element.