Management Reporter 2012 – Reset Data Mart for Dynamics AX

by | Updated August 15, 2016 | Dynamics AX, Management Reporter, Set Up

Management Reporter 2012 utilizes two databases. One of these databases stores report metadata, user information and other application information. Management Reporter also uses a data mart database which stores financial information in a format optimized for financial statement reporting. At times the data in this data mart database can get out of sync and need to be reset.  At this point there is not an option to reset this data through the application. Instead, we need to reset the data mart which involves recreating the data mart database and setting up the integration to Dynamics AX again from the MR Configuration Console.

Summary of steps to reset the data mart database:

  1. Remove integration to AX
  2. Stop the Management Reporter service
  3. Delete the data mart database
  4. Start the Management Reporter services
  5. Use the Management Reporter configuration utility to create the data mart database
  6. Enable the integration

Detailed steps to reset the data mart database:

1. Remove integration to AX

a. Log on to the Management Reporter server

i. Must use an account that is an MR Admin and an admin on the server.

1. Account needs the following access

a. Local administrator on the server

b. Sysadmin or user within SQL with rights to create the database

c. System Admin user role within AX

d. Security Admin user role within AX

b. Start the Management Reporter Configuration Console

i. Click Start and type in Configuration Console

 Apps for configuration

c. Click on the current integration in the Navigation Pane (left side)

d. Note the name of the Management Reporter data mart database (top blue header)

i. In screenshot below:  ManagementReporterDM

e. Click to Disable the integration

f. Remove the integration

g. Management Reporter 2012

2. Stop the Management Reporter services

a. Click on the Management Reporter Services in the navigation pane (top left)

b. Click STOP on both the Application and Process services

i. Management Reporter Services

3. Delete the data mart database

a. Open SQL Server Management Studio

b. Right click on the data mart database and choose Delete.

i. Database name noted in step 1-d. above.

c. Management Reporter 2012

d. Reset Data Mart for Dynamics AX

4. Start the Management Reporter services

a. Go back to the Configuration Console for Management Reporter

b. Click on the Management Reporter Services in the navigation pane (top left)

c. Click START on both the Application and Process services

d. Management Reporter Services

5. Configure the data mart

a. From the Configuration Console navigate to File / Configure

i. Select Add Microsoft Dynamics AX 2012 Data Mart

ii.  Configure Management Reporter

iii. Click NEXT at the bottom

iv. Complete the two sections to deploy the data mart

1. Enter required information as shown below

2. Dynamics AX Connection Info

3. Click Next at the bottom

4. Click Configure

a. If errors view Deployment Log

i. C:\ProgramData\Microsoft Dynamics ERP\Management Reporter\Logs\….

6. Enable the integration

a. Click to expand ERP Integrations on the Navigation Pane

i. Click on the ERP integration that was just created

b. Click Enable Integration

i.  Integration may take several minutes to transfer all needed financial information from AX to the newly created data mart database.

c. Management Reporter 2012

d. Once complete the Status shows “Initial integration is complete. Periodic integrations will occur”

e. Management Reporter 2012

7. Complete.

Users can now run reports.

Related Posts

6 Comments

  1. Kristin

    Hi Craig,

    Beautiful instructions … thanks!!

    Just curious if you know of a way to monitor for the synchronization of the data mart? Instead of relying on someone reporting that it doesn’t seem correct, I’d like to be able to identify when there are synchronization issues.

  2. Brandon Carmichael

    Hi Kristin:

    I don’t believe there is a current tool for monitoring the synchronization status of the data mart. Your Management Reporter data mart should not get out of sync frequently. Here are a few scenarios which would cause a Data Mart reset to be completed. If your data mart is out of sync more frequently we’d want to troubleshoot further to determine the cause and/or possibly open a technical support incident with Microsoft Support.

    1. You refresh a copy of your AX database (such as copying Production down to a test environment and you use Management Reporter in this TEST environment).
    2. Your Management Reporter integration is stopped for more than 3 days. The SQL Server default setting is to retain Change Tracking data for 3 days. This can be modified in SQL but otherwise, anything over 3 days would require a data mart reset.
    3. You restore a copy of your Production AX database.

  3. Sunday Otaiku

    Hello

    I would like a step by step guide on uninstalling Management Reporter 2012…

    Really need help on this..

  4. Brandon Carmichael

    Hello Sunday:

    To uninstall individual Management Reporter 2012 components or integrations, complete the following procedure:
    1. Open the Management Reporter configuration console.
    2. To remove the application service or process service, select the service under the Management Reporter Services node in the navigation pane. Click Remove.
    3. To delete an integration, select the integration to remove under ERP Integrations. Click Remove.
    4. To delete a company that has been integrated, open Report Designer. On the Companies menu, click Companies. In the Companies dialog box, select the company to delete, and then click Delete.
    5. To uninstall all Management Reporter components, but leave data mart integrations in the Management Reporter Database, open Add/Remove Programs, and then remove Microsoft Dynamics ERP Management Reporter 2012 Server.

  5. Ahmed Essam

    What about deployment error ??
    i tracked the path off log file but i don’t found it !

    What can i do to solve this error ?

  6. Michael Tweiten

    Hi Ahmed,

    The deployment log will list out any errors encountered while deploying the Management Reporter data mart. Can you be more specific as to what you are not finding? Does this file path exist on your environment or are you just not finding errors in your deployment log?

    Regards,
    Michael

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

march

03mar10:00 am10:30 amThe Modern Manufacturer - MRP vs. MPS – What, When and How

03mar2:00 pm2:30 pmLot Management Best Practices for Batch Manufacturers

10mar10:00 am10:30 amEnhancing the Customer Experience and Driving More Business with Dynamics 365 Customer Service

10mar2:00 pm2:30 pmThe Five Steps to Managing Sales Tax

11mar11:00 am12:00 pmConfab with Stoneridge - Livestream - Power Apps Component Framework Power Hour

17mar10:00 am10:30 amThe Modern Manufacturer: Pro Tips for your Finance Team

24mar10:00 am10:30 amUnlock the Potential of Digital Marketing with Dynamics 365 Marketing

25mar11:00 am12:00 pmConfab with Stoneridge - Livestream - The Four Keys to Choosing the Best ERP or CRM Solution

31mar10:00 am10:30 amThe Modern Manufacturer: Keys to Reporting Success

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

april

31mar01aprTraining Class: Financial Reporting W/Account Schedules for Dynamics 365 Business Central

07apr10:00 am10:30 amBoost Seller Productivity and Close More Business with Dynamics 365 Sales

07apr2:00 pm2:30 pmEnsuring Quality for Batch Manufacturers

08apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Jumping into the Deep End of the Data Lake

14apr10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

21apr12:00 pm1:00 pmGetting Started with Barcode Scanners and WMS Apps for Business Central

22apr11:00 am12:00 pmConfab with Stoneridge - Livestream - Moving from Manual to Automated with Strategic Automation Strategies

28apr10:00 am10:30 amThe Modern Manufacturer: Best Practices for Inventory Turn

28apr12:00 pm1:00 pmPower Up Microsoft Dynamics by Automating Budgeting, Dashboarding and Reporting

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X