We have a Cube which is to be queried by the Online system , using WCF service. Peroformance of the queries running on the Cube is not really very good , as we have to calculate various percentile (which are all calculated members) on the cube, this
howver works well within limits of 5-6 secs for small sample size. But this goes beyond the threshold of 30 secs when the record counts increases.
What we have is our SSAS Cubes , and we have WCF Service querying the Cube using ADOMD.NET.
This may not be one of the best way to achieve this requirement , but we are kind of completed with development and it may not be feasible to work on another approach, what we are looking for is optimize this design and make it work with in expected time
limits of 5-8 secs.
Kindly let me know, if i am not clear or if you need any more info to suggest something !
Thanks a lot for your help !
View Complete Post