I am using Excel 2007 and SSAS 2005. I have an excel report that is done by pivot tables, accesing my SSAS cube. Is it possible to view and edit the MDX query for the report? Can I pass parameters to MDX query? If so how?
You can use vba to extract the MDX query from a pivot table, but I do not believe there is anyway to change it. I have not tried this in 2007, but you could not in Excel 2003 and I have not heard anything to make me believe otherwise.|||Here's a blog post from Marco Russo that provides the code for doing this.
http://sqljunkies.com/WebLog/sqlbi/archive/2007/01/18/26875.aspx
No comments:
Post a Comment