1. Administrator's Guide
  2. Integrating Data
  3. Loading Data
  4. Using Journal Templates to Import Data
  5. Defining Journal Templates

Defining Journal Templates

You define an Oracle Hyperion Financial Data Quality Management, Enterprise Edition journal template by specifying the metadata header that FDMEE uses to interpret the data contained in the template. Metadata consists of a series of tags that tell FDMEE what column contains the account number or what period in which to load. A named range is used to tell the system where to look for the header information and the data to load. For the journal template, the named region is called upsJournal, and the following details relate to the relative rows within the named range. The template that comes with FDMEE has a range that starts at row 16, but the metadata starts at row 1 within the range. See below for an example of the template that is provided with FDMEE.

The sample journal template below has two lines of actual imported data, and five lines of metadata. Rows 1-5 contain metadata and rows 6 and 7 contain the data values.


The image shows a Microsoft Excel journal template as described in the text preceding and following the image.