Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Input variable value in selection variable

Hi All,

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.

Ex:

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.

Regards,

DTD

Former Member
Former Member replied

Hi All,

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.

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question