cancel
Showing results for 
Search instead for 
Did you mean: 

Variable/Field in BEx to get from user input

Former Member
0 Kudos

Is there a way in BEx where I can create a variable/field that gets its value from user input in Webi?

Here's my scenario:

User inputs date in the prompts in Webi (MM/DD/YYYY), I want Bex to have a field that gets the MM.YYYY from the user's input and increment it by 1.

I have used a solution for this but only applies for the tables in my webi report, but it's not working for the category axis in my line chart.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

The solution is to push the prompting all the way to BEX level:

* in the query, make or use a date input variable where the user can enter the required date. This will generate a prompt in the webi

* in the query, add another variable of type customer-exit on the month-object (not ready for input) and then fill it in the variables user-exit as desired, based on the value the user entered in the first date-variable

Former Member
0 Kudos

Hi Tom,

I already have those variables and they are used as selection criteria in the columns of my bex query. Is there a way that I can use that as the labels for my category axis in webi?