What are best methods for loading data into Hyperion Essbase

We have some Hyperion Essbase data loads (for the Hyperion Planning and Budgeting modules) that were written several years (and versions) ago, and I believe that MaxL script is the mechanism being used to actually load the data into Essbase. The developers who wrote the code are no longer with the company, and no knowledge transfer was done before they left, so our ability to support ETL into Hyperion is almost non-existant at this point. Now, several versions later (we are on Hyperion 9.3.x) there are some new needs to load data in Essbase. Can anyone suggest the best methods for loading into Essbase? Is MaxL script the only way to do it? Also, any suggestions for how to get up to speed on whatever tool you might suggest? Books, Oracle training, etc?
Who is Participating?
garycrisConnect With a Mentor Commented:
The primary way data is loaded into Essbase is through what are called load rules.  If you login to the admin tool EAS and go to your application and expand the database you will see a node for "Rules Files".  The rules files are basically the mapping that tells Essbase which column in the text source file identifies a member from each dimension, remember you need to define every dimension in order to load data into Essbase.  Review the rule files and you will understand how the data is being loaded.  As far as the MaxL scripts; MaxL is an administrative automation language that allows you to script processes.  So in this case your MaxL script would tell Essbase to load a data file and identify the path to the source file and tell Essbase which load rule to use.
All of this is well documented in the database administrators guide, which can be found at http://download.oracle.com/docs/cd/E10530_01/doc/nav/portal_3.htm
As far as books, you can pickup a copy of "Look Smarter Than You Are with Essbase System 9" by Ed Roske.  http://www.lulu.com/content/2192328
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.