Defining URLs for Drill Through

ERP Integrator provides a framework for using URLs for drill through. You simply 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 URLs are provided to drill to difference pages in the source system based on the import format mapping.

Note:

For more information about the ERP Integrator drill through feature, see Drilling Through.

Adding Drill Through URLs

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

  To add a drill URL:

  1. In the Tasks pane, under Setup, select Source Adapter.

    The Source Adapter screen is displayed.

  2. Select the Drill URL tab.

  3. From the Drill URL task bar, select Add.

    Entry fields appear 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, you might enter: LEDGER_ID=$ATTR1$=$ATTR2$= $ATTR2$&=$ACCOUNT$

    In the above example the value of ATTR1 will be passed as a value for the LEDGER_ID parameter, and ATTR2 will be passed as a value for the GL_PERIOD parameter.

    In some cases the column name in ERP Integrator staging table name may depend on the mapping created in import format. In order to instruct the system to derive the column name based on the import format enclose the source column name in the symbols $$.

    For example, you might enter COMPANY_CODE=$$RBUKRS$=$$RACCT$$$

    In the above example the value for COMPANY_CODE parameter is determined using the import format. If RBUKRS is mapped to the ENTITY dimension, then the value of the ENTITY column will be passed as the parameter.

    From the Request Method drop-down, select either Get or Post,

    • Get—Form data is encoded into the URL.

    • Post—Form data appears in the message body.

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

    For example, you could enter “Default”.

Deleting Drill URLs

  To delete a drill through URL:

  1. In the Tasks pane, under Setup, select Source Adapter.

    The Source Adapter screen is displayed.

  2. Select the Drill URL tab.

  3. From the Drill URL task bar, select the drill through URL and click Delete.

    The Delete Source Adapter Drill URL screen is displayed.

  4. Click OK.