Essbase. CalcScript. UnDocumented.

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.

Categories: Uncategorized Tags:

Essbase CDF Workshop Part III – Debugging And Optimization

September 2nd, 2015 writer No comments

Essbase CDF Workshop Part III – Debugging And Optimization

Overview

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.
Categories: CDF Oracle Tags:

The Planning Repository: HSP_MEMBER (Part 4 – HSP_MEMBER_FORMULA)

September 2nd, 2015 writer No comments

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 11.1.2.3.500 and 11.1.2.4.
  • 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.

Read more…

Categories: Planning SQL Queries Tags:

Business Rules To Launch Them All

August 31st, 2015 writer No comments

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.

Introduction

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 [7] in the diagram below.)

Let’s get started!

Read more…

Categories: CDF Oracle, Calculation Tuning Tags:

Troubleshooting Oracle Hyperion Essbase Crashes and Hangs

August 31st, 2015 writer No comments

Troubleshooting Oracle Hyperion Essbase Crashes and Hangs

The following new My Oracle Support Knowledge Article is available:

Troubleshooting Oracle Hyperion Essbase Crashes and Hangs
Doc ID 2028052.2

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

Categories: Errors Tags: