SAP BW Custom Dependency Queries for same Key figure (CKF_RKF) Used Program.
Automate tool Program to check the dependency Queries where same calculated / Restricted Key Figure are used.
Purpose of this as follows :–>
The goal of this work is to create a new tool to find out the total query name where the same calculated and restricted key figures are used Calculated Key Figures CKF/ Ristricted Key Figures (RKF).
This initiative was born because recently we faced the same issue in production when someone has changed for example the structure of CKF Z_XXX_XXX in one or several queries and this change have produced an impact in the others queries that have a dependency with the modificated query.
Conclusions : Before making any changes in CKF/RKF (in fact in X or Y also) please use this tool to find out the dependency Queries and impacts. And then consult with leads and do the changes accordingly.
Creates the following program through transaction SE38 as per the following screen-shots.
Creates ZFIND_KF_QUERY program–>
Attributes of the Main Program:
Text elements used in the Main Program:
Selection Screen Texts used in the Main Program:
Use Calculated Key figure:
Step 1: Put CKF: Z_SUM_REV in the selection screen and execute this program.
Step 2: Now you can display the next output.
In That way you can find the dependency Queries name before any changes in CKF and RKF Key Figures. These program given as dependency query lists.
Custom Code should be as follows :–>
Attached as Txt Files.
Thanks & Regards,