Defining Data Load Rule Details for a File-Based Source System

When defining data load detail for a file-based data load system, load data to a single period or a range of periods. For a single period, enter the file name in the data rule, and then run the rule for a single period. To load multiple periods, create a file for each period and append the period name or period key to the file name. When the rule is executed for a range of periods, the process constructs the file name for each period, and then uploads the appropriate data to the POV.

To define the data load details for a file-based source system:

1. In Name, enter the data load rule name.
2. In Category, select a category.

   The categories listed are those that you created in the Oracle Hyperion Financial Data Quality Management, Enterprise Edition setup, such as "Actual." See Defining Category Mappings.

3. Optional: In Description, specify a description of the data load rule.
4. Optional: From the Target Plan Type drop, select the plan type of the target system.
5. Optional: In Import Format, if the file type is a multiple period text file (with contiguous periods, or noncontiguous periods), select the import format to use with the file, so you can override the import format. For example, specify an import format for single and multiple period data rules, which enables you to load single or multiple period files from the same location. In this case, the import format selected must have the same target as the location selected in the POV. If the import format is unspecified, then the import format from the location is used.

   The starting and ending period selected for the rule determine the specific periods in the file when loading a multiple period text file.

   In the file, when amounts are unavailable for contiguous periods, then you can explicitly map the respective amount columns to required periods in the data rule in Data Load Mapping. When you execute the rule, the data is loaded to the periods as specified in the explicit mapping.

6. Optional: Enter a description.
7. In Directory, enter the relative path where the file is located.
8. Select the Source Options tab.
9. In the File Name field, enter the static name of the file.

   Note:

   Do not use an apostrophe character (') in the file name because an apostrophe is considered an escape character, and the file cannot be imported to FDMEE.

   When only the file name is provided, then data must be entered for a single period on the Rules Execution window.

   To load multiple periods, create a file for each period and append a period name or period key to the file name. When the rule is executed for a range of periods, the process constructs the file name for each period and uploads it to the appropriate POV.

   Note:

   If used in a batch script, period names cannot include spaces.

   To navigate to a file located in a FDMEE directory, click Select, and then choose a file on the Select screen. You can also select Upload on the Select screen, and navigate to a file on the Select a file to upload screen.

   If you do not specify a file name, then FDMEE prompts you for the file name when you execute the rule.

10. To load data into multiple periods, in the File Name Suffix Type drop-down, select Period Description or Period Key.

    A suffix is appended to the file name, and FDMEE adds the file extension after adding the suffix. If you leave the file name blank, then FDMEE looks for a file with Suffix. When the file name suffix type is provided, then the file name is optional in this case, and it is not required on the Rule Execution window.

    If the file name suffix type is a period key, the suffix indicator and period date format are required (as the suffix set) in the file name and must be validated as a valid date format.

    For example, specify:

    1. 1_Jan-2013.txt
    2. 1_Feb-2013.txt
    3. 1_Mar-2013.txt

    In this case, when you run the rule, enter 1_.txt in the file name field and select "Period Name" for the suffix indicator. Then run the rule for the January to March periods.

11. In Period Key Date Format, specify the data format of the period key that is appended to the file name in JAVA date format (SimpleDateFormat).
12. Click Save.