Saturday, February 25, 2012

MDX Query builder

Good day,

I would like to know if there are any good MDX query builder tools out there. The one that is shipped with AS does not suffice in that it does not support more than 2 axes. Also if there are any are there any that make life a little easier in that they are drag and drop and all but create the statement for you?

I need to create a matrix in SSRS using cubes and in doing so need to write MDX queries, not my strong point. Are there any tools that can help me "auto create" the statement with drag and drop functionality?

Thanks in advanceYou could use Excel 2007 and then use Maro Russo blog to build Excel macro that displays MDX:

http://www.ssas-info.com/component/option,com_bookmarks/Itemid,78/task,view/id,16/

Vidas Matelis
http://www.ssas-info.com

No comments:

Post a Comment