Date Variable for BEx Query Issue

[Former Member]

Hi,

We have a cube attached to 3 DSOs with primary keys start date, end date, pernr and subtype. All have been loaded to the Infocube and it has all fields from 3 DSOs and one start date and one end date mapped from all start date/end date from all DSOs.

We have a requirement that user should enter a particular date then data should be picked.

For Ex : In Infocube if start date is 03.08.2017 and end date is 08.08.207. Even if user enters 07.08.2017, it should display the relevant data/rows but it's now happening as value 07.08.2017 is not actually in Infocube but lies in between the mentioned dates.

How to achieve this. Please suggest.

Warm regards,

Aman

[ashu33]

Restrict

Start date with Greater than Equal too and

End date with less than Equal too

[mv1985]

Please provide a solution or workaround.