List contents of all Calculated Key Figires

[Former Member]

Hi Gurus

I am looking for a way to list all Calulated and Restricted Key Figures on a Cube including the contents ( i.e. the details including the resitrictions etc.). I have looked at table RSZELTDIR but it does not have the details I want. This would save me a ton of documentation.

Thanks Laura

[Former Member · Accepted solution]

Hi Again

I looked at those 2 tables but it still does not give me the restrictions and calulations in teh RKFs & CKFs.

Doing this by Report would work for me. How/where do I do that ?

Thanks Laura

[Former Member · Accepted solution]

Hi

All the Calculated and restricted key figures are stored in table RSZELTDIR. To view all the calculated key figures & restricted key figures, go to SE16 and give the 'Definition type of an element' as CKF(calculated KF) and SEL(Restricted KF).

This will give you the ID. You can then give this ID in the table RSZELTXREF to find the Element ID of the query & the infocube on which this KF is defined.( First ID in this table is the ID of the query and the 2nd ID is the ID of the query component).

You can then use this query element ID in the table RSRREPDIR to get the query technical name.

also refer the RSDDKF table

Thanks

Suganya

[shanthi_bhaskar]

Please check RSZCOMPDIR table it will have RKF and CKF's init

and also check V_CMP_JOIN

[former_member181964]

Hi,

Cube wise you can't find but you can find using Report wise. All there calculations are based on Report, and it won't contains in Cube/DSO.

Thanks

Reddy