Archive

Posts Tagged ‘MDX’

Get a comma separated list in SQL & MDX.

To get a comma separated list in SQL as well as in MDX use below queries.

SQL+MDX in one Apartment (Hybrid Query).

While replying on the MSDN Forums Most of the time people ask on how to write SQL+MDX both in single place means. Read more…

Display the MDX query of an Excel 2007 PivotTable

May 16, 2012 1 comment

Most of end users navigate into Microsoft SQL Server 2008/2005 Analysis Services Cube with the help of Microsoft Excel 2007. Sometimes they may produce report while browsing Cube data.

Most of them having curiosity about MDX (Multidimensional Expressions) generated by Excel in background. Here is the way to get that MDX out of Excel Sheet. Read more…

Advertisement
%d bloggers like this: