Question:
Dear colleagues,
I need to replace an obsolete keyfigure by another one, not only directly in queries, but also in the huge pile of calculated keyfigures.
My question: Is there a table, transaction, report, anything,... that will show me in which calculated keyfigures a specific keyfigure is used?
I'm working in a BW 3.1 system. If only newer releases have such functionality please let me know as well.
Kind regards -- PJ
-
Answer:
First keep in mind that the RKF and CKF are associated with the InfoCube. So, the same KF InfoObject could have been used in diffeent InfoProviders.
The table that stores CKF entries is RSZCALC. You can find related tables using RSZ*. For example, RSZCOMPIC tells you which InfoProvider has this CKF.
_________________
Sudhi Karkada
Answer:
Hi Sudhi,
thanks for you feedback, but these (and other RS*) tables do not solve my problem. The tables you provide return ID's to which I cannot relate with my input.
My input is a KF's description and technical name. With that information I am looking for the "compounded" result [InfoProvider/CKF] (> descriptions or technical names) telling me in which CKF my original KF is used.
Would you be able to elaborate on your solution, and start from my input?
Thanks -- PJ
Answer:
Sudhi pointed in the right direction. At SDN Ajeet has provided the details that solved my problem completely:
Go to table RSZCALC give the name of your key figure in the name of the option of formula operand.....there are two options for operand..... give one infoobject in any option one at a time.
Get the value of ELTUID from here and give this input to the table RSZELTDIR this table will give you all the Calculated key figures and the queries which they are used.
I had to copy the ELTUID and add a wildcard at the end as the searchfield for ELTUID in the RSZELTDIR table is shorter than the values it returns (...). The result is not a "one peek" overview, but shortens the effort substantially.
Thanks to you all -- PJ