Difference between revisions of "SQL Server Analysis Services"
From Richard's Wiki
(New page: * [http://www.ssas-info.com/analysis-services-articles SQL Server Analysis Services 2005/2008 Articles]) |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
* [http://www.ssas-info.com/analysis-services-articles SQL Server Analysis Services 2005/2008 Articles] | * [http://www.ssas-info.com/analysis-services-articles SQL Server Analysis Services 2005/2008 Articles] | ||
| + | * If you create a Realtime ROLAP dimension in an SSAS cube, and get an error about "OLE DB Error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000.", you need to grant ALTER TRACE permission on the SQL Server database that is being accessed by analysis services, for the account that SSAS is running under. So for example if SSAS is running as NT AUTHORITY\NETWORK SERVICE, do the following SQL command against the master database of the SQL Server source server of the cube: | ||
| + | GRANT ALTER TRACE to "NT AUTHORITY\NETWORK SERVICE" | ||
| + | |||
| + | === 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)] | ||
| + | * 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/b15531de-cc91-4ba6-88d7-ffd8c273f530 http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/b15531de-cc91-4ba6-88d7-ffd8c273f530] | ||
Latest revision as of 20:52, 5 December 2010
- SQL Server Analysis Services 2005/2008 Articles
- If you create a Realtime ROLAP dimension in an SSAS cube, and get an error about "OLE DB Error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000.", you need to grant ALTER TRACE permission on the SQL Server database that is being accessed by analysis services, for the account that SSAS is running under. So for example if SSAS is running as NT AUTHORITY\NETWORK SERVICE, do the following SQL command against the master database of the SQL Server source server of the cube:
GRANT ALTER TRACE to "NT AUTHORITY\NETWORK SERVICE"
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];
