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:
The basic steps are as follows:
- Run PowerShell as Administrator.
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.
- In the PowerShell window type the following command to import the MRDeploy.psd1 module: Import-Module .\Server\MRDeploy\MRDeploy.psd1
You can then run the following command to reset the data mart:
Reset-DatamartIntegration -Reason OTHER -ReasonDetail “Testing reset”
- Stop MR Process Service.
- Answer Yes when prompted in PowerShell to continue.
- Start MR Process Service.