Enabling Data Load of Essbase Data
You specify parameters to enable data to be loaded directly into an Oracle Essbase database. Optionally, you can use advanced settings if you want to load details to child members of parent dimension members based on unique identifiers for the driver dimension.
For example, a company might load the Employee dimension member with account data for Start Date, Position, Salary Basis, and Pay Type. Because the human resource data includes placeholders for new and existing employees, the company could set up the following advanced settings:
-
Data load dimension parents: New Employees, Existing Employees
-
New Employees unique identifiers: Start Date, Position
-
Existing Employees unique identifiers: Salary Basis, Pay Type
During data load, child members of New Employees and Existing Employees are evaluated for data updates. The unique identifiers Start Date, Position, Salary Basis, and Pay Type determine if existing data load dimension values are updated, or if new values are added: If the unique identifier's data values are the same, data is updated. If the data value is different, the next available child member is used.
To specify parameters for loading data: