Difference between revisions of "SQL Server Analysis Services"
From Richard's Wiki
(→MDX) |
|||
| Line 2: | Line 2: | ||
=== MDX === | === 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]; | ||
| + | |||
| + | |||
* [http://msdn.microsoft.com/en-us/library/ms146084.aspx SQL Server books online FORMAT_STRING Contents (MDX)] | * [http://msdn.microsoft.com/en-us/library/ms146084.aspx SQL Server books online FORMAT_STRING Contents (MDX)] | ||
* Percentile calculations: | * Percentile calculations: | ||
** [http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/76745b13-73a5-4371-bd5e-b7e825ca52ae http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/76745b13-73a5-4371-bd5e-b7e825ca52ae] | ** [http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/76745b13-73a5-4371-bd5e-b7e825ca52ae http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/76745b13-73a5-4371-bd5e-b7e825ca52ae] | ||
** [http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/b15531de-cc91-4ba6-88d7-ffd8c273f530 http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/b15531de-cc91-4ba6-88d7-ffd8c273f530] | ** [http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/b15531de-cc91-4ba6-88d7-ffd8c273f530 http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/b15531de-cc91-4ba6-88d7-ffd8c273f530] | ||
Revision as of 21:05, 1 December 2010
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];
