Adding the Drill Through URL

Use these steps to add the drill through URL in Data Management. 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.

To add a drill through URL:

1. On the Setup tab, under Register, select Source System.
2. Select the Oracle NetSuite data source system to which to add the drill through.
3. In Drill Through URL, click .
4. On the Drill Through URL edit window, enter the URL hyperlink for the drill through link.

   For example, specify: https://system.netsuite.com/app/common/search/searchresults.nl.

5. Click OK and then click Save.
6. On the Setup tab, under Integration Setup, select Import Format.
7. From the Import Format Summary section, select the import format.
8. Map the Internal ID for Account, Period, and Transaction Type to the Attribute columns.

   

   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&

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

    Based on the example in step 8, 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&

    For more information on search types, see Saved Search Requirements in the Drill Through.

11. Click OK and then click Save.