Calculate SUMPRODUCT in Essbase ASO Using MDX

By Justin Biard September 18, 2015 4 min read

In this quick tip we take a look at how to calculate SUMPRODUCT (similar to Excel) but using the MDX scripting language in Essbase for ASO cubes.

Debugging Drill-Through With Node.js

By Justin Biard December 11, 2014 12 min read

You can debug HTTP drill-through requests from Oracle EPM products using Node.js. Follow this tutorial to setup an HTTP server in Node.js and debug away.

Unconfirmed Bug in CREATEBLOCKONEQ

By Justin Biard August 16, 2014 3 min read

There may be an unconfirmed bug in CREATEBLOCKONEQ in Essbase where it creates blocks even when set to OFF. A possible workaround can be found here.

Planning Date Type to Unix Time

By Justin Biard July 26, 2014 6 min read

Use Essbase calculation script functions and 86,400 seconds per day to convert Planning Dates to Unix dates. This is useful for various Essbase date calcs.

Have You Seen Me? (Missing Block)

By Justin Biard July 19, 2014 5 min read

Essbase calculation scripts that don't produce any values are often the result of missing blocks. Take a look at this post to see how to create blocks.