Essbase - Data Load

Essbase Overview

About

Loading data is the process of adding data values to an database from a data source. If the data source is not perfectly formatted, you need a data load rules files to load the data values.

You can load data without updating the outline, update the outline without loading data, or load data and build dimensions simultaneously.

No Check against Member Field

While it processes each record in a data source for a data load, Essbase does not check to ensure that a member specified in a member field belongs to the dimension specified for the dimension field. Essbase loads the data value to the data cell identified by the member combination in the record.

Example : if a record reversed Jan and Sales (Texas, ‘100-10’, Sales, Jan, Actual, 42), Essbase would load 42 to the correct data cell. The exception is for fields in the rules file set as dimension reference method.

Process for Data Loading

To load data values into an Essbase database, follow these steps.

Set up the data source

Set up the data load rule file

Perform the data load

You cannot load data into :

For example, if Year is a Dynamic Calc member, you cannot load data into it. Instead, load data into Qtr1, Qtr2, Qtr3, and Qtr4, which are not Dynamic Calc members.

You may be aware that if you load data into a parent member, they can be overwritten by a data consolidation. See Essbase - Data load in a parent member overwritten by consolidation

Support

After you correct the possible problems, you can reload the records that did not load by reloading the error log. See Loading Dimension Build and Data Load Error Logs.

Tools to load data

Tool Topic Location
Essbase - Administration Service (EAS) Performing a Data Load or Dimension Build Oracle Essbase Administration Services Online Help
Essbase - MaxL import data Oracle Essbase Technical Reference
Essbase - EssCmd IMPORT Oracle Essbase Technical Reference

Spreadsheet files restrictions when loading data

Restriction from UNIX computer

When using spreadsheet files to data load data or build an outline in Essbase, the spreadsheet files must reside on a Windows computer, regardless of the tool you use. Spreadsheet files that reside on a UNIX computer or are transferred via FTP to a UNIX computer are not supported. If Essbase Administration Server is installed on a UNIX computer, data loads and dimension builds from client-side spreadsheet files are not supported.

Remove formatting

To avoid rules file, data load, and dimension build errors, remove formatting in Microsoft Excel data source files; for example, in Excel, set color to “Automatic” and “No Fill,” and remove font settings such as bold and italic.





Discover More
Essbase Overview
Essbase - (Dimension|Outline) Build

Building dimensions (known also as building outline) is the process of loading dimension and members data into an Essbase database outline by using a data source and a dimension build rules file. When...
Essbase Overview
Essbase - (Load|Build) Cube Processes

To create a Essbase database, you must before calculation load data. Two processes are involved : first, a load of the member field to build the dimension known as a dimension build second, a load...
Essbase Overview
Essbase - Checking Error Log

If a data load or dimension build fails, the error log can be a valuable debugging tool. See Understanding and Viewing...
Essbase Overview
Essbase - Data Load

Loading data is the process of adding data values to an database from a data source. If the data source is not perfectly formatted, you need a data load rules files to load the data values. You can load...
Essbase Data Load Rules Files
Essbase - Data Load Rules Files

Data Load Rules file is the second type of rules files which is involved in the data load process. A data source for data load must contain : not only the values that you want to load but also identification...
Essbase Data Source Record Fields
Essbase - Data Source

A data source is external data that is loaded into an database with the help of one this two process : Data sources contain the information that you want to load into the Essbase database. A data...
Essbase Data Source Kinds Of Fields
Essbase - Data fields

Data fields are a component of data source which contain also : , Either the data source or the rules file must contain enough information for Essbase to determine where to put each data value....
Essbase Overview
Essbase - Data load in a parent member overwritten by consolidation

If you work with a block storage database (not aggregate storage) and then you load data into a parent member, when you calculate the database, the consolidation of the children’s data values can overwrite...
Essbase Overview
Essbase - Database (cube)

An Essbase database is a data repository that contains a multidimensional data storage array. Essbase Database is also commonly referred to as cube (as in Essbase Studio console) Files that are related...
Essbase Overview
Essbase - Dealing with Missing Fields in a Data Source during data load

Each record in the data source must have the same number of data value fields to perform a data load. If data values are missing, the data load processes incorrectly. For example, the following file is...



Share this page:
Follow us:
Task Runner