Skip to Content
0
Feb 03, 2023 at 09:42 AM

BEx Query: Restricted KFbased on characteristic attribute

85 Views

Hallo out there... looking for at solution in BEx variables to support the following scenario:

In my Bex Query I have in the rows the characteristic 0CUSTOMER. In the columns I have the keyfigure "Turnover" pr 0CALMONTH ( = very basic setup!) On 0CUSTOMER I have an attribute "FOKUSMTH" which provides the info that on this month special sales focus was given to this customer.

I would like to be able to generate two restricted KF on "Turnover":

KF1: Where the months I consider are restricted to the periode before the "FOKUSMTH"

KF2: Where the months I consider are restricted to the periode after the "FOKUSMTH"

So I need a BEX variable that for each customer (= for each line in the report) returs the attribute "FOKUSMTH" from the customer on that line so that I can use this value to restrict on 0CALMONTH.

Please advice...

Regards Peter Starup