Mdx String generator.

Question

For Sql Server Analysis Services.

What im looking for is if anyone has example code of a class or function or a precompiled dll that you can pass columns, rows, pages, with filters etc. This then generates the mdx string.

im working in asp.net but should be able to convert from an example in any other language

Answer 1

I have not tried this myself yet, but I did recently become aware of this project which may be of use to you. http://code.google.com/p/ranet-uilibrary-olap/

Answer 2

you can use excel to query the database, and use sql-profiler to see the mdx used in the query sent to Analysis Services.

You can set filters in Excel to see how these are placed in the MDX query.