Using the Fox Formula in SAP BI Integrated Planning

FOX formulas are an effective option within SAP planning for efficiently handling data in SAP Business Planning and Consolidation or BW IP. It is crucial to comprehend how FOX formulas function in terms of block formation, as this knowledge aids in debugging and optimizing the performance of your planning solution. This article provides a comprehensive explanation on the creation process of blocks within FOX formulas.

Formation of Blocks in BPC and SAP Integrated Planning

A FOX formula is typically run multiple times consecutively. Initially, the data that meets the filter criteria is separated into segments or blocks. Subsequently, the planning function is performed for each individual block.

Characteristics that were not chosen to be modified are grouped together, forming a block. Hence, these characteristics are commonly referred to as block characteristics.

The system internally creates blocks to help convert FOX formulas into ABAP code. A loop is generated for each characteristic in the block.

How to verify the Fox formula?

On the tab “Methods” find method “EXECUTE_SERVICE” and click twice on it to open it.

– Press button “Set session break-point”.

– Start transaction RSPLAN and select the planning sequence containing fox formula you want to debug.

You might be interested:  Understanding the Pricing Procedure in SAP MM

– In the ABAP debugger go to the last tab, which is “Script”.

Block characteristics in BPC and BW IP

All data records in a block have the same characteristic values for the block characteristic. Let’s look at an example to illustrate this. The displayed data sets represent the initial data:

The following blocks are created by the system. The characteristic value of the company code is identical for each block. Note, however, that the sort order of the blocks can be random.

If no characteristics are chosen for modification, all characteristics will act as block characteristics. This will result in one call being made for each data record, leading to the formation of four blocks.

In contrast, if you choose to modify all characteristics in the selection, a single block will be generated as there are no block characteristics. All data records will be processed with just one call.

The table shows different scenarios for changing fields in SAP BI Integrated Planning. It provides information on the block characteristic, number of calls, and data records involved in each scenario.

Comparison of Planning Tools – SAP BW IP vs. BPC vs. SAC

Understanding the process of block formation helps to comprehend its impact on performance. It is advisable to limit the values of block characteristics in the filter to minimize the creation of excessive blocks.

Using a HANA database brings strong performance advantages. By default, the FOX formulas are executed in the HANA database. However, you should consider some restrictions. The following commands are not supported in the HANA and therefore the FOX formula is executed on the application server, so you cannot benefit from code push down :

You might be interested:  Understanding Subcontracting in SAP MM

FOX formulas – Our

As you may have observed, the formation of blocks plays a crucial role in ensuring efficient data processing when utilizing FOX formulas.

You need to determine the number of blocks you want to create based on your specific situation. It is crucial to accurately set the filters for block characteristics in order to minimize both the amount of data records that need processing and the number of blocks that need creation.

Moreover, having this understanding will enhance your ability to effectively troubleshoot FOX formulas.

Sebastian Uhlig has been providing consulting services for SAP BI solutions to companies in different sectors, both nationally and internationally, since 2001. His expertise includes analyzing requirements and implementing intricate solutions. He has successfully led project teams and is the creator of NextTables. In his free time, he enjoys mountain biking and watching American football matches.

The role of ATRV in Fox

To determine the attribute value, you can use the ATRV function in SAP BI Integrated Planning. This function requires two parameters: the technical name of the attribute (such as 0PRICE) and a variable that refers to the characteristic to which the attribute belongs (for example, 0ARTICLE). By using this function, you can retrieve specific information related to attributes within your planning process.

– The ATRV function is used in SAP BI Integrated Planning.

– It helps determine attribute values.

– You provide two parameters: the technical name of an attribute and a variable referring to its characteristic.

Debugging a planning function: How is it done?

Debugging in IP FOX planning functions can be invoked by the classic ABAP statement Break-Point. You can start debugging either by executing the planning sequence or using the program RSPLS_PLSEQ_EXECUTE . Once started the ABAP debugger would open up with the FOX code generated in ABAP and not in FOX.

You might be interested:  How to establish a purchasing group in SAP using Tcode

Debugging the Fox formula: How is it done?

Here is a step-by-step breakdown of the process, along with their respective time intervals:

1. Set a Break-Point in ABAP (0-26 seconds)

2. Start the Planning Function (27-44 seconds)

3. Start the Fox Debugger (45 seconds to 1 minute and 3 seconds)

4. Step into the First Block (1 minute and 4 seconds to 1 minute and 15 seconds)

5. Debug the Function Logic (from 1 minute and 16 seconds until the end)

This information is provided in English suitable for readers in India.

What do Fox 1 refer to?

In the context of military aviation, “Fox one” refers to the launch of a semi-active radar homing missile like the AIM-7 Sparrow. On the other hand, “Fox two” indicates the launch of an infrared homing missile such as the AIM-9 Sidewinder.

1. Fox one: Launch of a semi-active radar homing missile (e.g., AIM-7 Sparrow).

2. Fox two: Launch of an infrared homing missile (e.g., AIM-9 Sidewinder).

Finding a red fox: How is it done?

Red foxes can be found in various regions of the continental United States, spanning from Alaska to Florida. However, the population of red foxes is relatively smaller in the Southwest region, making it a rare sight to encounter one there. These adaptable creatures prefer habitats such as open areas within woodlands, rural and suburban neighborhoods, wetlands, and brushy fields.