Lamprey3,

Thanks for your reply.

Sharding is a $2.50 word for distributing data into multiple databases based upon some sort of logic that improves reporting performance.

I have been researching SSAS recently and I like the product very much. I want to offer my users some carefully-controlled, ad-hoc reporting capability and I am thinking SSAS can help a lot.

I don't want to fail to make SSAS part of our final, reporting platorm simply because the contractor was not familar with SSAS or wants to be called every time we need new output.

WDT3