Essbase - EPM Junkie

Extracting UDAs from the Outline

First, hope everyone had a wonderful holiday weekend. Now it's back to real life... I have been doing quite a bit with DRM for a while now and am currently migrating a Planning application to DRM. One of my most recent tasks was to load the UDA's into DRM. Now

FDMEE

Dynamic Calcs from FDMEE Event Scripts

In a recent project I came across a process the client wanted to keep intact that seemed easy enough in FDMEE. They had multiple calc scripts saved in text files with custom ##VARIABLES##. These needed to be parsed, replaced and executed before or after certain data loads. In the old

Essbase

Essbase ASO Valid Consolidation Properties for Members

A quick cheat sheet of valid consolidation properties for Essbase ASO applications. Code Description % Express as a percentage of the current total in a consolidation (applies only to members of a dynamic hierarchy) * Multiply by the current total in a consolidation (applies only to members of a dynamic hierarchy) + Add

Essbase

Multiline Formulas using Load Rules

I've been racking my brain for weeks on how EPMA loads multiline formulas but there doesn't appear to be a way to do it manually. Finally I have a breakthrough. First I have replaced all the newline characters in my formulas with \n. For a test I created a small

Essbase

Formatted Member Formulas in DRM

One of the common issuses when using Oracle DRM as the source of metadata for Essbase and Planning is how to store member formulas. DRM isn't really designed for use with multiline properties. It allows for edting via the GUI but when dealing with action scripts or imports things get

Python

Python Tools

I've been playing around with python/jython a lot lately and have thrown together a small set of tools. These tools can be found on GitHub. Below I'll try to explain the purpose of each. This may end up being a mutlipart post as I plan to add to the

Essbase

EPM Security (Passwords)

As consultants we implement and work on a lot of EPM environments. Like most EPM installers we follow some well-known conventions when it comes to database schema names and user accounts. One other thing we, and many others, commonly do is use familiar passwords so that our teams can get

Essbase

Enable Essbase Studio 11.1.2.3.500 Query Logging

To enable query logging on Essbase Studio 11.1.2.3.500 you need to alter the logging.xml configuration file. Open the logging.xml file in your text editor of choice. /Oracle/Middleware/user_projects/epmsystem1/BPMS/bin/logging.xml The default logging level is set to INFO: <

Outline Extract

List Dynamic Calc Members

What is this? This morning my functional users were having issues with some older calculations due to DynamicCalc members being in the fix statement. Apparently some members in the outline were changed recently, within the last couple months, and no one updated the calculations, tracked the outline changes or did