A Importing Data

You can download data import templates from within the application. The templates are generated based on the features you’ve enabled and the custom dimensions that were added.

To download the data import templates:

  1. From the Home page, click Application Application icon and then click Configure Configure icon.
  2. From the Configure list, select the module for which you want to download templates, and then from the Actions menu, select Download Data Load Templates.
  3. Save the ZIP file locally, and then extract the CSV files.

Perform these tasks to import data:

  1. Before importing data, configure the application as described in this help system and use Configure to import the dimensional metadata.

    Note:

    Oracle recommends that you use Configure to import metadata, which ensures that metadata is loaded correctly to work with the provided rules and forms. If you choose to use the Dimension Editor to load metadata, the primary hierarchy for pre-defined dimensions should go under the appropriate "Total" member for the dimension. The primary hierarchy for Custom dimensions should go under the appropriate "All" member for the dimension. You can add alternate hierarchies under the Root member as well, but the member should be a Parent or rollup type member. No parent or member should be set to aggregate to the root member of a dimension, because the root member can't be displayed on any form, dashboard, or report.

  2. Specify the appropriate data import settings. See Administering Data Load Settings.

  3. Optional: Make a backup copy of the data import templates to which you can revert, if necessary.
  4. Optional: Back up the application.

  5. If you created custom Smart Lists, import them before the associated data (available only for some modules.)

    To identify the Smart List to import and their entry names:

    1. Click Navigator navigator, and then from Create and Manage, click Smart Lists.

    2. Select the Smart List, click Edit, and then Entries.

    3. Note the associated names.

  6. Open the templates in Microsoft Excel and customize them to specify your business data.

  7. Optional: To ensure that your data will import and calculate correctly, import it into a test application first.

  8. Import the data into your production application.

  9. For the first data import, run the rules required to process and calculate the data.

When customizing the templates:

  • Don’t enter zeros.

  • To import data, you must have at least one member from all dimensions in the file to import.

  • Remove columns for which you have no data. For example, if your periodocity is monthly, you can delete columns for Qtrly 1 - 4.
  • If member names start with zeros (0), change numeric columns to text.