Thursday, March 8, 2012

Caching (storing) calculated members in Analysis Services 2005

Do anybody know if Analysis Services 2005 allows cashing (storing) calculated members ?

There is a cube in Analysis Services 2000 with a calculated member based on some running sums. The performance of MDXs is too slow because running summs are being recalculated for each member of time dimension on each call.

I think that caching calculated members might help me and hope that this feature exists in Analysis Services 2005 .

Thanks!I don't think you can cache. But, you might want to ask Mosha.

http://www.mosha.com/msolap/

No comments:

Post a Comment