Hyperion Essbase (MOSC)

MOSC Banner

BSO TO ASO Formula conversion

edited Nov 7, 2019 4:07PM in Hyperion Essbase (MOSC) 2 commentsAnswered

Hi Experts,

I have a BSO cube with the member formula below in QTR1. How do I write this in ASO member Formula? Your help will be much appreciated.

IF(@ISUDA("Account", "Average-Actual"))

IF(@ISUDA("Year", "Hsp_LeapYear"))

("Jan"*31 + "Feb"*29 + "Mar"*31)/(31+29+31);

ELSE

("Jan"*31 + "Feb"*28 + "Mar"*31)/(31+28+31);

ENDIF;

ELSEIF(@ISUDA("Account", "Average-Actual365"))

("Jan"*31 + "Feb"*28 + "Mar"*31)/(31+28+31); 

ELSEIF(@ISUDA("Account", "Flow") OR @ISMBR("Account"))

"Jan" + "Feb" + "Mar";

ENDIF;

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