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.
|Published (Last):||25 September 2013|
|PDF File Size:||20.59 Mb|
|ePub File Size:||18.75 Mb|
|Price:||Free* [*Free Regsitration Required]|
Adding attribute dimensions to hierarchies. Previous Section Complete Course. Get databases up and running completely in test — remember: A practical example When I write MaxL code, I want the script to stop if it hits some kind of monumental error as continuing a process that has badly failed will likely only make things worse. The cross-reference is parsed out in an Access database in order to massage the data into various text files that will serve as the basis of dimension build load rules for all the cubes.
This was one of the trickier files to convert although I have just shown a small section of the overall script. kaxl
Of course, there is nothing wrong with running your Essbase automation on the server: Most of the time it just sits there, dormant, not being used.
Adding related content essbase financial reports. You may accept budget inputs in one cube but need to push them over to another cube. Sebastien, I’m glad you liked it. Foo and outputs a text file that is to be read by Target. Ensuring that the automation works from a remote workstation will mean that these inconsistencies are cleaned up, and if we choose to move the automation to a separate server in the future, it will be much easier.
There are a number of reasons you may want or need to do this.
Using Attributes in calculation scripts. Be able to use same scripts in test as in production. The majority of my substitution variables seem to revolve around different time periods. So an error isn’t really an error at all. You need a cheatsheet to figure out what the invocation parameters all mean. Building a Calendar dimension. Setting up an Account or Measures dimension with a parent-child reference.
Next, we login to the Essbase server. So what to do?
Unlock course access forever with Packt credits. Actual, Budget, Forecast Time: Monday might be the first day of the week or something. You can write to the log without the abort and use the shell commAnd to check for the existence of the error file — very easily done in There is a simple automation strategy at the heart of all these tasks:.
Using the View dimension for Dynamic Time Series reporting. Then the code to unload the apps unloadall. Email required Address never made public. Bar, use a load rule on Target.
Again, this file has the admin user and password in it. Also, some careful usage of MaxL variables, spacing, and comments can make a world of difference in keeping things readable.
In the actual implementation, the import database blocks go on for about another dozen databases.
Foo and for the purposes of this example, all it does is makes sure that the aggregations that essbasd to be exported in the following report script are ready. This will allow us to configure a variable within conf. Keeping the cubes small allows for a lot less down-time although maxxl speaking, even in the middle of a calc, read-access is still pretty reliable.
It is possible to specify the locations of rules, reports, and data files all using either a server-context or a client-context. Posted by Cameron Lackpour at Note that we are referring to the source text data file in the server context.
The first line of main. There is a simple automation strategy at the heart of all these tasks: There are jobs to update outlines, process new period data, perform a historical rebuild of all cubes this is currently a six hour job and in the future I will show you how to get it down to a small fraction of its original timeand some glue jobs that scurry data between some different cubes and systems.
I already alluded to the fact that we may want to tighten up the calc scripts in order to make things faster. You should be able to trap that an error file exists using shell commands too.