I have a query which runs over an Infoset built over 3 ODS Objects.
It also involves some complex calculations and is a detail level report with 4 variables.
Right now Its taking about 30 min to run.
My question is , Is a precalculated result set possible ?Will the users will still be able to enter the variables?
How can this be done.I have no idea abt precalculated queries..
Any help is highly appreciated
With Precalculated Queries ,only static reports can be delivered :
Ashish ,you can create a variant for the variables that are using in the Reports --
In Parameter Tab -Variants
This way you can create different variants for the report and precalculate based on that.
Hope this helps.