Adding Drill Through URLs

Use these steps to add the drill through URL in Oracle Hyperion Financial Data Quality Management, Enterprise Edition. There is a server component and a detailed component when defining the drill URL. The server component is added to the source system definition and the detailed component is added to the import format definition.

Note:

For information on adding a drill through to file based source systems, see Using Drilling Through.

To create a drill through URL, specify the URL name, URL, request method, and URL prompt.

To add a drill through URL:

1. On the Setup tab, under Register, select Source Adapter.
2. In Source Adapter, select the Drill URL tab.
3. On the Drill URL task bar, select Add.

   Entry fields are displayed for the Drill URL Name, Drill URL, Request Method, and Drill URL Prompt columns.

4. In Drill URL Name, enter a user defined name for the drill through URL.
5. In Drill URL, enter the URL used for the drill through.

   Enter the URL without the server and port information. The URL must contain the parameter name and column name from the TDATASEG table enclosed in the symbol $.

   For example, enter: LEDGER_ID=$ATTR1$&GL_PERIOD=$ATTR2$.

   In the above example the value of ATTR1 is passed as a value for the LEDGER_ID parameter, and ATTR2 is passed as the value for the GL_PERIOD parameter. Parameters are separated by the "&" character.

   To specify the request-response between a client and server for the drill URL format, enter either:

   • GET—Form data is encoded into the URL. For example, specify: GET@http://www.oracle.com/. If no method is specified, then GET is the assumed request-response.

   • POST—Form data is displayed in the message body. For example, specify: POST@http://www.oracle.com/.

   Note:

   A JavaScript specification can also be used for the drill-through. See Drill Through using JavaScript.

6. In the Drill URL Prompt, enter a user-defined prompt for the drill-through prompt.

   For example, enter Default.