SSAS Tabular, Telerik, Multi-Value Parameters with DAX
Earlier this summer, I started working with a new client to develop the next version of their reporting platform. This client already had the reporting requirements and good jump start on the underlying data model but had run into some serious performance issues when trying to report directly from the relational data model using stored procedures. After some discussion about the requirements (e.g. types of reports, calculations, granularity, data size, security) it was quite clear that Analysis Services in tabular mode was a very good fit. In just over a week, we were able to build out a prototype that accomplished all of the requirements (including a dramatic increase in performance). Following the engagement the client has decided to move forward with SSAS tabular as the engine behind their new reporting platform.
Read more...