Rebuilding the Data Mart is usually a good starting point when looking into Management Reporter issues such as missing data, differences between Dynamics GP and Management Reporter (MR), restoring building blocks, etc.
Backup SQL Database
Rebuilding the Data Mart can be a lengthy process and requires everyone to be offline.
- Close all instances of Management Reporter
- Open SQL and take a backup of the database called ManagementReporterDM
*if your backup is erroring out, open the Configuration Console, stop the application and process service and try the backup again, once the backup is done, return to the Configuration Console and start the services.
- Open the Management Reporter Configuration Console
*if you cannot find the program, do a search for “Configuration Console” in all programs, or the executable file can typically be found using the path below:
C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Console\MRConfigurationConsole.exe
- On the left hand side open the ERP Integrations and click on your database connection
- Click Disable Integration (this may take a moment)
- Then, on the top right-hand corner click Remove which will remove the integration
- On the top left-hand side click Management Reporter Services and stop all services by clicking Stop under both Application Service and Process Service
*Notice that your database connection no longer appears under ERP integrations
- Delete the ManagementReporterDM database from SQL by right clicking on the database and selecting Delete
- On the Delete Object window unmark the Delete backup and restore history information for databases and click OK
Rebuild Data Mart
- In the Configuration Console start the Application and Process services
*Upon opening the configuration console you may come across the following message, this is just a prompt telling you to start services
- Click File then select Configure, this will open the Configure Management Reporter window
- Select Add Microsoft Dynamics GP Data Mart option and click Next
- Under Dynamics GP Connection Information: Enter the login credentials for GP and select DYNAMICS as the database
Under Data Mart Connection Information: Enter the login credentials for GP and make sure the database says ManagementReporterDM
- If everything is entered correctly you will receive the following window, click Configure, this may take a few minutes
- When you get the check-mark, this phase is complete and you can close the window
14. Back in the Configuration Console select the integration and click Enable Integration
*the integration can take between 5-10 minutes or up to a few hours
To monitor the progress, run the following query in SQL against the ManagementReporter database:
Once this is completed and all state types are shown as Complete in SQL you’ve successfully rebuilt the Management Reporter Data Mart. User can now log back in and run their reports.
What is new in Dynamics GP 2018?
Get 9 premium pieces of content that will help you plan a Dynamics GP upgrade!Get The Upgrade Guide