Question:
Hi,
We need to display time-based data as columns in Bex for Quarters 1 to 4 in the current year. However the version (Actual Or Plan) referenced in each quarter depends on which quarter we are in.
e.g. We are in Quarter 2. So the Q1 & Q2 columns should display Actual data, and Q3 & Q4 should display plan data.
Can anybody suggest a way of performing this dynamic selection within BEx?
Thanks!
Answer:
I think the most simple way to do this to create 3 kfs for each quarter i.e. 2 rkf for plan, actual, and 1 ckf. You hide the 2 rkf from display. In the ckf, you test to see if the column quarter is greater than the current quarter then display plan and if not display actual.
This is just an idea, you have to work out the details and test for yourself.
good luck