Personalized Community is here!
Quickly customize your community to find the content you seek.
Microsoft Customer Co-creation
Help impact how the tools and services you rely on are developed. Microsoft Customer Co-creation connects you directly with our engineers so you can provide feedback before a single line of code is written. Interested? Learn more at Microsoft Customer Co-creation
2020 Release Wave 2Discover the latest updates and new features to Dynamics 365 planned through March 2021.
Release overview guides and videos Release Plan | Preview 2020 Release Wave 2 TimelineWatch the 2020 Release Wave 2 virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Upcoming TechTalks
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:
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.
Business Applications communities