In this section: How to: |
To drill down to a more detailed level of information in a graph, you can link a procedure (FOCEXEC) or a URL to one or more values in your graph. When you run your graph, the selected values become hyperlinks that invoke the underlying procedure or URL.
The Drill Down dialog box opens.
You can select the No action option button to disable a drill-down link.
How to: |
Parameters enable you to specify criteria and conditions for the associated (down) report. By defining parameters, you can control the amount and type of information to retrieve when you click on a hyperlink.
Note: To avoid conflicts, do not name variables beginning with Date, IBI, or WF, as variables beginning with these values are reserved for Information Builders use.
The Expression Builder dialog box opens.
For details, see Writing Expressions With Graphical Tools in the Creating Reports With Report Painter manual.
To add the ability to call the drill-down procedure and pass parameters from the graph:
The Drill Down Parameter dialog box opens.
The parameter will be set to the corresponding value of the object the user drills down on in the specified field.
The parameter is set to the specified value.
Note: If the drill-down report contains a -DEFAULT statement that sets a default value to the same variable passed from the main report, the variable value in the -DEFAULT statement will overwrite the variable value passed from the main report. Therefore, the output in the drill-down report will not reflect the value passed from the main report. Instead, the output will reflect the default value passed from the -DEFAULT statement.
The following image shows a sample drill down dialog box with Execute Procedure (FOCEXEC) option selected.
Note: When passing parameters to a drill-down procedure, you must use local variables (&variables). Global variables (&&variables) cannot be used as drill-down parameters. Also, it is not necessary to type an ampersand (&) before the parameter name. This will create a global variable that cannot be used as a drill-down parameter.
Note: If the drill-down report contains a -DEFAULTS statement that sets a default value to the same variable passed from the main report, the variable value passed down overwrites the -DEFAULTS statement in the target procedure.
WebFOCUS |