Difference between revisions of "SQL Server Analysis Services"

From Richard's Wiki
Jump to: navigation, search
(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];