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.