Oracle Essbase 9 Implementation Guide

Building your first data load rules file

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 ...