Financial Reporting DataMart reset self-service

In some occasions you may need to reset the Financial Reporting DataMart. There are basic two options to reset the DataMart on your environment.

• SQL Script
• PowerShell Script

If you need to reset the DataMart on production this was done through support request, and then the resetting process done by Dynamics Service Engineers. Recently Microsoft introduced a self-service approach to reset the DataMart on your own through Financial Reporting Designer, this this blog post I’d like to walk through the entire process.

First of all you must upgrade:

• If you are on Dynamics 365 for Finance and Operations 7.2 – Go to LCS and deploy the following Binary update Microsoft Dynamics 365 for Finance and Operations Financial Reporting 7.2 Update 3
• If you are on Dynamics 365 for Finance and Operations 7.1 – Go to LCS and deploy the following binary update
  Enable Microsoft Dynamics 365 for Finance and Operations Financial Reporting 7.2 Update 3

Open Financial Reporting Designer then go to Tools| Reset Data Mart

Microsoft Dynamics 365 for Finance and Operations

Reset DataMart dialogue will popup, mark Reset DataMart check box, then OK button will be activated.

Microsoft Dynamics 365 for Finance and Operations

A confirmation message will open

Microsoft Dynamics 365 for Finance and Operations

Then integration status will popup

Microsoft Dynamics 365 for Finance and Operations

The integration will be completed for all items.

Microsoft Dynamics 365 for Finance and Operations

Also you can check integration status by navigating to Tools| Integration status.

Microsoft Dynamics 365 for Finance and Operations