Excel pivot table is a great tool to create pivot charts easily and quickly, however it does not have a OOB button to view the mdx query. But thankfully there are many tools available to help us here.
http://sqlblog.com/blogs/marco_russo/archive/2007/01/18/display-the-mdx-query-of-an-excel-2007-pivottable.aspx
http://olappivottableextend.codeplex.com/
http://webpivottable.com/
The posts below mention some of them.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7c2927c8-0e4a-4658-a3d4-55691a613471/how-to-view-mdx-query-in-excel-sheet?forum=sqlanalysisservices
http://stackoverflow.com/questions/2863436/how-can-i-display-the-mdx-generated-by-excel-2007-when-using-a-pivot-table
http://sqlblog.com/blogs/marco_russo/archive/2007/01/18/display-the-mdx-query-of-an-excel-2007-pivottable.aspx
http://olappivottableextend.codeplex.com/
http://webpivottable.com/
The posts below mention some of them.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7c2927c8-0e4a-4658-a3d4-55691a613471/how-to-view-mdx-query-in-excel-sheet?forum=sqlanalysisservices
http://stackoverflow.com/questions/2863436/how-can-i-display-the-mdx-generated-by-excel-2007-when-using-a-pivot-table
No comments:
Post a Comment