Part V: Building Dimensions and Loading Data
This part describes how to move data from external data sources into Essbase databases. It explains the concepts behind dimension builds and data loads, how to create rules files to manipulate the records and fields in data sources, how to dynamically build or change dimensions in outlines, how to load data values into databases, and how to debug dimension builds and data loads. Part contains the following chapters:
- Introducing Dynamic Dimension Building, provides background material on adding and changing dimensions and members in an outline using a data source and a rules file.
- Building Dimensions Using a Rules File, describes how to add or change members in an outline using a data source and a rules file.
- Introducing Data Loading, explains data loading, including external data sources, rules files, free-form data loading, and 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 and Debugging a Data Load, describes how to load data with 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 tips for loading data and debugging a data load.
Note: For optimization, see Optimizing Data Loads, and Optimizing Database Restructuring.