Welcome to the Dynamics GP Support and Services Blog. This new blog is designed to provide you the insights, knowledge and challenges that our support engineers tackle every day.
We've been getting questions regarding Multi-dimensional analysis (MDA) and Microsoft Dynamics GP 2013:
Q1: Is MDA still available in Microsoft Dynamics GP 2013?A1: MDA is still available and can be used in Microsoft Dynamics GP 2013.
Q2: Will Management Reporter be able to read MDA data in Microsoft Dynamics GP 2013?A2: Management Reporter in Microsoft Dynamics GP 2013 will no longer read MDA data, but will read AA (Analytical Accounting) data in Microsoft Dynamics GP 2013 and going forward. So if you wish to report on MDA data in Microsoft Dynamics GP 2013, you will need to use a different reporting tool, such as SSRS reporting, etc.
Q3: How do you migrate MDA over to AA?A3: MDA and AA data are stored in different tables, and can be run parallel to each other. Unfortunately, there is no connector to move MDA data over to AA tables. The current recommended steps are to pick a stopping point for MDA, and key beginning balances in for AA. Therefore, it would be best to do this at year-end time so you get a complete year in one product. KB #897742 explains the steps to key beginning balances in AA for this transition: 897742 How to move from Multidimensional Analysis to Analytical Accountinghttps://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;897742
Q4: What tables are the MDA data stored in?A4: The MDA data is stored in these SQL tables:
DTA00100 - Analysis Group Master DTA00200 - Analysis Codes Master DTA00300 - Account Analysis GroupsDTA00301 - Account Analysis Group CodesDTA00700 - Transaction Analysis Report OptionsDTA10100 - Transaction Analysis GroupsDTA10200 - Transaction Analysis Codes
I hope this information will be helpful to you, as you upgrade to Microsoft Dynamics GP 2013 and consider the switch over to using AA which offers more functionality, reporting and budgeting features.
Cheryl Waswick | Sr. Technical Support Engineer | Microsoft Dynamics GP Support
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics