Hello Experts,
I am having one requirement. Need you guys inputs on how this requirement can be completed.
We need to design BEX query such that it gives option to user to select time range from the drop down or by radio options. The date field used will be Ship date. The options that they need in drop down are like Yesterday,This Week, This Month, Last Quarter, Last Quarter. When user selects, suppose, This Quarter from drop down , he/she should be able to see data for This quarters only.
We are already having separate query for each time range. We have created seperate varible based on Ship date for each query. But they need this in one query now. The BEX query subsequently will be accessed in BO WEBI.
We are on BI 7.4.
Please provide your valuable inputs on this. If there are any alternate ways in which we can satisfy the requirement, please let us know those ways as well.
Thanks in advance.
1 Answer
-
Posted on Aug 18, 2016 at 01:28 PM
I am not sure in bex but you can do this in Webi. not on the variable screen but a a filter inside the webi report. you can create a variable or dimension for data for yesterday as marked 1, last week as 2 this month as 3 and so forth and use filter to let customer decide what data they wanna show. This way they can see al the data and just filter through what they wanna see, you can use drop down filters for this. in bex I think you will need customer exit on step 1 to see what date are they putting I/ do you already have input from drop down for customer to pick last week, this month etc? or do you need to populate texts for last week, yesterday etc... if its there then you can run the exit to find the data for that time frame only. if not then I think you might need to create multiple variables and make them optional and let customer pick either 1. or last option is to do in universe with conditional optional but will still require coding to bring the data in ..
Add a comment
Add a comment