Skip to Content
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.

Enjoy, Marc

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply