Hi,

Could you please let me know ssas cube limitaions.

In my db we have 80 gigs data.so we need to create cube.

does it support  mdx performance better?

or give me some other tools for giving better perfor

Hi S,

Query performance of a cube is typically much faster than a SQL query that has to aggregate data.

Having said that, I might add that performance is more of a function of your cube design than the volume of data you have in your database.

So, if you are new to OLAP, keep your design flexible (only write disposable reports) until you have trialed various designs and you are sure that you have a good design for your needs.

Hope that helps,