Skip to Content
Actions

Compare Bex Queries in Different Client /System.

April 17, 2013 | 875 Views |
 abapanalyticsautomatedautomationbeginnerbexbi query
Follow

From long time I was looking for BEX query comparison tool but I did not get anything and after long efforts I got one idea to compare Bex Queries in Different client.

And I wanted to share this with all of you.

Capture1.PNG

Many times queries are modified in production directly which create problem to keep queries in sync.

First of all I want to say it may not 100% accurate to compare Query in different client/system but it is boon to reduce your manual comparison of Query.

Let’s start with “How to Compare Query in Different client/system?”

Let’s have scenario here you want to compare Query from PROD TO DEV then

Go to PROD and enter Tcode RSRTQ

Capture2.PNG

Enter Query name as follows and execute.

Capture3.PNG

You will get all query definition as follows then click on Download(F9)

Capture4.PNG

Capture5.PNG

Click on OK…

Capture6.PNG

Then Go to  System -> List -> Save -> Local File

Capture7.PNG

Capture8.PNG

Press OK.

Then Create one text file in Notepad say PROD300.txt and paste and save.

Capture9.PNG

Similarly follow all steps in DEV also and create file DEV100.txt

Capture10.PNG

Now we will compare these two files using any Code Comparing Tools.

In my case I am using online Code Difference Comparison Tool .

Put your both code in Text pane 1 and 2 and compare.

Capture11.PNG

Then simply you can compare both queries from PROD & DEV as follows.

Capture12.PNG

Capture13.PNG

Hope this document will be helpful to the readers…

To report this post you need to login first.

31 Comments

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

  12. Venu Gopal Boddapati

    Good One Puskar, Gud efforts.

    One more easy way also we can check from here.

    That is After Providing query name here (In RSRTQ), we can select the check box for required Query Elements.

    Means, let us say, first select the Check box for Filter and execute then compare the fileter values maintained in Dev and Prod..

    Similarly for Rows / Columns, Cells, Input Variables, Exceptions & Conditions etc..

    Thanks,
    Venu

    (0) 
  16. Martin Grob

    Nice document…ultimately you should come to a non changeable production environment but it took us a long time too..now you can only create adhoc reports in a separate namespace and then you get rid of comparing queries in different systems

    Martin

    (0) 
  22. HS Kok

    It seems that sometimes the ordering of the characteristics/KFs in the query outline do not match across systems, making the line-by-line comparison impossible.

    (0) 

Leave a Reply