Question:
Hi All,
I'm writing a check function in BPS using fox formula in order to be sure that all key figures were filled by the user, otherwise to report a error message. I'm doing this in a cycle foreach LINE that is the characteristic.
However the function goes only through those values of LINE char, for which the key figure was entered. The others are ommited by function.
As a result I don't get a error message for those that are not filled.
Does anybody know the solution? Maybe I'm wrong with the logic?
_________________
Best regards,
Anna
Answer:
It looks like that your code for error message is not hit. could please post your code in order for us to hlep you?
Answer:
Unfortunately I don't have the code at the moment , however I could say i use FOREACH for going through all the records. Recently, I was told that the function goes only through existing records, not through master data values.
If there is any other possibility to run check function in a cycle, not indicating explicitly each line, the selection for char LINE in the planning level is so that it's not consecutive.
Thanks a lot
_________________
Best regards,
Anna
Answer:
FOREACH looks up master data for that charecteristic and checks if there is any transaction data for that masterdata if it dosent find any, then code is not executed.
Solution: either include some Keyfig (may be actuals used as reference) or something to read all data where plan is 0.
Good luck
_________________
Visit my home page to find articles on SEM & BW. http://www.geocities.com/biwcafe
Cheers
Manu
Answer:
Hi
In such scenarios FOX formula may not work as they will be executed only for the characteristic combination that has data.
Try to use exit function.
Chirag
Answer:
Hi Nannile,
I developed a similar requirement for one of oour client.
Best way is to go out of BPS or SEM and use Javascript.
My case was also the same - whenever user leaves a field blank an error msg is thrown. infact, i coded it that the blank fields are filled with zero automatically.
i would suggest to try with Javascript as it woked for me on a similar scenario.
Do let me know if it works or if you face any other kind of problems.
Thanks
Andy