Hello Friends,
Whether you work with BW Business Planning & Simulation (BW-BPS) or with BI Integrated Planning (BI-IP), you have probably created quite a few formula planning functions (FOX). Now there are a few cases where you want to perform a syntax check of you formulas. This blog describes a nifty solution for you!
Use Cases
1. Release Upgrade
You have upgraded from a lower release to SAP NetWeaver 7.0 or higher. In this case you might run into syntax errors because we implemented a couple changes.
- FOREACH statement to loop over reference data
- Assignment of values to local variables
You can find this information also in SAP Note
1327675.
2. Formulas Saved with Error
Since release 7.0 it is possible to save formulas although there are syntax errors. This allows you to saved unfinished work, however users will receive errors should they try to execute these functions.
Solution
I have developed a couple programs that you can use to perform the syntax check. You can find them in the
SDN Wiki.
Best,
Marc Bernard
@marcfbe
