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:- 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.