SQL Server Analysis Services
From Richard's Wiki
- 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];
