Skip to Content

Date Variable for BEx Query Issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    Please provide a solution or workaround.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 27, 2017 at 02:23 PM

    Restrict

    Start date with Greater than Equal too and

    End date with less than Equal too

    Add comment
    10|10000 characters needed characters exceeded