Financial Reporting Data Mart for Dynamics GP – Management Reporter RU3 release preview

Management Reporter 2012 introduced a data mart for Dynamics AX 2012 and Dynamics NAV customers. This technology has been widely adopted and successful and we are excited to now offer it to Dynamics GP 2010 customers. The option will appear in the Custom Configuration as shown in the following screen shot.

Figure 1: Dynamics GP Data Mart option

 Your first question may be what is a data mart and why would I want to consider it? The data mart uses the existing Management Reporter server and client to connect to a data mart that holds the necessary financial data needed for financial reporting. This data mart uses a trickle method to continuously move data from Dynamics to the data mart. Here are two of the most frequently asked questions answered for you.

Q. Why did the Management Reporter team offer a new technology?

A. For many reasons! First, it allows us to provide a database and technology that is optimized for financial reporting. Additionally, by using our own data mart, we are not taxing the Dynamics ERP system. Finally, it sets the system up for great integration enhancements.

Q. What is a trickle method? Should I expect to wait hours to see my financial data refresh?

A. No, the trickle method looks for new data based upon a schedule. For example, if you have a schedule that runs every 45 seconds, the data mart would be up to date after the new transactions move from the ERP to the data mart every 45 seconds. This is faster than it would take you to sign in, find the report you want and click Generate!

The primary benefits to Dynamics GP customers using the data mart will be:

  • Ability to report on Dynamics GP and Dynamics Analytical Accounting data with one company – this feature enhances the usability and reporting capabilities for those customers using Analytical Accounting. There is no need to have separate companies to get data, you simply design the report for the GP accounts, segments, or Analytical Accounting dimensions you want.
  • Company integration – the companies are imported into the data mart when they are created in Dynamics GP. You no longer need to manually set them up or import them.
  • Performance enhancements – the data mart is optimized for financial reporting. Although each report is designed uniquely and may vary, many reports may see performance improvements.

We encourage all users to adopt the data mart and take advantage of the capabilities. However, there are some reports where the legacy provider will be needed -- currency translation capabilities, Dynamics GP account level security and drill back to Dynamics GP.  You can use the data mart for reports where these situations are not required and use the legacy provider in parallel for just some of your reports. We are evaluating these three scenarios for future iterations of our data mart.

We hope you are excited about the offering of the data mart for Dynamics GP.

Comments (13)

  1. Just Curious says:

    What about a Data Mart for SL? Is that in the works?

  2. says:

    Will Analytical Accounting reports require the legacy provider?


  3. CharG says:

    The data mart will include Analytical Accounting data.

  4. Sounds like a good idea until I hit the "exceptions".  Does that mean that users have to switch between the data mart and go to the legacy version.  How does it work.  Is it something that I should consider before moving my users to this version especially in light of the fact that they are finally happy with the currency conversion working on dynamics reports.

  5. CharG says:

    For many users, the new data mart option will meet all their financial reporting needs, even when they use Analytical Accounting.  For some users, they may need to have the legacy provider working alongside the data mart for a few of their reports that require the specific capabilities noted.

  6. BudC says:

    Will current reports have to be rewritten to take advantage of the data mart?

  7. CharG says:

    Current reports will not need to be rewritten; a few reports may need slight tweaking.

  8. In your opinion are they setting this up for possible integration with the Forecaster Database if they choose to stay with Forecaster?

  9. Phil Rimmer says:

    Is there a limit to the number of AA dimensions?  I am having problems with a client install.  The data mart and the -AA company in legacy are both not working.  They do have over 60 AA dimensions so I thought this could be the problem.

  10. CharG says:


    There shouldn't be a limit to the number of dimensions. If you are still having issues, I would suggest contacting Microsoft Support


  11. Lyn Barr says:

    How do you view and/or alter the schedule for the Data Mart updates?  I mainly want to know how often my Data Mart is being updated, but I would also like to know how to change the schedule, should the need arise.


  12. CharG says:

    The data mart is updated every 45 seconds.

  13. Peter Hummel says:

    is there a guide somewhere to tell me how much disk space this data mart is going to take. Tried configuring it at a client and it failed at 150GB.

Skip to main content