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