Add or Remove Drill-through Targets

Because cubes and other drill-through files may be created in different places at different times, their data and related information, or metadata, may not always match the information in the original cube. Ensure that you are linking to the most up-to-date information.

When a model is based on an Impromptu Query Definition (.iqd) file, the corresponding Impromptu reports (.imr) automatically appear in the drill-through list for each measure in the source. You can remove some or all of these reports from the Measure property sheets, or add additional reports that are not associated with the original source.

To change targets for all measures in a cube at once, use the Drill Through tab on the PowerCube property sheet.

To meet the needs of various users, you may need to set up multiple drill-through targets:

  • Drill through from a higher-level cube, showing the results for an entire product line, to a cube that has the same measures and dimensions but has additional levels in the Product dimension.

    Users can drill through to the detailed cube to analyze results based on different attributes, such as color or model.

  • Drill through to a cube having the same degree of detail, but differing dimensions.

    The drill-through cube may be separated from the original cube in time and space. For example, your regional office maintains client addresses in a supported target report. Add this report to the drill-through list on the PowerCube property sheet so that your users can see address details in their OLAP report when they select any cell.

  • Drill through to a cube having the same dimensions, but not all measures.

    For example, a model based on an .iqd file has the measures Profit Margin, Revenue, and Cost, and the drill-through report shows all three. You remove the .imr report from the property sheet of the Profit Margin measure.

  • Drill through to only those reports that are in scope, excluding all others based on a set of restrictions established in the cube model.

Procedure

  1. Open the Measure property sheet, and click the Drill Through tab.

    If you are setting up drill through for all measures in a cube, open the PowerCube property sheet, and click the Drill Through tab.

  2. If you are setting up drill through for the first time, click the Allow drill through for this measure check box.

    For PowerCubes, the equivalent setting is Allow drill through for this PowerCube.

  3. To add a target, click Add, browse to the target file, and click Open to add the file to the custom drill-through list.
    Tip: You can then select the target and click Modify to make any required changes. Or, to delete an item from the target list, select it and then click Remove.
  4. If desired, type explanatory text in the Report description box.
  5. Click OK.