How to Debug BEx Query?

Scenario:

A particular KeyFigure is being calculated at query level and the values shown in the report are not as expected. This document will help you to analyze what restrictions and formula, system has used to come across the values shown in report output.

Procedure:

Step 1:

Go to transaction code RSRT in SAP BW system.

Step 2:

Execute the query containing a KeyFigure for which you want to check the calculation logic.

Step 3:

Query output will be shown as below:

Step 4:

In this screen, select the button “Key Figure Definition” to see the calculation logic for a particular key figure.

Step 5:

Select the key figure in which you are interested, from the given list of query key figures.

Step 6:

Click on “Continue” to continue.

Step 7:

After clicking in continue, following screen will appear. Drill down the key figure to see the details of restrictions and formula used to calculate that particular key figure value.

Step 8:

Drill down the nodes you are interested in to check for characteristic restrictions, filter values and formula used.

Here, following are the components for the Key figure calculation:

1.  Dynamic Filter: These are the key figure level characteristic restrictions. For example, a restriction used for a restricted key figure would be shown under dynamic filters.

2.   Fixed Filter: These are characteristic restrictions used at query level. The restrictions created in filter section of query are shown under fixed filter.

3.  Key Figure Details: This area shows the details of the formula used to calculate a particular key figure. We can see individual formula component values in this section.

With the help of above details, you can check out the formula and characteristics restrictions applied for a key figure and its value at each individual step of calculation.