Loading the Data Import File

As a best practice, do not load zero values.

Note:

After a data load, the values at parent periods (Quarters, Half Years and Year Total) should only be used after consolidation. Do not rely on values in parent periods or views other than Periodic until after a consolidation is executed.

To import the data file:

1. On the Home page, click Application.
2. Click Overview and from Actions, select Import Data.
3. Click Create.
4. Select the location of the data import file:

   • Local—Imports the data import file from a location on your computer.

   • Inbox—Imports the data import file from the server.

5. For File Type, select an option:

   • Comma delimited

   • Tab delimited

   • Other—Enter the delimiter character that is used in the import file. For a list of supported delimiter characters and exceptions, see Other Supported Delimiter Characters.

6. From Import Mode, select a mode:

   • Merge - Overwrite data in the application. Each record of data is imported into the cell, replacing the old data, if any.

   • Replace - Replace data in the application. In Replace mode, before the first record for a specific Scenario/Year/Period/Entity is encountered, the entire combination of data for that Scenario, Year, Period, and Entity is cleared.

7. From Accumulation Type, select a type:

   • None - Replace the existing value in the database for the record.

   • With Database - Add the data to the existing value of the cell.

   • Within File - Accumulate the cell values that are within the file.

8. Enter or select the source file:

   • If you selected Local, click Browse to navigate to the file.

   • If you selected Inbox, enter the name of the file in Source File.

9. From Date Format, select a format.
10. Optional: If the selected location is Inbox, click Save as Job to save the import operation as a job, which you can schedule to run immediately, or at a later time.
11. Optional: If the selected location is Local, click Validate to test whether the import file format is correct.
12. Click Import.
13. From the information message that the data was submitted successfully, click OK.
14. To view details about the import process, click Application, click Jobs, view Recent Activity, and then click the link for the import to view the details.