Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : X6c25peDibwKfylxgN7AgP

Financial Reporting DataMart reset self-service

M.Aamer Profile Picture M.Aamer

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:

 

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

Microsoft Dynamics 365 for Finance and Operations

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

Microsoft Dynamics 365 for Finance and Operations

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

A confirmation message will open

Microsoft Dynamics 365 for Finance and Operations

Microsoft Dynamics 365 for Finance and Operations

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Then integration status will popup

Microsoft Dynamics 365 for Finance and Operations

Microsoft Dynamics 365 for Finance and Operations

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The integration will be completed for all items.

Microsoft Dynamics 365 for Finance and Operations

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

Microsoft Dynamics 365 for Finance and Operations


This was originally posted here.

Comments

*This post is locked for comments