Hi Gurus,
The analysis services service is stopping unexpectedly when I try to run a "any by any" report. It is also taking way longer to run the report. I could not figure out what the issue is but things have come to a stand still for us because of this error. I really appreciate any help asap. Here is the error message from the event logs on the SQL Server.
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7034
Date: 5/18/2010
Time: 9:58:38 AM
User: N/A
Computer: SQLSERVER
Description: The SQL Server Analysis Services (MSSQLSERVER) service terminated unexpectedly. It has done this 1 time(s).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
We are using SAP BPC 7.0 with SP07, SQL Server 2008, two server architecture.
Thanks.