An error has occurred while establishing a connection to the analysis server.

Hi All,### I have Installed RoleCenter and when given the user profile for same profile to all companies Selected CEO.

Then Refresh the AX 2009 the error is

Financial KPIs

An error has occurred while establishing a connection to the analysis server.

Well, you don’t have Analysis Services installed on the server… (extension from SQL server pack). After you install it, you have to deploy it in AX.

Actually I cannot say for sure that you don’t have Analysis Services installed on your server, but it is definitely at least not configured properly.

This information will be helpful:

Hi Gajendiran,

For some reason, I cannot see your screen shot clearly.

Have you followed the instructions in Installation guide and configured analysis extensions correctly?

Thanks Janis,

I have installed all the services and now got this error:

An unexpected error occurred while processing the business overview webpart. Check the web server application event log for more information.]
check the event log :

In Event log:

An unexpected error has occurred.

[The dimension ‘[Company]’ was not found in the cube when the string, [Company].[Company accounts].&[ceu], was parsed.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteMultidimensional(ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteCellSet()
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.WebParts.CubeHelper.GetCurrencyCodeCompany(String company, AdomdConnection conn)
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.WebParts.BusinessOverviewWebPart.CreateMainTable()
at Microsoft.Dynamics.Framework.Portal.UI.WebControls.WebParts.BusinessOverviewWebPart.RaiseCallbackEvent(String eventArgument)]