Hyperion Essbase (MOSC)

MOSC Banner

Can some one explain why this works?

edited Apr 24, 2015 10:01AM in Hyperion Essbase (MOSC) 1 commentAnswered

All,

Writing a BSO calc script.

I have a calculated measure RPU that is defined (MajXXXX + MajYYY)/2

When I view the calculated measure in YTD or QTD I want it to always use MTD

So I go and change the way that I view my YTD to say soemthing like

IF (@ismbr(RPU)) Jan;

Else DecYTD + Jan

Endif;

Executing the above give me JanYTD which is what I don't want.

If I change the script to:

IF(

     @ismbr(MajXXXX) or

     @ismbr(MajYYYY) ) Jan;

Else DecYTD + Jan

Endif;

When executed it works.  I am at a a loss, as when I read

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