We have a cube which contains tons of data. To improve the performance we created a new multiprovider and now we are repalcing the old query(A) with new query(B) which is built on the multiprovider.
Now my question is when we are running the query we are seeing total time of B is more than the total time of A.
the query is using virtual keyfigures. We are running compression on the new cube in multiprovider.
Does it make any diff? Last week it was ok but this week this behaving diffrently..
The new query(B) is taking more time on OLAP than Old query(B)?
Why it is behaving so?
Any help will be really appreciated.