Defining Source Parameters for Financial Management

When Oracle Hyperion Financial Management is the source system, you can specify additional source parameters such as the journal status, journal type, balance type, and the type of data to extract.

To define source parameter options:

1. On the Workflow tab, under Data Load, select Data Load Rule.
2. In Data Load Rule, select a data load rule.
3. Go to the Source Parameters region.
4. Click Add.
5. Select the parameter(s) row to add, and then select the parameter value from the drop-down:

   Options:

   • Add Journal Status: Specify the journal status to extract.

     The journal status indicates the current state of the journal. The status of a journal changes when you create, submit, approve, reject, or post the journal.

     Options:

     • Working—Journal is created. It has been saved, but it can be incomplete. For example, it might need to have a label or single entity assigned.
     • Submitted—Journal is submitted for approval.
     • Approved—Journal is approved for posting.
     • Rejected—Journal is rejected or unposted.
     • Posted—Journal adjustments are posted to the database.
   • Add Journal Type: Specify the type of journal:
     • Auto-Reversal—Loads a posted auto-reversing journal.
     • Auto-Reversing—Loads an auto-reversing journal that contains adjustments that need to be reversed in the next period. That is, the journal posts in the next period by reversing the debit and credit.
     • Regular—Load journals using the Replace mode, which clears all data for a journal label before loading the new journal data.
   • Add Balance Type: Specify the type of balance to extract:
     • Balanced—All debits and credits are balanced.
     • Unbalanced—Debits and Credits are not balanced.
     • Balanced by entity—Debits and Credits for an entity are balanced.
   • From Extract Type, select one of the following:
     • Data—Extract base-level input data and some calculated data from an application. When you extract data, you must specify a member for the Scenario and Year dimensions. You can specify one or more members for the Period, Entity, and Account dimensions.
     • Journal—You can extract base-level input data and some calculated data from an application. When you extract data, you must specify a member for the Scenario and Year dimensions. You can specify one or more members for the Period, Entity, and Account dimensions.
   • In Extract Dynamic Account, specify to extract dynamic accounts.

     Dynamic accounts are accounts with values that are dynamically calculated when the data is requested. The values for dynamic accounts are not stored. The most common type of dynamic calculation is ratio calculation.

     Extract Dynamic Account options:

     • Yes—Dynamic accounts are extracted.
     • No—Dynamic accounts are not extracted.

     By default, dynamic accounts are not extracted.

   • In Extract Calculated Data, specify whether to extract calculated data.

     Options:

     • Consolidated data for parent entities
     • Base accounts and custom dimension members that are calculated by rules
     • Parent accounts intersecting with their respective CustomTop member and [ICPTop] member. If the CustomTop metadata attribute is blank or ALL, then the [None] member is used.

     Extract calculated data options:

     • Yes—Calculated data is extracted.
     • No—Calculated data is not extracted.

     By default, calculated data is not extracted.

   • In Extract Derived Data, specify whether to extract derived data.

     Derived data a data derived from other data values, such as calculated data or arithmetic formulas.

     • Yes—Derived data is extracted.
     • No—Derived data is not extracted.
6. Click Save.