1. Administrator's Guide
  2. Integrating Data
  3. Loading Data
  4. Using Journal Templates to Import Data
  5. Integrating Financial Management Journals
  6. Data Values

Data Values

Data value is an extra dimension that is only used when integrating with an Oracle Hyperion Financial Management multi-dimension target system. The name of the dimension is "Value." The members in this dimension are: [Contribution Adjs], and [Parent Adjs]. When data is loaded to Financial Management, specify a member of the value dimension to indicate where the data is loaded. In the Location definition in Oracle Hyperion Financial Data Quality Management, Enterprise Edition, specify an entry for the value dimension in the Data Value field. The Data Value is set on the Location screen by selecting the Search link.

When FDMEE creates the load file, this dimension value is entered for every data line loaded by this location. You must enter a value in this field to integrate with Financial Management, or else the validation fails. The default value is Data Value <Entity Currency>.

If you load journals to Financial Management, you can specify the value dimension member for data loads and for journal loads. The first ";" is the value member used for data loads, and the second field by ";" is the value member for journal loads.

When using the template, the system picks up the value member by looking for the second field delimited by " ;" in the value member field in the location.

When Search is selected, FDMEE connects to the Financial Management to get a list of valid data values. FDMEE takes the values from Financial Management and adds rows created by FDMEE that are a concatenation of the original value and "Adjustment Data Values". FDMEE uses these newly created rows to manage journal loading to Financial Management.

The rows that FDMEE creates in the Data Value selection screen are:

  • [Contribution Adjs];[Contribution Adjs]

  • [Contribution Adjs];[Parent Adjs]

  • [Contribution Adjs];<Entity Curr Adjs>

  • [Contribution Adjs];<Parent Curr Adjs>

  • [Parent Adjs];[Contribution Adjs]

  • [Parent Adjs];[Parent Adjs]

  • [Parent Adjs];<Entity Curr Adjs>

  • [Parent Adjs];<Parent Curr Adjs>

  • <Entity Curr Adjs>;[Contribution Adjs]

  • <Entity Curr Adjs>;[Parent Adjs]

  • <Entity Curr Adjs>;<Entity Curr Adjs>

  • <Entity Curr Adjs>;<Parent Curr Adjs>