We are trying to use the "business overview" to view data (KPI's and indicators)on the AX role center from an existing SSAS cube (not of the 10 that comes with AX2009) and we have deployed the ODC file to this SSAS cube and is now trying to access data from the cube using the odc file and the "business overview" webpart - but are giving the error below: My question is now how can solve this and do we need to have any specific dimensions(and name and structure of these dimensions) to being able to use the webpart "business overview" without using the 10 std cubes that comes with ax2009...?
[The dimension '[Company]' was not found in the cube when the string, [Company].[Company accounts].&[ceu], was parsed.
Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException
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)]
*This post is locked for comments
I have the same question (0)
Syed Haris Shah
9
Martin Dráb
2
Most Valuable Professional
Community Member
2