Defining Data Load Rule Details

You create and modify data load rules on the Data Load screen. The Data Load Rule screen window sections:

• Data Rule Summary

• Data Load Details

• Source Filters, which consist of four tabs: Source Options, Target Members (for file-based data load rules in which a driver is specified), Target Options, and Custom Options)

  See Working with Target Options (by location) and Registering Target Applications.

  See Creating Custom Options.

Note:

Before you create data load rules, ensure that your source system data does not include special characters in the target application.

Also avoid using special characters in names or spaces if you plan to use batch scripts. Some of the characters may cause issues when run from a command line.

To define the data load details for a source system:

1. On the Workflow tab, under Data Load, select Data Load Rule.

2. In the Data Load summary area, click Add.

3. In Details, in Name, enter the data load rule name.

4. Select a Category.

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

5. In Period Mapping Type, select the period mapping type for each data rule.

   Valid options:

   • Default—The Data Rule uses the Period Key and Prior Period Key defined in FDMEE to determine the Source General Ledger Periods mapped to each FDMEE period included in a Data Rule execution.

   • Explicit—The Data Rule uses the Explicit period mappings defined in FDMEE to determine the source General Ledger Periods mapped to each FDMEE Period included in a Data Rule execution. Explicit period mappings enable support of additional General Ledger data sources where periods are not defined by start and end dates.

   • None—With source adaptors use this option to ignore source period mappings. Thus, all imported data rows are mapped to the FDMEE period selected in a Data Rule execution.

   These options are unavailable for a file-based definition.

   Table 3-9 Period Mapping Types

   Location Type	Import Format Type	Period MappingDefault	Explicit Period MappingExplicit	Period Mapping	Include Adjustment Periods
   With Accounting Entity	Standard	Yes	Yes	N/A	Yes
   Without Accounting Entity	Standard	Yes	Yes	N/A	Yes
   With Accounting Entity	Source Adapter	N/A	N/A	Yes	Explicit: Yes None: N/A
   Without Accounting Entity	Source Adapter	N/A	N/A	Yes	Explicit: Yes None: N/A

6. Optional: Enter a description.

7. From Target Plan Type, select the plan type of the target system.

8. Select the source options.

   The following options may appear in the Details section or the Source Options section depending on the source system.

   • Target Plan Type (Oracle Hyperion Planning and Oracle Essbase)—Select the plan type which contains only the dimensions, members, and data values relevant to that plan type. The plan type applies to the source or target system depending on the POV location for this data load rule.

     FDMEE supports data loads for up to six plan types (including custom and Planning applications.)

   • Zero Balances—For SAP, select the zero balances option:

     • Include—Includes a zero balance for any reason.

       For example, when there is a debit of 5 and a credit of 5, then the zero amount is included.

     • Exclude No Activity—Zero balances are excluded when the beginning balance debit, beginning balance credit, period debit and period credit equal 0 (begin_bal_dr, begin_bal_cr, period_dr, period_cr all have 0 for the YTD balance type, or the period debit and the period credit have a period for the period balance type (period_dr, period_cr equals 0 for the Periodic balance type).

     • Exclude Zero Net Balance—Zero net balances are excluded when the beginning balance debit minus the beginning balance credit plus the period debit minus the beginning credit plus period debit minus the period credit equals 0 for the Year to Data balance type (begin_bal_dr – begin_bal_cr + period_dr – period_cr = 0 for the YTD balance type, or the period debit minus the period credit equals zero (period_dr – period_cr = 0 for the Periodic balance type).

     The following example shows how each include zero balance option affects account balances.

     Table 3-10 Zero Balance options

     Amount	Opening Balance	Transaction Debit	Transaction Credit	Closing Balance
     4000	40000	0	40000	0
     5000	50000	25000	75000	0
     6000	0	0	0	0
     7000	0	35000	35000	0

     When the Zero Balance is "Include," Accounts 4000, 5000, 6000 and 7000 qualify for this condition because all zero balanced accounts are included.

     Note:

     The Include Zero Balance option is not applicable when pulling data from Peoplesoft.

     When the Zero Balance is " Exclude No Activity" is selected, only Account 6000 is excluded because the Opening, Transaction and Closing balances are all zero and there is no activity. Accounts 4000, 5000, and 7000 are extracted.

     When the Zero Balance is "Exclude Net Zero" is selected, Accounts 4000, 5000, 6000 and 7000 are excluded because their closing balance is zero.

   • Include Adjustment Periods—Select to include adjustment periods.

     Adjustment periods ensure that the FDMEE adjustment periods map correctly to the source system adjustment periods.

     When you explicitly map period 13 to December/Period 12, and select the Include Adjustment Period option, then the following occurs:

     • For YTD balances, period 13 becomes the ending balance.

     • For PTD balances, period 13 and December/Period12, are added.

To define source options:

1. On the Workflow tab, under Data Load, select Data Load Rule.

2. In Data Load Rule, select a data load rule or click Add.

3. Select the Source Options tab.

4. Complete the source options or source filter options based on the source system:

   Source filter option:

   • For an E-Business Suite source system, see Defining Source Filter Options for E-Business Suite Source Systems.

   • For Oracle Hyperion Financial Management source systems, see Defining Source Filter Options for Financial Management. For information about Financial Management source parameters, see Defining Source Parameters for Financial Management.
   • For a JD Edwards source system, see Defining Source Filter Options for JD Edwards GL Source Systems.

   • For file-based source systems, see Defining Data Load Rule Details for a File-Based Source System.

5. Optional: If you are working with a multi-column data load, select the Column Headers tab, and specify the start date and end date of the numeric columns.

   See Loading Multi-Column Numeric Data.

6. Optional: To work with target options, select the Target Options tab, and select any options.

7. Optional: You can specify free form text or a value by selecting Custom Options and specifying the text you want to associate with the data load rule.

   See Creating Custom Options.

8. Click Save.