Sample drill-through definitions in LDX format

Using drill-through access, you can move from one report to another within a session while maintaining your focus on the same piece of data.

Drill throughs are defined in two places in each layout data document. The first place is the drill-through definition, the second is the drill-through instance.

This example is based on a drill through in the sample report Public Folders > Samples > Models > GO Data Warehouse (analysis) > Reporting Report Samples > Employee Satisfaction 2006. See the topic about using drill-through access in the IBM Cognos Analytics Reporting User Guide for more information on this report.

The drill-through definitions are defined in drill elements that are children of the drillDefinitions element. Each definition specifies the general information for a drill through, including whether or not it is prompted, the list of parameters available, and whether or not to show the target resource in a new window. Each drill element has a drillRef child element that specifies the identifier for the drill-through definition. For example:

<drillDefinitions>
  <drill>
    <drillRef>0</drillRef>
    <label>DrillToHiddenRep</label>
    <showInNewWindow>false</showInNewWindow>
    <sendFilterContext>false</sendFilterContext>
    <prompt>no</prompt>
    <outputFormat/>
    <method>execute</method>
    <targetPath>/content/folder[@name='Samples']/folder[@name='Models']
     /package[@name='GO Data Warehouse (query)']
     /folder[@name='Reporting Report Samples']
     /report[@name='Compensation (hidden)']</targetPath>
    <parameters>
      <parameter>
        <name>pPosition</name>
        <type>xsdString</type>
      </parameter>
    </parameters>
    <modelPaths>
      <objectPath>storeID("i81b8b50c4a284aeeaa6253b3b4a126f7")</objectPath>
      <objectPath>storeID("if35fc523ed39464dbe3c11fd7f91e308")/model[last()]</objectPath>
      <objectPath>/content/folder[@name='Samples']/folder[@name='Models']
        /package[@name='GO Data Warehouse (analysis)']
        /model[@name='model']</objectPath>
      <objectPath>/content/folder[@name='Samples']/folder[@name='Models']
        /package[@name='GO Data Warehouse (analysis)']
        /model[last()]</objectPath>
      <locale>en-us</locale>
    </modelPaths>
  </drill>
</drillDefinitions>

A drill-through instance is represented by a drill element on a layout element. The drill-through instance references a drill through definition using the drillRef element. For example, the following drill-through instance references the preceding drill-through definition:

<item>
  <txt>
    <ref>R50</ref>
    <ctx>110</ctx>
    <style>S50</style>
    <drills>
      <drill>
        <drillRef>0</drillRef>
        <parm>
          <name>pPosition</name>
          <value>Human Resources</value>
          <mun>[Employee survey].[Position-department].[Position-department]
           .[Position-department name (level 3)]->[Position-department]
            .[100].[200].[300]</mun>
        </parm>
      </drill>
    </drills>
    <val>Human Resources</val>
    <valTyp>text</valTyp>
  </txt>
</item>