Dynamics Financial Reporting

All about financial reporting and consolidations for Microsoft Dynamics ERPs

Financial Reporting Data Mart for Dynamics SL – Management Reporter RU4

Financial Reporting Data Mart for Dynamics SL – Management Reporter RU4

  • Comments 4

With the success of the data mart we offer for AX 2012, Dynamics NAV, and Dynamics GP customers, we are now excited to offer it to Dynamics SL 2011 customers using Management Reporter. The option will appear in the Custom Configuration as shown in the following screen shot.

  

 

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 is a link to a Management Reporter blog that answers frequently asked questions on the data mart.

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

  • Company integration – companies are imported into the data mart when they are created in Dynamics SL. 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.
  • Ability to report on inactive companies – the data mart allows users to report on companies that are no longer being used for transactional posting, but are still needed for historical reporting.

For existing Dynamics SL Management Reporter customers, there is a change to Dimension Names with the data mart. Dimensions are named differently and require updates to the row, column, and reporting tree definitions.  For example, in the SL legacy provider the main account was ‘Natural’, in the data mart is titled ‘Account’. Customer Support has a diagnostic tool to assist with this change. Please contact Support for assistance with synchronizing the dimension names in your Management Reporter 2012 reports with your Dynamics SL data mart database. 

We encourage all users to adopt the data mart and take advantage of the capabilities as it is the current and only future architecture that will be supported. We hope you are excited about the offering of the data mart for Dynamics SL.

 

 

 

Leave a Comment
  • Please add 6 and 6 and type the answer here:
  • Post
  • Is there any documentation on the SL Datamart?  How does it work exactly and how often is the data refreshed?  How much overhead does it placed on live posting, etc.?  Thanks.

  • There is installation documentation for the datamart. I believe this blog will help with some of your other questions:  blogs.msdn.com/.../financial-reporting-data-mart-for-dynamics-gp-management-reporter-ru3-release-preview.aspx

  • In SL, MR Data Mart checks for track changes every 5min and once an hour it updates DDM DB to reflect those changes. I would like to increase frequency of the  trickle method, anyone know how to do that for SL?

  • Alistair,

    The transactions should be running every 45 seconds but we did just find that the SL data mart is set differently and updating about every 5 minutes instead. Thank you for bringing this to our attention. We will look at updating for a future release. In the mean time, support may be able to assist with the changes.

Page 1 of 1 (4 items)