Hyperion - ICODEALOT

Calculate Sum-Product in Essbase Using MDX

In Microsoft Excel you can calculate the sum of products (A x B) for multiple lists of numbers (arrays) using a formula such as =SUMPRODUCT(D3:F3, D4:F4). Some common examples of when you may need this include weighted averages or an accumulated

Hyperion

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

Hyperion

Intro to Version Control for Oracle EPM

Find out how to go from "zero to version control" in less than 12 minutes. In a previous post [https://icodealot.com/pragmatic-version-control-for-oracle-epm/] I wrote about using version control tools with Oracle EPM. Based on all the feedback I received from that

Hyperion

Pragmatic Version Control for Oracle EPM

This story does not have to end on such a sad note. Stories like this one can happen any time we open up a system for change. The rest of this post shows examples of how to use version control software with Oracle EPM.

Hyperion

Updated Guidance on Customizing the FDMEE Open Interface Adapter

Please skip ahead to the next section if you already know about FDMEE and the history of the product otherwise please continue for a brief introduction. FDMEE is the amalgamation of two separate products historically. Just a few major releases ago Oracle introduced a

Essbase

Debugging Drill-Through With Node.js

Reporting or ad-hoc analysis of summarized data values is often sufficient but there are times when you or your client may be looking for more functionality. I frequently get requirements for “drill-through”. Drill-through in this context means a user is able to navigate from

Hyperion

Using Windows 8.1 and Internet Explorer 11 with Oracle EPM

Update: (03 Apr 2015) I don’t plan to update this post further but wanted to provide this final update. As of Oracle EPM version 11.1.2.4, IE11 is now supported. This is great since it does not require a work around

Essbase

Unconfirmed Bug in CREATEBLOCKONEQ

I wrote a short side-note in a previous post [https://icodealot.com/have-you-seen-me-missing-block/] that CREATEBLOCKONEQ did not seem to be working correctly. I had a Linux server with Essbase 11.1.2.3 (no patches at the time), but now has Essbase patched to

Essbase

Planning Date Type to Unix Time

Hyperion Planning ships with a feature that allows you to create Date type measures for those times when a calendar date is relevant. (Hire Date for employees, Purchase Date for assets, etc...) This is a cool way to represent calendar days on planning forms

Essbase

Have You Seen Me? (Missing Block)

By the time my eyes and my brain could not take anymore I decided to put this calculation script away for the day. It was syntactically correct, mathematically correct, syntactically correct (just double checking) and could run to completion in less than a second.