Skip to Content

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:

1.JPG

Step 4:

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

2.JPG

Step 5:

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

3.JPG

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.

6.JPG

Step 8:

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

7.JPG

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.

To report this post you need to login first.

2 Comments

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

  1. 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

    (0) 
  2. 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.

    Regards,

    Avinash

    (0) 

Leave a Reply