Calculate SUMPRODUCT in Essbase ASO Using MDX
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.
Posts tagged with "hyperion"
Business Rules to Launch Them All
Learn how to launch batch jobs from Business Rules with Hyperion Planning. VB, C, Java, Perl, MaxL Esscmd, ODI, and even .NET have paved the road to now.
Introduction to Version Control for Oracle EPM
Learn how to use Mercurial version control tools to track changes to source code. This is a beginners tutorial for version control with Oracle EPM.
Pragmatic Version Control for Oracle EPM
You can use time-tested software development tools and processes with Oracle EPM to keep track of source code changes and revisions.
Updated Guidance on Customizing the FDMEE Open Interface Adapter
The FDMEE Open Interface Adapter can be customized and Oracle has provided updated guidance on the process that you should follow.
Debugging Drill-Through With Node.js
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.
Using Windows 8.1 and Internet Explorer 11 with Oracle EPM
IE 11 is not supported with versions of Oracle EPM prior to 11.1.2.4. Check out this post for tips on getting IE11 to work with Oracle EPM.
Unconfirmed Bug in CREATEBLOCKONEQ
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
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)
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.