Management Reporter 2012 – Reset Data Mart for Dynamics AX

By Craig Conzemius | October 28, 2015

Management reporter 2012 – reset data mart for dynamics ax

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

Recommended Reading:

5.25.22 Financials

Rounding Numbers in Power Automate

  If you’ve ever tried to round numbers in Power Automate, you have probably already run into the issue there […]

Read the Article

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!