Skip to Content
0
Jun 27, 2016 at 10:33 AM

how we can avoid Loop in this calc case?

54 Views

Hello All -

We are working in BW 7.5 SP03.

We are planning to give an access to the superuser to create the formula in FOX. However, we tried to give the FOX template for the to create the Formula. In the FOX template, we are longing for the superuser only maintain:
{AMOUNT, ACCOUNT}.

However, if our BPC Input is like below -

Account 2015201620172018100101151515151001022020202010010330303030

My understanding is we need to use FOREACH and YEAR.

e.g.

DATA V_YEAR TYPE 0FISCYEAR.

FOREACH V_YEAR.

{AMOUNT, V_YEAR, 100104} = {AMOUNT, V_YEAR, 100101} + {AMOUNT, V_YEAR, 100102} + {AMOUNT, V_YEAR, 100103} .

ENDFOR.

We found that it's to difficult for the user. We want to avoid FOREACH, and YEAR. We only want user to enter ACCOUNT, and AMOUNT so it will be like that:

{AMOUNT, 100104} = {AMOUNT, 100101} + {AMOUNT, 100102} + {AMOUNT, 100103} .


Do you have any advice how we can achieve that?

Many thanks,
Daniel.