Essbase. CalcScript. UnDocumented.
Did you know: It is possible to remove “//EssLang %” string from first line in the calculation script: To do this just follow this steps:
- Open CalcScript file in the MS Windows Notepad text editor
- Going to “Save As” action button and choose “UTF8” file type enconding in the menu options
- After saving file , rename back this new file name to the “CSC” extension.
Now you can remove “//EssLang %” string from yours essbase calculation script and EAS don’t return back this lines.
Essbase CDF Workshop Part III – Debugging And Optimization
This is the third post in a series on developing Essbase CDFs and using Java API for Essbase. Prior posts were:
Essbase CDF Workshop Part I
. We saw how to change sample CDF provided by Oracle, recompile the file, and register function with Essbase server.
In Essbase Scrambler
we saw how to query essbase hierarchies, update member properties and scramble data and metadata in files.
Here I’m going to show a use case of script troubleshooting and optimizing with CDFs. If you have some other use cases for the next post, please let me know. You can use Essbase Scrambler (download here
) if you want to send me your outline or sample data.
The Planning Repository: HSP_MEMBER (Part 4 – HSP_MEMBER_FORMULA)
Not to sound like a broken record, but…a few disclaimers:
- This is the fun stuff…that voids your warranty. Not that you have to tell Oracle that you poke around here, but if you do, they will blame anything and everything that’s wrong on you for being in there.
- The content here has been tested and validated against 22.214.171.124.500 and 126.96.36.199.
- The content here has been tested and validated against Microsoft SQL Server and Oracle 11g.
- The content here is based on the Vision sample application.
- The content here is totally unsupported by Oracle (in case you missed the first bullet).
As we near the end of the HSP_MEMBER series, we’ll take a look at a relatively low-complexity piece next: member formulas. As we mentioned before, formulas are stored in a separate table in Planning. This is done because we can have a different formula for each of our plan types. Our member formulas are stored in the HSP_MEMBER_FORMULA table.
Business Rules To Launch Them All
So you have yourself one of those fancy on-premise Oracle EPM systems built with Hyperion Planning and Oracle Essbase. If you didn’t do that or don’t plan to do so, then you might want to skip the rest of this post.
When you start to do something interesting (and by interesting I mean manual labor intensive) with Oracle EPM you may want to automate some (or many) parts of the solution. For years many of us focused on Oracle Data Integrator (ODI) as a framework for automation. Examples of automation for Hyperion as it is used in this post include:
- Loading source system data and metadata
- Deploying metadata from Planning to Essbase
- Creating nightly backups
- Comparing source systems and target applications
- Checking for errors and sending email notifications
- Running miscellaneous batch, MaxL, et al. processes
This post is not about ODI. This post is about showing you how to use the tools you probably already have to integrate systems with batch processes. You will also learn how to empower users along the way. This approach is very flexible. You could plug in just about anything you want at the “end of the line”, including ODI. (Reference  in the diagram below.)
Let’s get started!
Troubleshooting Oracle Hyperion Essbase Crashes and Hangs
The following new My Oracle Support Knowledge Article is available:
This article provides a series of step through processes, to assist and guide in investigating an Essbase crash or hang issue.
Along with getting started and investigating a crash or hang, the article contains details on common crash and hang symptoms, log and configuration file locations, along with additional references.
Oracle highly recommends you always apply the latest Bundle Patch Set available for your release. This will help to rule out any resolved Bugs as a potential cause.
For more information on the latest Essbase Patch releases refer to the document:
Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase
Doc ID 1396084.1