How to evalauate Complex CKFs built in Bex Queires

[Former Member]

Hi Gurus,

I am wondering, is their any way we can evaluate the complex nested existing CFKs to see how to they behave since it is very difficult for a new comer to gain understanding the CKFs built & logic besides it.

Let say for example , I open a CKFs & I found it is build or addition of other another 2 CKFs. When I start drilling these 2 CKFs , I found these are further nested with multiple CKFs & RKFs in it.

Under such scenario , It is difficult to debug or answering questions why this particular column is empty or contains a right/wrong data.

Attaching a scenario, please provide on your experiences how to deal with such scenarios.

Here for this scenario my favorite Bex Option ( running in RSRT , then selecting the Key figure -.right click->extended menu-> key figure details-> details also do not work which gives all the static & dynamic filters used to fetch the report value .

Best Regards,

Fox

[Former Member]

Hello Fox

check below link

[Former Member]

Hi Sai,

The same we can achieve as I mentioned in my post. its just a another way of navigation. But may be surprise for you, this does not drill at the lowest granularity level. Infact for one of CKF which I have attached for reference the moment I select the Key figure definition it says ' Definition cannot be shown since it has constant selections) ..

Any more tricks & techniques that you found.

Thanks for the reply.

Regards,

Fox