Skip to Content
avatar image
Former Member

Reference Key Figure

Hi,

I am trying to understand the reference key figure use as it will be used in our upcoming project but not able to find any good documentation. SAP official help is a bit confusing to me. If anyone can explain it's use case in simple terms and what it is and the concept of elimination.

-> Also I have a requirement at bex query level that if a month has no sale, that month should be displayed with value 0 in key figure. How we can implement this ?

regards,

AN

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 04, 2017 at 08:40 AM

    Hi,

    I like the ref KF very much. it means that you use the same values of the refered KF (original KF) but the new (Reference) KF will calculate the values differently. Take for example a dataset filled with amount of orders in different periods and other dimensions. Amount is your original KF and now you create MaX amount, Min amount and Average amount all set set as reference KF of your original amount. In the properties tab of those KF you set the exception aggregation accordingly for exc char period.

    Now in your Bex report, you drag Period in the rows and all your KF's in he columns. And wou will see those KF giving the Sum/Max/min/average per period. great isn't it.

    This kind of trickery I used a lot for timestamps, to be able to retrieve the Max timestamp and the min timestamp.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 08, 2017 at 02:27 AM

    Also I have a requirement at bex query level that if a month has no sale, that month should be displayed with value 0 in key figure. How we can implement this?

    ---> Just click your CHAR PERIOD and under the EXTENDED tab choose MASTERDATA in ACCESS TYPE FOR RESULT VALUES.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded