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.
Restrict Drill-through Targets by Level
To narrow the scope, you can restrict drill through from a measure or from a cube,
by level.
Procedure
1. In the Dimension Map,fromtheEdit menu, click Show Scope and then select
DrillThrough.
2. In the first drop-down list box, click the measure or cube on which to restrict
drill through by level.
3. In the second drop-down list box, click the drill-through target for which the
restriction will apply.
4. In the Dimension Map, click the level or dimension for which you want to
restrict drill through.
5. Right-click the dimension and click Exclude DrillThrough.
The interface highlighting shows which level or dimension is now unavailable,
or out-of-scope, for drill through. By default, the unavailable item appears on a
red background, which is the formatting used for a source with missing
columns.
6. Build the cube by clicking Create PowerCubes from the Run menu, and open
it in your OLAP reporting component. Confirm that the level or levels you
excluded do not support drill through.
Note: If your users attempt to drill through while positioned in an excluded
level, they will see a warning message similar to the following:
There are no drill-through targets available. Verify your selection or confirm
that drill through is available at this level.
Add Drill-through Targets to UNIX/Linux Cubes
You can set up drill through to a cube on a UNIX or Linux server by creating a
temporary file in the Custom reports list and entering the path of the targeted
drill-through file.
Procedure
1. Open the PowerCube property sheet and click the Drill Through tab.
142 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General