Tuesday, July 19, 2016

Error when configuring Management Reporter 2012 for Dynamics AX 2012 R3

Problem:

You get error message when config MR 2012:

"An unexpected error occurred while querying the Metadata service"

System.ServiceModel.FaultException`1[Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012MetadataService.MetadataFault]: An exception of type MetdataException has occurred while performing the operation. (Fault Detail is equal to Microsoft.Dynamics.Performance.Deployment.DataProvider.AX.AX2012MetadataService.BatchFault).

Cause:
You add custom fields to table which is used as Financial Dimension.

e.g. You add custom fields to InventLocation, and use the table as Custom as Financial Dimension.


Solution:

Add relations to fields on the table.
Every additional fields on the table which is used to Financial Dimension must have relations.


Reference:
a. How to add table to be use on Financial Dimension:
https://dynamicsaxinsight.wordpress.com/2014/07/14/ax-2012-add-financial-dimension-for-your-table/

b. Another same problem
https://community.dynamics.com/ax/f/33/t/123925
 
Thank's to David Orr