Data load methods

We have discussed the types of data you can load into your Essbase database. We have also discussed how these types of data can be loaded as just the data values themselves, or that they can be used to build your Essbase database outline by dynamically adding dimension members and then loading the data values. Here, we will discuss some of the various methods you can use to load data into your Essbase database.

Data file freeform (no load rule)

This method is quite possibly the most worry free and easy way to load data into an Essbase database. When you have a properly formatted (Essbase-friendly) data file, all you need to do is drag-and-drop the file onto the EssCmd/MaxL executable files or their desktop shortcuts. Essbase will automatically determine what delimiter you are using and correctly load the data.

Here are just a few words of caution on using this data load method. The reason it is so easy at the load step is because the harder work has already been done at the...