Subject: Refreshing the Management Reporter Data Mart from Windows PowerShell Using "Reset-DatamartIntegration "
REBUILD Management Reporter Datamart from Powershell:
1. Backup The ManagementReporter and Data Mart (ManagementReporterDM – default name – might be different) databases.
2. Log onto the server where the MR Server components are installed and open Powershell as Administrator.
3. Navigate to the Console folder C:\> cd ‘.\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Console\’
4. Import the module by typing: Import-Module ‘.\Microsoft.Dynamics.Performance.Deployment.Commands.Integration.dll’ at the prompt.
5. Modify the command. Note: Replace the SERVERNAME. SQLADMINUSER and PASSWORD for each section of the command below:
C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Console>
Reset-DatamartIntegration -Reason BADDATA -ReasonDetail “Restored database from backup” -DatamartDatabaseServer SERVERNAME -DatamartDatabaseName ManagementReporterDM -DatamartDatabaseUserName SQLADMINUSER -DatamartDatabaseUserPassword (ConvertTo-SecureString PASSWORD -AsPlainText -Force) -MRDatabaseServer SERVERNAME -MRDatabaseName ManagementReporter -MRDatabaseUserName SQLADMINUSER -MRDatabaseUserPassword (ConvertTo-SecureString PASSWORD -AsPlainText -Force)
6. The program will give you the following warning. Answer Yes by typing "Y". The DataMart refresh has executed. When the process starts, the Configuration Console will display a message that the initial integration is in progress. Once complete, you will see the message change to initial integration is complete.
Vincent Stefanetti
Senior Consultant