August 20, 2011
by Rick

Using Dapper with MDX

At my company we were beginning to use MVC for our next generation web platform reporting. In the recent past we began using Microsoft SQL Server Analysis Services for our aggregation needs. Prior to MVC, we were doing custom ASP.Net WebForms applications. I had written a data object using ADOMD to retrieve the data from our cube and serve it up for reporting. Through many trials, we had to utilize the LoadXML feature of ADOMD instead of the CellSet. This offered us much more speed in execution but we lost some of the features of being able to walk up and down the dimensions. Continue reading