Skip to Content

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

Jan 06, 2017 at 06:44 AM


avatar image
Former Member

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.



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

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.



10 |10000 characters needed characters left characters exceeded