Hyperion Essbase (MOSC)

MOSC Banner

Check member assigned to a variable

edited Sep 17, 2018 3:07PM in Hyperion Essbase (MOSC) 2 commentsAnswered

Hi,

Is there a function to check the member name assigned to a substitution variable? For e.g. If the value of the variable is Jan, I want to do a certain calculation, If it is Feb, then something else.

I tried something like this. Doesn't work

Fix("Finance Division")

"Return On Capital"

(

IF(@ISMBR(&form_currmonth) = "Jan")

#missing;

ENDIF;

)

ENDFIX

Regards,

RR.

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