Search code examples
.netsql-servermdxadomd.net

MDX query builder implementation

I'm using Microsoft.AnalysisServices.AdomdClient to query a cube. I have a Multidimensional Expressions (MDX) query that I pass to the AdomdCommand object to query my cube. I would like to have a MDX builder class that I could use to pass a list of Measures, Dimensions, Levels, etc and generate a string of the corresponding MDX query.

Does this already exist?

Solution

  • That's a good start for: http://www.c-sharpcorner.com/UploadFile/akrishnaraj/MdxQueryBuilder12052005041819AM/MdxQueryBuilder.aspx

    If open source code is an alternative for you, then this library contains a MDX generator included: http://code.google.com/p/ranet-uilibrary-olap/