Skip to Content
avatar image
Former Member

Using formula variable (instead of infoobject) as a User Input for date range in BEx Query

Hi Experts,

We need to create a user input variable for single date range(energy audit period from-to) in Bex Query based on which report output should display data.And this user input variable should not be created from infoobject. We tried implementing this through formula variable but it can only be created for single value option but we want it for interval option(for date range).

Please suggest.

Thanks,

Priya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 09, 2017 at 06:36 AM

    Hi Priya,

    Create a second formula variable to capture the "To value" of the range. Seeing that you are not restricting any info object (date) with this range, you would probably be using a customer exit to process these variable values. In the customer exit you can use the value from both variables to create a range.

    Thanks

    Francis

    Add comment
    10|10000 characters needed characters exceeded