Loading data into your database

In the steps above, you learned how to create an Essbase data load rule. Now let us learn how to use this data load rules file to actually load data into your Essbase database. As with the Dimension Build, there are several ways to load data into an Essbase database.

A few of the ways you can load data into an Essbase cube:

• Using the EAS Outline Editor

• Using EssCmd or MaxL script commands

• Using your own API calls

In the next few sections, let us discuss how you can achieve it using the EAS and MaxL statements.

Using the EAS to load data into your Essbase cube

Using EAS is the manual way of loading data into the cube. This method will probably look very familiar because it is almost identical to the Import Data step of the Export/Import Data process, which we discussed earlier in this chapter.

To load data into an Essbase database, using EAS:

1. 1. Navigate to your Application|Database.

2. 2. Then click on Actions | Load Data for "ESSCAR".

3. 3. The Data Load screen will be...