tailieunhanh - Oracle Essbase 9 Implementation Guide- P34

Oracle Essbase 9 Implementation Guide- P34:Essbase is a multidimensional database management system. The name Essbase stands for Extended Spread Sheet dataBASE. Using the custom add-in provides the end-user with near seamless compatibility in the Microsoft Excel spreadsheet program. | Loading Data into Essbase Oops There is a warning message indicating there was an issue with some of the data and that some or all of the data did not load into your Essbase database. In order to debug the issue you need to look into the error file generated by the data load process. As you can see in the previous screenshot the member name ES440 is not found in the data base outline. This means this member does not exist in the database outline. Just to be sneaky we removed the alias for the 4 X 4 PICKUP member from the outline on purpose to force this error. Essbase will attempt to load data into the database using the actual member names or aliases. You can even select a specific alias table to use. Anytime if you see the Member Not Found in database message it means this member does not exist in the Essbase outline. Let us add the alias code ES440 back into the outline and rerun the data load. Hooray we did it As you can see in the following message the data has successfully loaded into your Essbase database without any error messages 150 Download at Chapter 4 Loading data using MaxL By now you must be familiar with the MaxL scripting language and its statements. We used MaxL to update the Essbase outline in the previous chapter. As you know there are three ways you can execute a MaxL script. First using EAS and the MaxL editor second you can execute MaxL scripts from the Command Prompt and third MaxL scripts can be executed from shell commands within another program. Let s use the EAS and the MaxL editor to create a MaxL script and then execute the script to load data into the Essbase database. Steps to execute MaxL from the EAS editor 1. Within EAS Click on File Editor MaxL Script Editor. 2. The MaxL editor will open. 3. Import Database MaxL statement should be used to load data. Syntax for the Import Database MaxL statement IMPORT DATABASE APPLICATION NAME The various fields present in the MaxL statement are data We need to say data