I have created an Automation Tool (ABAP-BI Program) to find
out the Overall Query name where same Calculated and Restricted Key Figures are
used.

 

This program will help to identify all query name where we
need to amend / changes on the existing CKF/RKF so that we can check the
dependency queries in advance and be careful before any changes.

   

Recently we have faced the same issue in Production that someone
has changed the structure of CKF Z_SUM_RV in X Queries and it’s impacted to all
others query.

Please see the details below:

    

Go to SE38 Tcode and Put Program Name: “ZFIND_KF_QUERY”. And
Execute it.

CASE 1: Use Calculated Key figure:->

  

Step 1:–> Selection Screen: Put CKF: Z_SUM_REV. Then execute this program.

         /wp-content/uploads/2015/07/image1_749140.png

Step 2: Output comes as follows:

              /wp-content/uploads/2015/07/image2_749144.png

CASE 2: Use Restricted Key figure:–>

    

Step 1: Selection Screen: Put RKF: Z_APRIL_ACTUAL. Then execute this program.

            /wp-content/uploads/2015/07/image3_749146.png

Step 2: Output comes as follows:–>

/wp-content/uploads/2015/07/image4_749150.png

Please find the attached ABAP Code:

To report this post you need to login first.

3 Comments

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

Leave a Reply