Adding a Target Dimension for Oracle NetSuite Data Sources

A Oracle NetSuite Saved Search is stored as a data source, and import formats enables you to set up the integration mapping between the data source and the dimensions of your target application in Oracle Enterprise Performance Management Cloud.

The files generated by the data source application can be in any of the supported format like single column numeric, and multi-column data.

When you select an Oracle NetSuite data source, Data Integration populates the source and target columns automatically. You map Oracle NetSuite Saved Search data source columns or fields in the import file to dimensions in the EPM Cloud application.

To add an import format to an Oracle NetSuite source:

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.

3. In File Type, select the format of the file to import:

   Available file formats:

   • Delimited - Numeric Data

   • Multi Column - Numeric Data

   • Delimited Data - All Data Type

   • Multi Column - All Data Type

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

5. In the Mapping Dimension section, map the source columns to the target dimensions by selecting the source column and then selecting target dimension from the target dimension drop-down.

6. To map additional dimensions, in the Mapping section, click , then from the Add Dimension Row drop-down, select the dimension row to add.

7. Optional: In Expression, add any import expressions.

   Data Integration provides a set of powerful import expressions that enable it to read and parse virtually any file into the Data Integration database. You enter advanced expressions in the Expression column of the field. Import expressions operate on the value that is read from the import file.

   For more information, see .

8. Click Save.