Business Analytics

I am implementing BA on one database in NAV 2009 SP1 using MS SQL Server 2008 R2 Standard Edition. All the processes of BA has been completed successfully but I get following errors:

1. Data which I have configured from Analysis Services to Excel 2007 doesnot get refreshed. It only shows data which was present when cubes were created.

2. I always get error at last step of configuring BA Advanced with Basic. After that process ‘ANTServer’ stops restarting or sometimes system gets stuck at ‘Configure Security’. I used to access ‘ANTServer’ using Local System and I have tried ‘ANTServer’ with .\BAUSR also but still having same error.

Can anyone help me???

Thanx in advance…5078.untitled.bmp (595 KB) [:)]


Do one thing u just reinstall your BA setup and confirm that u already install analysis service in your SQL 2008.