Hyperion Planning (MOSC)

MOSC Banner

Business Rule - Execute the calc based on Variable Prompt

edited May 20, 2016 3:44AM in Hyperion Planning (MOSC) 10 commentsAnswered

Hi,

I need some suggestion to modify the below script for the new requirment,

User requested Period member to be listed in Variable prompt so that they can select the required period rather than running the script for complete P01 to P12. In this case they can select any period or multiple period and based on the period selections it should pick  the script line written for specific period.Is this possible ?

for example if P01 is selected it should pick  below script

If( @ismbr(@RELATIVE("Profit & Loss",0)))

"P01" ="P01"->"GL_Primary" + "P01"->"GL_Adjustment"; )

and P01 and P11 is selected it should select both P01 and P11 script.

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