Share via

Financial Reporting Data Mart - Management Reporter 2012 Feature Highlight

  • Article

Management Reporter 2012 is introducing architectural changes that will positively impact Dynamics AX 2012 and NAV customers. Existing Dynamics AX 2012 customers will have the option to choose either the traditional provider method currently released, or the new data mart as their data provider.

This feature will use 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.

This blog covers some of the most common questions you may have about this new Management Reporter option.

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 integration enhancements do I benefit from this new technology?

A. First off, when you set up the system, you eliminate dual company setup. Management Reporter reads the company description and name from Microsoft Dynamics. Second, you will have the ability to drill back to actual and budget data. Dynamics AX 2012 customers also receive additional integration points that are not available in the current release. Stay tuned for additional blogs on budget reservations, user and role integration, and organization hierarchies!

Q. Should I be nervous that this is a new technology?

A. It’s not new! The technology has been in use with Dynamics Connector - integrating Microsoft CRM and Dynamics for 2 ½ years. The existing technology is being introduced to Management Reporter to take advantage of the many benefits it offers.

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 transaction map 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!

Q. Will I see faster report generation wit this data mart?

A. Yes, although each report and environment is unique, the data mart is optimized for financial reporting. So, based upon proper report design, you should see a faster, more seamless report generation time.

By now, we hope you are excited as we are about this new offering for Management Reporter 2012. Closer to release, check out our Management Reporter for Microsoft Dynamics ERP Installs and Service Packs Overview page for links to the installation documentation.

Comments

  • Anonymous
    February 01, 2012
    Maybe I missed it above, but will this feature be available for Dynamics GP?

  • Anonymous
    February 02, 2012
    Steve, Offering a data mart is on our roadmap, but for this initial release, we'll just support Dynamics AX 2012 and Dynamics NAV Thanks for the inquiry

  • Anonymous
    February 06, 2012
    Will New Customers of AX have a choice or only existing customer of MR?

  • Anonymous
    February 06, 2012
    Customers will have the choice, but I think when they see the many options and benefits, most will go with the new architecture.

  • Anonymous
    May 08, 2012
    I second the motion for GP.  

  • Anonymous
    May 21, 2012
    Please vote here for the GP Data Mart.. connect.microsoft.com/.../add-the-data-mart-option-for-dynamics-gp-into-management-reporter

  • Anonymous
    September 13, 2012
    Once I've installed Management Reporter how can I go back and make adjustments to the data mart configuration, such as how often the integration runs?

  • Anonymous
    September 13, 2012
    Lee, Support should be able to assist you with the time of the mappings.

  • Anonymous
    March 20, 2013
    The comment has been removed

  • Anonymous
    March 25, 2013
    Using the data mart, customers are seeing faster report generation.

  • Anonymous
    June 17, 2015
    Is there any way to customize the data mart for MR? Reason: There are few custom fields in GL transaction tables that need to be reported on. Any comments on this is appreciated.

  • Anonymous
    August 24, 2015
    Hi, where is the Delete option to delete Dynamics GP Companies from Management Reporter?