Skip to Content
0
Former Member
Jul 15, 2005 at 03:15 PM

Precalculate Query

32 Views

Hi Friends,

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

Ashish.