The Accounts Payable cube cube either does not exist or has not been processed.

The Accounts Payable cube cube either does not exist or has not been processed.

Solution:

This error is raised when I run the report top vendors by YTD purchase.

The issue can be the cubes are not properly processed. Verify the cubes or reprocess the cubes from SQL.

The issue here is while deploying and processing the cubes from the Dynamics AX 2012

(Tools > Business Intelligence tools > SQL server analysis Project wizard)

Cubes are not processing completely and generating error

“MdxScript(Sales cube) (21, 18) The '[Commission line amount - accounting currency]' member was not found in the cube when the string, [Measures].[Commission line amount - accounting currency], was parsed.

Errors occurred while processing the Analysis Services database: Dynamics AX initial”

and stop further process.

In my case, we have upgraded from AX 2012 to AX 2012 R3. So cubes are not processing due some issue may be due customizations.

Take Backup of the objects before applying any steps.

Delete the customization in “Dynamics AX” project or “Dynamics AX” Analysis project, which will restore it to sys layer. (AOT > Visual studio projects > Analysis service projects) and try to redeploy from tools mention above.

This require the MS SQL Analysis service installed and configured.

This steps resolve my issue. ☺

No Such host is known

No Such host is known Error Dynamics AX

I got the above error in Microsoft Dynamics AX 2012 while resolving the errors for running SSRS reports which uses DynamicsAXOLAP data source which is Analysis service database.

There is separate database for the Analysis reports for few SSRS reports in Microsoft Dynamics AX, which has to be installed in SQL Analysis service SSAS. which will process the data in the default deployed cubes and get the data from there.

I identified the problem which was as a result in changing the AOS. The original AOS was uninstalled and replaced with a new one, but the old values remained in the registry. As a solution, we changed some values on the registry :

Follow the link below which resolved my issue to the anext steps.

https://nairobiaxusergroup.wordpress.com/2014/04/02/error-running-report-in-ax-2012-no-such-host-is-known/comment-page-1/

MSB4018: The "CompileModel" task failed unexpectedly.

MSB4018: The "CompileModel" task failed unexpectedly.

System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.

  at System.Xml.XmlTextReaderImpl.Throw(Exception e)

  at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)

The above error raised in few SSRS reports which has the DyanmicsOLAP data source.

Solution:

Open the report in Visual studio and verify that the Datasource property is proper on the data set of the tables attached to report

In My case, the issue raised because the DynamicsOLAP data source is not available or not able to connect

Also, Verify that the on Microsoft Dynamics AX under System administrator menu, Analysis report server, the default server and data source is selected or configured properly.

Enable remote errors SSRS reports

For more information about this error navigate to the report server on the local server machine, or enable remote errors

The error above arise when SSRS report run from Microsoft Dynamics AX. To resolve this error follow the steps below.

Resolution

You need SQL server rights to follow below steps.

1. Go to SQL server management studio and connect the reporting servers.
2. Right click SQL server instance
3. Click on Advance. Change “Enable remote errors” to True.