BEx Query: Restricted KFbased on characteristic attribute

[former_member708950]

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

[former_member708950]

Clarification: In the image below I have tried to illustrate what I am after.... It is the green turnover numbers I am after...

[appel_solar_dk]

Hi Peter

I suggest that you ask the backend team to make 0custmer-FOKUSMTH navigational. Then you can restrict on calmonth in a restricted KF using offset to get the +1/-1

regards

Kristian

[former_member708950]

Hi Kristian, thanks for you input

But: I do not understand your suggestion. If 0custmer-FOKUSMTH becomes navigational and I restrict on this in a restricted KF it will introduce restrictions on Customers, not on 0CALMONTH. I somehow need to let the value of 0custmer-FOKUSMTH restrict the values of 0CALMONTH.

In the image I have tried to illustrate what I am after.... It is the green turnover numbers I am after...

[appel_solar_dk]

Hi Peter

My bad, you are right. I'm not sure but try to look into replacement path and you may start by ensuring that fokusmth is having 0calmonth as reference.

Regards

Kristian