Note: | Oracle strongly recommends that you create and test CSV load files using a copy of the current application in a development or test environment. After confirming that the load files load data correctly, run them in your production environment. |
Before using the Outline Load Utility, perform these tasks:
Ensure that you maintain the line breaks in the sample code provided that you modify to define load files. Although you can use a text editor, Oracle recommends that you use a spreadsheet program (such as Microsoft Excel) to customize the sample code, because some text editors may remove the necessary line breaks.
Back up the application and application databases. See the Oracle Hyperion Enterprise Performance Management System Backup and Recovery Guide.
Set DIRECT_DATA_LOAD and DATA_LOAD_FILE_PATH as described in Chapter 5 of the Oracle Hyperion Planning Administrator's Guide.
Identify the Smart Lists that you must load. See Required Smart Lists .
Ensure that the data load settings are correct. See Data Load Settings.
If you modify dimensions and Smart List entries, refresh the database.
Ensure that you defined child members for the required dimension parent members. See Reviewing the Dimensional Structure.
Identify the member names and entry names associated with Smart Lists. You specify these names in data load files. See Identifying Smart List and Entry Names.
Important: Load metadata first; and then data. Run load files in the order specified in Required Data Load File Run Order.