Resetting the Management Reporter data mart for Dynamics 365 for Operations

If you need to reset the Management Reporter data mart for Dynamics 365 for Operations, you can use the steps listed below. These steps are for a sandbox/UAT environment. If you need to reset the data mart in your production environment, contact support.

To rebuild the data mart using the steps found here:

https://mix.office.com/watch/36g9prxvg885

The basic steps are as follows:

1. Run PowerShell as Administrator.
2. Browse to .\MRInstallDirectory.

   For a demo or DEV deployment, this will typically be J:\MROneBox\MRInstallDirectory

   For Production or HA deployments, this will typically be J:\MRProcessService\MRInstallDirectory for the BI machine and F:\MRApplicationService\MRInstallDirectory for the AOS.

3. In the PowerShell window type the following command to import the MRDeploy.psd1 module: Import-Module .\Server\MRDeploy\MRDeploy.psd1
4. You can then run the following command to reset the data mart:

   Reset-DatamartIntegration -Reason OTHER -ReasonDetail “Testing reset”
   

5. Stop MR Process Service.
6. Answer Yes when prompted in PowerShell to continue.
7. Start MR Process Service.