Hello
I have a query which is running very slow and I am trying to use the Cache feature
If i run the report more than once it hits teh cache correctly
So, i want to trun the report once in teh morning and then make good use of the cache ( i wouold like to do it with Agents but apaprently does not work with the dates filters, but will resolve that later)
The poblem now is , when i set prompt filters , if i do that it does not hit the cache and creates a new entry in the cache every time i set a prompt
I tried to fix this adding the prompted values into the select clause without filter, in order to select all th combinations of thata with all the combination of possible filters
However it still does not work , creatres a new entry for no selection , and for each prompt selection
Is that expected behavior? Is there a way to prevent this? Am i missing some configuration?
The idea is not to have to run the report with all the combinations of values in the promptts to make it run faster
Thanks
Camilo