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/