Input variable value in selection variable

[Former Member]

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 · Accepted solution]

Any ideas on this?

[Former Member · Accepted solution]

Hi Dhanuka,

As per my knowledge it is not possible to create prompt variable on top of CKF.

I am not sure!

Thanks and Reagards,

Basavaraj

[Former Member · Accepted solution]

Hi Basavaraj,

Thanks for the reply. I understand it is not possible to create prompt variable on top of KF in BW 7.3.

Hi All,

Is there any other way to achieve my requirement in BeX.

Regards,

DTD

[Former Member · Accepted solution]

I have created a structure and get the date variable. This way eventhough the dataset is restricting, it is not restricted to the VAR1 + VAR2 value.

How do i achieve this?

[Former Member · Accepted solution]

Hi Guys,

Any help with this one?

Regards,

DTD

[Loed · Accepted solution]

Hi,

Create another variable for NEW VALUE with CUSTOMER EXIT as its PROCESSING BY..Then create a CMOD to add the VAR1 and VAR2 and pass the result to NEW VALUE variable..

Regards,

Loed

[Former Member · Accepted solution]

Hi Loed,

Thanks for the reply.

Yes i did get the new value as a number (by using 2 formula variables) in the report. This is done by VAR1 + VAR2 and i got the 22.02.2016.

I was hoping to get this done without having ABAP involved (Customer Exit). But i guess it is not possible without the Customer Exit.

Thank you very much for the input.

I will try this out with an ABAPer and let you know the outcome.

Regards,

DTD

[Loed · Accepted solution]

Ok, just inform us of the result..

Regards,

Loed

[Former Member · Accepted solution]

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.

[Loed · Accepted solution]

Hi,

Good to know that it worked for you..

Could you please elaborate how you subtracted value in the INPUT DATE without using CMOD?

Regards,

Loed