Essbase - 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

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

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.