Defining Data Load Rule Details

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

Note:

Before you create data load rules, ensure that your source system data does not include special characters, which are not supported in Oracle Hyperion Financial Management target applications.

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 and JDE, 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:

  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.