Skip to Content
Author's profile photo Geetanjali Deshpande

How to Debug BEx Query?


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.


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” 4.JPGto 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.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Benedict Venmani Felix
      Benedict Venmani Felix

      hi GD nice one

      You can also try this,

      In RSRT you can slect 'HTML' from the drop down list and execute.

      Then RightClick on the KF value and choose 'Enhanced menu' then choose 'Key Figure Definition'.

      Since the putput is in HTML, it would look more legible 🙂

      Regards, BenyV

      Author's profile photo Avinash Verma
      Avinash Verma

      Nice article, we can also execute Bex query in RSRTQ to get it's detailed level query definition i.e. what are infoproviders and how filters, key figures , selection and formulae are defined.