Part IV

Loading Data

Part IV describes how to load data from an external data source into existing Hyperion Essbase OLAP Server databases by describing the concepts behind data loading, how to create rules files to manipulate the records and fields in a data source, how to perform a data load, and how to debug and optimize existing data loads. Part IV contains the following chapters:

Introducing Data Loading introduces you to the parts of data loading, including external data sources, rules files, free-form data loading, and describes how Hyperion Essbase handles security and multi-user issues while loading data.
Setting up a Rules File to Manipulate Records describes how to create a rules file for a particular data source, specify record manipulations, and validate and save the rules file using the Data Prep Editor.
Manipulating Fields Using a Rules File describes how to manipulate fields using a rules file, including how to ignore fields, order fields, map fields to member names, and change data values using the Data Prep Editor.
Performing a Data Load describes how to load data using the Application Manager, including the kinds of data that you can load, how to choose the data source, how to set the error log file, how to start and finish a data load, and provides tips for loading data.
Debugging and Optimizing Data Loads describes how to debug problems with data loads and how to optimize your data loads so that Hyperion Essbase can load the data more quickly.