About Importing Data

After you import dimensions, you can populate the application with data from a data import file.

Before importing data, you must:

• Define or load metadata and refresh the database. See About Importing Metadata.

• Prepare the data load file. Source data must be in a business process-specific data file format or in an Oracle Essbase data file format.

• Ensure the data load files do not contain any thousands separators or quotes around data values. Up to one single . (decimal point) character is supported.

• Ensure the data import file type is .csv, .txt, or .zip.

You can create a data import file based on a template, or you can generate one based on the source system. To use a template, run the export data process in your business process and use the exported file as a template. See Creating an Export Data Job.

Note:

When importing data, no validation is performed on intersections to determine which are valid, and data is loaded into all intersections. To review data that has been loaded into invalid intersections, run the Invalid Intersection report before importing data to see and clear invalid intersections. See Working with Valid Intersections.