EPM Local Formula is required..

[Former Member]

Hi All,

I have scenario as below. Looking for your help to achieve this..

USER Wants to have whatif scenario on Plan B Category for particular month based on Plan A for the same month.

1st activity is user will key in Plan A data and save it and then Plan B data should be calculated Plan B. below given formulas. I am wondering to achieve this by EPM Local Formulas.

Can you give me formula definition..?

[former_member186338]

More questions, then answers:

1. The formulas for Plan B are fixed or user can play with formulas?

2. What do you want to do with formula results - just show on the report or save the result to the BPC model?

Vadim

[Former Member]

Hi Vadim,

1. The formulas for Plan B are fixed or user can play with formulas?

     Answer is : Plan B formulas are fixed and to be able to save to BPC Model.

2. What do you want to do with formula results - just show on the report or save the result to the BPC model?

   Answer is : Plan B formula result data should save to the BPC Model

Thanks. am I answered your questions..?

[former_member186338]

"Plan B formula result data should save to the BPC Model" - then local members are not very useful...

If formulas are fixed - then it's better to use script logic in default.lgf or dm package!

Vadim

[Former Member]

Ok. I tried before script logic, but I could not able to do it. am sure am not good in Script.

would you able to give me few lines of script logic..? that would be great helpful.

thanks.

[former_member186338]

If you are not good in script logic - please read documents starting with

and standard help.

You have to start writing yourself and if you will have questions - then please ask in line with

Vadim

[Former Member]

given links are helpful. Thank you Vadim. I will figure by going through them.

Thank you again.