We would like to see in the DV dataset reload dialog something equivalent to what we have in the Classic dashboards or publisher reports we were previously using in OBIEE i.e. equivalent to Dashboard Prompts or Publisher Variables. We have shifted to using DV datasets because it is a great solution for extracting data from complex databases doing it in multiple steps and joining in the dataset. So our OAS analysis queries are used in datasets and not anymore in dashboards. But we lose the flexibility to have users select their time period, their product, etc.. Could this be added inside the dataset reload dialog (both manual reload and scheduled) with corresponding variables (prompts) used inside the analysis queries. This would then be close to the perfect solution for our business needs in the area of drug safety reporting.
Note that we cannot use the concept of presentation variables in the dataset because the size of our database makes it mandatory to apply variables/prompts inside the query which extracts the data from the database.
Thanks for looking into this request!
