SAP BPC Script Logic for calculating rates model with Opex Accouts(Properties)

[Former Member]

Good day Experts

Please assist me to Lookup the Rate Account model , and calculate it with the correct Account property from the OPEX model. I am unable to create a Variable for a list of all the Rate account in order to calculate with the correct OPEX Account property.

How do I make Rate Account dynamic and not hardcode to one e.g "CPI"?

Help me to calculate with all the time periods in Rate , not hardcode to 1 month?

kindly find the attached script I ran and the results as well

Thank you

Kindly assist me

SCRIPT 28 08 2015.txt.zip

[former_member186338]

Hi,

Why you are trying to create the custom script for some rate conversion? What is the real business requirements? Please read

"I am unable to create a Variable for a list of all the Rate account in order to calculate with the correct OPEX Account property." - please read help about LOOKUP - the selection by property is clearly explained here...

Vadim

[Former Member]

Hi Vadim,

Thanks for you respond.

I am not creating a rate conversion,

The requirements are to apply increases based on the Global rates

Thanks

[former_member186338]

Sorry,

"The requirements are to apply increases based on the Global rates" - unclear!

Looks like you have no time to explain requirements in details. Then I am unable to help you.

Vadim

[Former Member]

Good Day

Kindly find the attached Requirements which I have drafted step by step od what we need to do, and the script which I have also ran. Thank you very much for you assistance

Requirements.txt.zip

Script 04092015.txt.zip

[Former Member]

You may test something similar... *LOOKUP RATE *DIM R_ACCOUNT =ACCOUNT.INCREASETYPE *DIM CATEGORY = BUDGET_APPROVAL *DIM R_ENTITY = GLOBAL *DIM RATEINC:INPUTCURRENCY=ENTITY.CURRENCY *ENDLOOKUP

[former_member186338]

Why do you think that the rate model is a good idea for the increase calculations like this???

Why not to use special accounts in the main model to store the increase coefficients?

I do not understand the reason...

Vadim

[Former Member]

Thank you very much Al Sathappan

You recommendation was 100% working,  it works with the R_Account, now the problem is how to make it calculate with all the months from rate model, I currently hardcoded to the below::

*DIM RATEINC: Time_ Period=%current.period% which is only calculating with 1 month?

Thank you very much

[former_member186338]

Why do you need to fix TIME_PERIOD in LOOKUP? Without fixing the current TIME_PERIOD will be used.

Vadim