The first line in load file contains the header record columns that identifies the member properties and kinds of values to load. These are always budget item, data load cube name, Point-Of-View, and the kind of data to load. For example, this header record indicates that FTE data is being loaded:
Budget Item,Data Load Cube Name,Point-of-View,Proposed FTE,FTE Start Date,FTE End Date
The Point-of-View column contains information about the budget to which to load data (stage and version), and the artifacts to which you are loading data, or that are associated with the data you load (entity, position, employee and so on). Remove the placeholders provided (Entity1, Stage 1 and so on) to identify your budget and artifacts.
LINEITEM determines whether the kind of data that you want to load already exists. If it does not, a new record is loaded. If it does exist, it is updated with the new data you load. For information about using LINEITEM to run incremental loads, see “Command Line Parameters” in Chapter 5 of the Oracle Hyperion Planning Administrator's Guide. The remaining portion of data load files contain the metadata records . These are comma-separated lists of the data or values to load, and which represent Smart List selections in applications.
This is a sample portion of a data load file:
<LINEITEM("FTE and Status Assignments")>,HCP,"BegBalance,Local,Unspecified Element,Forecast,Stage 2,HR,No Year,Deborah Ferguson,Admin_Asst",1,01-01-2011,
12-31-2012You will replace the placeholders in the sample code (Budget, Stage 1, Entity1, Employee1 and so on) with the version and scenario of the budget to which you are loading data (Forecast Stage 2, for example). You will also specify the appropriate entity (Human Resources, for example), and the applicable employees or positions. For example, this code loads the following FTE assignment data for employee1 in Entity1:
Budget Item,Data Load Cube Name,Point-of-View,Proposed FTE,FTE Start Date,FTE End Date
<LINEITEM("FTE and Status Assignments")>,HCP,"BegBalance,Local,Unspecified Element,Forecast,Stage 2,HR,No Year,Deborah Ferguson,Admin_Asst",1,01-01-2011,12-31-2012When run, this file loads the following to stage 2 of the forecast budget for Deborah Fergusson, an Administrative Assistant in Human Resources:
A proposed FTE of 1
The FTE start date as January 1, 2011
The FTE end date as December 31, 2012