Art Of Creation: Management Reporter and Dynamics AX 2012: Users not synchronizing

[Blog bot]

Источник: http://www.artofcreation.be/2018/03/...synchronizing/
==============

Today Management Reporter did not want to synchronize the users from Microsoft Dynamics AX 2012 to Management Reporter.

TLDR: make sure that you do not have unknown users with access to Management Reporter in your database. For example users from a different domain or users that have been deleted on active directory.

As you probably know, the users in Management Reporter are actually managed in Dynamics AX by using the role based security of Dynamics AX. The following table shows which roles in AX correspond to which roles in Management report (Source). So for example if you want to be administrator in MR, you need to be Security administrator in AX.

.tg {border-collapse:collapse;border-spacing:0;border-color:#ccc;border:none;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:0px;overflow:hidden;word-break:normal;border-color:#ccc;color:#333;background-color:#fff;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:0px;overflow:hidden;word-break:normal;border-color:#ccc;color:#333;background-color:#f0f0f0;}
.tg .tg-yw4l{vertical-align:top}
.tg .tg-b7b8{background-color:#f9f9f9;vertical-align:top}
AOT name Permission Microsoft Dynamics AX 2012 role Management Reporter role LedgerBalanceSheetDimMaintain Maintain financial statement setup Accounting manager
Accounting supervisor Designer LedgerFinancialJournalBGenerate Generate financial journal report Accountant
Accounting manager
Accounting supervisor
Chief executive officer
Chief financial officer
Compliance manager
Financial controller Generator LedgerBalanceSheetDimPrintGenerate Generate financial statement report Accountant
Accounting manager
Accounting supervisor
Chief executive officer
Chief financial officer
Compliance manager
Financial controller Generator SysSecSecurityMaintain Maintain security settings Security administrator Administrator LedgerViewFinancialStatement (privilege) Viewing financial statements Not applicable Viewer Once you have setup the security in AX, it can take up to 5 minutes for the users to show up in Management Reporter. The synchronization of the users is part of the AX 2012 Companies to company task that is executed by Management Reporter every 5 minutes. You can check if this task has run in the Management Reporter 2012 Configuration Console. Go To Logs > Data mart integration and search the log for AX 2012 Companies to company. If it has executed successfully, the users should show up in Management Reporter.

If on the other hand there are errors in the AX 2012 Companies to company task, users will not be synchronized correctly. In my case, I had restored a database from another domain and there were users in the database with roles that gave them access to Management Reporter. Disabling these users does not help, so you have to either remove them from the system or remove the role assignment that give the user access to Management Reporter.



Источник: http://www.artofcreation.be/2018/03/...synchronizing/