Adding Additional Filters to the Drill URL in the Import Format

When performing a drill through from Oracle Enterprise Performance Management Cloud to Data Integration, and then to the Oracle NetSuite Saved Search, sometimes too many records are returned. As a guideline, when you add the amounts in all the records in the drill through, they should total to the number in the data cell you were on when you initiated the drill through in EPM Cloud. To resolve this issue, add additional filters to the drill through URL in the Import Format.

To add additional filters:

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. In the Mapping section, select the source dimension column to use as a filter and map it to a target Attribute column

   For example, you could map a Subsidiary ID source column to the Attribute 4 row.

   

4. In Drill Through URL, click and enter the search type criteria used for the drill-through.

   This is the drill through format:

   searchtype=Transaction&searchid=customsearch_nspbcs_all_transactions_s_5&Transaction_TYPE&detailname=$ATTR3$&Transaction_ACCOUNT=$ATTR1$&Transaction_POSTINGPERIOD=$ATTR2$&Transaction_POSTING=T&Transaction_MAINLINE=F&

   If you want to add an additional filter, such as Subsidiary ID, enter &Transaction_SUBSIDIARY=$ATTR4$ to the list of parameters.

   In this case, specify the entire drill through URL definition as:

   Searchtype=Transaction&searchid=customsearch_nspbcs_trial_balance&Transaction_ACCOUNT=$ATTR1$&Transaction_POSTINGPERIOD=$ATTR2$&Transaction_SUBSIDIARY=$ATTR4$&Transaction_POSTING=T&

5. Click Save.