Hyperion Planning (MOSC)

MOSC Banner

Simplify Business Rule by eliminating

Greetings,

I'd like to rewrite my rule to eliminate having to constantly update it based on business conditions. Currently, if a new country is added, then I add a new elseif condition, as such:

if( @isuda( "Entity", "MERIT_EXCEPTION" ))

 if ( @isuda( "Entity", "SL_China" ))

"Merit" = "Salary" * "CH"->"No_Entity";

elseif ( @isuda( "Entity", "SL_Japan" ))

"Merit" = "Salary" * "JP"->"No_Entity";

elseif ( @isuda( "Entity", "SL_Vietnam" ))

"Merit" = "Salary" * "VN"->"No_Entity";

else

"Merit" = "Salary" * .10;

endif


I'd like to simplify such that the member of the current entity is picked.

 if ( @isuda( "Entity", "SL_MERIT_EXCEPTION" ))

"Merit" = "Salary" * MBR_OF_THE_CURRENT_ENTITY->"No_Entity";

Tagged:

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