Views:

Checklist before you proceed to rebuild Management Reporter DataMart:

  • To rebuild DataMart, you will first need to check what credentials are being used for Microsoft Dynamics and DataMart connections. These credentials will be used to connect to DYNAMICS and DataMart databases.
  • Make sure you have admin rights to Management Reporter server i.e. where Management Reporters services are hosted. When in doubt, have your domain administrator perform these tasks.
  • You will also need sufficient access rights on SQL to backup and delete a database via SQL Server Management Studio.
  • Make sure you are an admin user in SQL and a user in Management Reporter when performing these tasks.  In the ManagementReporter db, you can check the reporting.securityuser table to confirm what users are setup in MR or go into the report designer, security, and confirm you are logged into the server as one of the administrator users.

Note: Depending on the size of your databases and the number of Microsoft Dynamics companies you have, it may take up to several hours for DataMart to complete its initial refresh after a rebuild. Please allow ample time before generating reports. You can check the progress in Configuration Console >> ERP Integrations >> DataMart integration. When completed, you should see Last time everything was fully integrated: <recent timestamp>.

blog-rebuilding-datamart-management-reporter-2012-5.jpg
Once all the items in the above list are sorted out, follow the below instructions to rebuild DataMart.

  • Open the Management Reporter Configuration Console on the server where MR is installed.
  • Select the Microsoft Dynamics SL to DDM integration under ERP integrations.

blog-rebuilding-datamart-management-reporter-2012-1.jpg

  • Click the Disable Integration button.
  • Click Remove in the upper-right corner to get rid of the integration.
  • Stop the Management Reporter 2012 Process Service.
  • Stop the Management Reporter 2012 Application Service.
  • Open SQL Server Management Studio
  • Backup the Datamart or DM database.
  • Take note of the Datamart databases name and delete the database (Note: You must delete the database. Renaming the database may cause errors).
  • Go back to the Configuration Console.

blog-rebuilding-datamart-management-reporter-2012-2.jpg

  • Start the Management Reporter 2012 Application Service.
  • Start the Management Reporter 2012 Process Service.
  • Go to File >> Configure

  • Choose “Add Microsoft Dynamics SL DataMart” and click Next.



Click Next on this Window

  • Enter your SL database SQL server name and check use windows authentication. Select your system db from the Database drop-down menu.
  • Enter your SQL Server name again, check use windows authentication and make sure the name on the bottom is the same name as the datamart database you deleted.
  • Click Next, then click Configure.
  • When finished, be sure to click the “Enable Integration” button in the Configuration Console if it was not automatically enabled.
  • Let the process run until it says process complete, periodic updates will occur.
  • Then the users can try reports.

 

Keywords: rebuild,management reporter,MR,datamart,dm