Defining URLs for Drill Through

Oracle Hyperion Financial Data Quality Management, Enterprise Edition provides a framework for using URLs for drill through. You click the hyperlink in the amount cell, and the source system is launched in a new EPM Workspace tab or a new window. Multiple drill through URLs are provided to drill to different pages in the source system based on the import format mapping.

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/.

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

   For example, enter: Default.