Skip to Content
0

Date Variable for BEx Query Issue

Aug 24, 2017 at 11:50 AM

73

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Aug 27, 2017 at 04:12 AM
0

Please provide a solution or workaround.

Share
10 |10000 characters needed characters left characters exceeded
Ashu Yadav Aug 27, 2017 at 02:23 PM
0

Restrict

Start date with Greater than Equal too and

End date with less than Equal too

Share
10 |10000 characters needed characters left characters exceeded