Skip to Content
Author's profile photo Puneet Pokharna

Program to check the dependency Queries where same calculated/Restricted Key Figure are used.

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:

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice document with scenario. very helpful!!!

      Author's profile photo Former Member
      Former Member

      Its very worth ful..

      Author's profile photo M Tibollo
      M Tibollo

      you can use the metadata repository to achieve the same.

      M.

      Author's profile photo John Barrero
      John Barrero

      Where is the attachment available?