Hyperion Essbase (MOSC)

MOSC Banner

A better calc than this for combining forecast and actual

edited Jul 15, 2014 5:00AM in Hyperion Essbase (MOSC) 1 commentAnswered

All,

I have been tasked to create a member formula in an ASO cube. The idea is to have a scenario that holds actual data from the beginning of the year to the current month and forecast data from currmonth+1 to year end. I can do the report very easy in Financial Reporting but we have been asked to solve as a member formula so that all users can use the scenario. I have come up with a valid script that works correctly, but am wondering if there is a better code out there. Apprecate if you can share.

My code

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center