Difference between revisions of "SQL Server Analysis Services"

Latest revision as of 19: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"

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];

@@ Line 1: / Line 1: @@
 * [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 ===