Input variable value in selection variable
My scenario is as follows. Please note i'm on BW 7.3.
I have Posting Date and want to have user input number of days to add to the posting date. Then i want the user to select the posting date range based on the new value.
Posting Date Input Value New Value
20.02.2016 2 22.02.2016
Basically with the above example when the report execute i want the user to select the posting date range and if select 22.02.2016, i only want to display the values for 22.02.2016.
Ideal Variable Selection Screen:
Input value ......................
Posting Date From.................. To......................
I created a variable with Replacement Path for Posting Date (VAR1) and another variable with input value option (VAR2). Then i created a CKF with the sum of VAR1 + VAR2. This way i'm getting the new date. I'm not sure how to create a prompt variable (as a date range) on top of the new CKF.
Any help is highly appreciated.
I found a workaround for this and its working fine.
What i did was in a formula i have done was deducted the input value from the original date value.
Ex: Date1 , Date2, Var1 (Input Value)
Solution: Date1 - Var1 (CKF1)
CKF1 - Date2
This worked for me and gave the results in a simple way.
Closing the thread.