Actually, we should have said build your second data load rule file, as we have built one rules file already. The first one you built, in the previous chapter, is a dimension build rules file. Now, in this chapter, we are discussing how to load data into your Essbase cube so this is a data load rules file.
In the previous section, we talked about how to load data without a data load rules file. We will now learn how to cleanse the data, make the data Essbase-friendly and then load the data into the Essbase using an Essbase data load rules file.
Once you have created a data load rules file, just like the dimension build rules file, you can use it to manually load the data from the EAS or use EssCmd or MaxL (Essbase scripting languages), to load the data into your Essbase database. You can even write your own program that makes its own API call to load the data into Essbase.
Here are some of the advantages of using the data load rules files:
Makes the...