[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


What are best methods for loading data into Hyperion Essbase

Posted on 2009-02-13
Medium Priority
Last Modified: 2012-05-06
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?
Question by:csbrownnine
1 Comment

Accepted Solution

garycris earned 2000 total points
ID: 23659815
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question