1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integrating Data
  3. Integrating Data Using a File
  4. Using Drilling Through
  5. Adding the Detail Component for the Drill Through URL

Adding the Detail Component for the Drill Through URL

The detail component defines the parameters values of the drill through URL. Values not hard coded in the drill through URL can be referenced from the TDATASEG table using references to the table column names, or to the column names specified in the import format. Drill through attributes that are different for each row of data, like the CCID (code combination ID for Oracle E-Business Suite applications) must be included in the input file and mapped to an attribute column in the import format. When formatting the drill URL, these parameters can be referenced from the TDATASEG table using the $<TDATASEG_COLUMN>$ notation, or from the import format using the $$<IMPORT_FORMAT_COL>$$ notation.

To add the detail component of the drill through URL:

  1. On the Setup tab, under Integration Setup, select Import Format.
  2. From the Import Format Summary section, select the import format.
  3. In the Import Format Detail section, in the Drill URL, click Image shows edit icon.
  4. Click Add, and specify the import format name, source, target, file type, and file delimiter.
  5. In the Drill URL edit window, specify the parameters of the drill through URL.

    Parameters may include any specific source system required information, and the attributes used to populate the actual drill region.

    The attribute refers to the source columns (dimensions) in the TDATASEG table. You can provide the location of the attribute in the input file by specifying the starting location and length.

    In the following example, the drill through URL enables a user to drill through to an E-Business Suite source system.

    In addition to the attributes selected for the drill through, the function ID, calling page, and Resp_Appl_ID and Resp_id are specified.

    The function ID is E-Business Suite system specific. It is generated at the time the E-Business Suite system is installed and configured. The calling page parameter indicates the origin of the HTTP call. This is hard coded in the URL as FDM_DRILLDOWN. The Resp_Appl_ID and Resp_id parameters are the application ID and responsibility ID from E-Business Suite. These can be set to -1 if unknown. The E-Business Suite source system prompts the user for the user name, password and responsibility if not provided on initial authentication.

    Attributes may include:

    • SOB_ID—Internal Set of Books ID

    • LED_ID—Internal Ledger ID

    • fdm_per—the E-Business Suite period name. This value must be the same as the period name in the E-Business Suite system.
    • fdm_ccid—the Code Combination ID (CCID) for the requested account.
    • fdm_currency—the E-Business Suite ledger currency
    • fdm_balance_type —"A" for Actual, "B" for Budget

    Image shows Drill URL edit window.

  6. In the Mappings grid of the import format, map the columns in the source column to the dimensions in the target application to which to drill through.
  7. Click OK and then click Save.