Adding the Drill Through URL

To add a drill through URL:

1. From the Data Integration home page, click to the right of the integration, and then select Map Dimensions.
2. On the Map Dimensions page, from Import Format, select the name of the import format to use for the integration.

   You can also add a user defined import format name.

3. From the Import Format Summary section, select the import format.
4. In the Import format Detail section, map the Internal ID for Account, Period, and Transaction Type to the Attribute columns as shown below.

   In this example, the drill URL format for the Saved Search is:

   searchtype=Transaction&searchid=<NAME OF SAVED
   SEARCH>&Transaction_TYPE&detailname=$<ATTR COLUMN FOR TRANSACTION
   TYPE>$&Transaction_ACCOUNT=$<ATTR COLUMN FOR ACCOUNT 
   ID>$&Transaction_POSTINGPERIOD=$=$<ATTR COLUMN FOR PERIOD
   ID>$&Transaction_POSTING=T&Transaction_MAINLINE=F&

5. In the Import Format Detail section, in the Drill URL, click .
6. In the Drill URL edit window, specify the attributes of the drill through.

   You specify the drill URL as: searchtype=Transaction&searchid=customsearch_nspbcs_all_transactions_sum&Transaction_TYPE&detailname=$ATTR3$&Transaction_ACCOUNT=$ATTR1$&Transaction_POSTINGPERIOD=$ATTR2$&Transaction_POSTING=T&Transaction_MAINLINE=F&

7. Click Save.