This document is a guide for using MaxL, multi-dimensional database access language for Hyperion Essbase OLAP Server. MaxL is a flexible way to automate . To get started, click on the Start menu and navigate to Program | Oracle EPM System | Essbase | Start Administration Services Console. In the Log in menu, enter. Essbase MaxL scripts MaxL is a Multidimensional Access Language developed for Essbase analytics. MaxL, as it is known, is a powerful scripting tool.

Author: Negal Tukree
Country: Pacific Islands
Language: English (Spanish)
Genre: Automotive
Published (Last): 2 April 2009
Pages: 455
PDF File Size: 19.9 Mb
ePub File Size: 13.54 Mb
ISBN: 659-7-38806-344-4
Downloads: 50275
Price: Free* [*Free Regsitration Required]
Uploader: Samurg

What I’m trying to say is that you can do the dataload or dim build — you still probably want to do an iferror in case it can’t find the file or can’t connect to sql source. What does the report script look like? One, it keeps the cubes cleaner and more intuitive; interdimensional irrelevance is also kept to a minimum. Using substitution variables in calculations script. What is going on here?

Then the code to unload the apps unloadall. So, there you have it. I already alluded to the fact that we may want to tighten up the calc scripts in order to make things faster. So, first things first. Comments Include comments throughout your script by using backslashes and the asterisk max.

North, East, South, West Time: This particular example has been modified from the original in order to hide the real names and to simplify it a little, but the concept is the same. You can generally adjust the syntax to explicitly refer to files that are local versus files that are remote.

Adding related content to financial reports. Also, some careful usage of MaxL variables, spacing, and comments can make a world of difference in keeping things readable.

Next, we login to the Essbase server. Note that although we are using three different rules files and three different input files for those rules files, we can do all the work in one import command. Calculate the source cube if needed Essbae a Report script on the source cube, outputting to a file Load the output from the report script to the target cube with a load rule Calculate the target cube This can be done by hand, of course through EASor you can do what the rest of us lazy naxl monkeys do, and automate it.


Due to using absolute paths with UNC names, and for some other historical reasons, there only exists a production copy of the code there was perhaps a test version at some point, but due to all of the hard-coded things, the deployment method consisted of doing a massive search and replace operation in a text editor.

You would do this if you only want to load in data for a particular year or period, or records that are newer than a certain date, or something similar. And as a tertiary goal: Executing calculations using MaxL.

For our purposes, the target cube, Target. This will allow us to easily adapt the code to new systems in the future, for example, if we want to consolidate to a different server in the future, even one on a different operating system. Although Business Objects exists within the company too, it is not recognized as being nearly as useful to the internal financial customers as Essbase is.

Now we use the spooling feature ezsbase MaxL to divert standard output and error output to two different places.

Essbase – MaxL [Gerardnico]

The other dimensions are essentially static, and only need to be updated rarely e. This site uses cookies.

This development methodology is made possible in part because in this case, my workstation is Windows, and so are the Essbase servers. This will allow us to configure a variable within conf. Essabse not impossible it’s actually fairly easy but it is Yet Another Step. Using allocation functions in calculation scripts. What is MaxL Shell? Without these specific error codes, it would be impossible to know that connections need to be enabled.

Foo and outputs a text file that is to be read dssbase Target. You just need to add “on error abort”. Creating hierarchies using a generation reference table.


The current system performs several different functions across msxl discreet job files. I was feeling a little bit whimsical last week and wanted to get a little use out of my SurveyMonkey account, so I decided to do a quick poll: We are using simple dimension build load rules to update the dimensions.

Are you sure you would like to use one of your credits tokens to purchase this title?

Understanding MaxL

Buy eBook Buy from Store. If you run the automation from a remote server instead of the Essbase server itself, you may end up with lots of different config files — in which case, you might want to adjust this technique a bit.

It sure would be nice if you could because otherwise, as you note, you must write a trapping routine in your calling code. Creating a connection and using substitution variables in financial reports.

Bar, has an outline as follows:. For example, the contents of essbase Setting up an Account or Measures dimension with a parent-child reference.

Adding tables for varying attributes. Tim and Jared, Thanks for your kind words. Here is our first real difference when it comes to running the automation on the server versus running somewhere else.

Understanding MaxL | Oracle EPM

What is a batch file and how does it affect your MaxL script? Therefore, your deploy method could literally be as simple as copying the folder from the test server to the production server.

I am stealing this for my KScope12 “Script or Die! Find Out More Start Trial. These cubes are not spun up from EIS metaoutlines, and there is very little compelling business reason to convert them to EIS just for the sake of converting esbase, so this seems to be the most sensible approach. In other words, you use statements and commands in a script to make requests.