Archive
Posts Tagged ‘MDX’
Get a comma separated list in SQL & MDX.
June 6, 2012
Leave a comment
To get a comma separated list in SQL as well as in MDX use below queries.
Categories: Business Intelligence
comma seprated, MDX, sql, ssas
SQL+MDX in one Apartment (Hybrid Query).
May 23, 2012
3 comments
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…
Categories: Business Intelligence, MDX, SQL, SSAS
hybrid query, MDX, ssas
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…
Categories: Business Intelligence, Excel
excel, excel mdx, MDX