Essbase

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 sum of products (quarter or year »

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 the data values shown in one »

I wrote a short side-note in a previous post 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 11.1.2.3.501. The issue still exists with »

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 and to have the value presented »

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. This was a mystery that I »