Skip to Content
0
Former Member
Jun 06, 2009 at 01:37 PM

Query performance optomization

27 Views

Hi experts,

We have a query which is based in multiprovider. Multiprovider is based on 3 info cubes(Stock,sales and purchasing.)Each info cube contains 8 aggregates catogory wise.

When i run query by selecting one catogory individuall giving results with in 30 seconds.

If i choose more then one catogory it took one (EX 2 catogories) hour to display query results.

Please suggest the solution

Thanks in advance

Sri.