SQL Server Analysis Services

From Richard's Wiki
Revision as of 20:05, 1 December 2010 by Rkdrm (Talk | contribs) (→‎MDX)

Jump to: navigation, search

MDX

  • Example MDX query:
SELECT
{
[Measures].[Reseller Sales Amount], [Measures].[Internet Sales Amount]
}
ON COLUMNS
,
NON EMPTY [Date].[Calendar Year].MEMBERS
ON ROWS
FROM [Sales]
WHERE
[Geography].[Country].&[United Kingdom];


Retrieved from "http://w.rkdrm.com/index.php?title=SQL_Server_Analysis_Services&oldid=653"