web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter Mu...
Microsoft Dynamics GP (Archived)

Management Reporter Multi-Entity Data Consolidation

(0) ShareShare
ReportReport
Posted on by Navin Mirpuri

Here is the scenario:

8 different entities and consequently 8 different GP servers and installs.

1 overall Board of Directors that needs to view consolidated data across all 8 entities.

On a previous project, I have used the Reporting Tree to create consolidated reports across multiple GP Company databases that were on the same SQL server and under the same DYNAMICS database.

In this example, each company database is on its own SQL server under its own DYNAMICS db.

Any ideas on how do I consolidate data this time? Am open to other suggestions other than Management Reporter as well.

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Navin, are you using the Legacy or Datamart feature in MR?  I can envision populating the data mart with numbers from each of your GP instances and reporting off that, although this would be an unsupported configuration since the data mart supports connection to only one database.  You would have to create your own data mart update scheme from each of the separate databases.

  • Verified answer
    sueconrod Profile Picture
    sueconrod 337 on at

    Just found the article you need to go thru.  Jivtesh Singh put the article out there, but he is referencing information from April Olson from the CPM team.  I think this should meet your needs.

    community.dynamics.com/.../management-reporter-for-dynamics-gp-resources.aspx

  • Navin Mirpuri Profile Picture
    Navin Mirpuri on at

    Thank you Susan. This reply helped. I did not realize that you could have multiple ERP instances into the same Data Mart. Basically, you have to go to File > Configure while in the ERP integrations form to add additional ERP sources and instances.

  • Navin Mirpuri Profile Picture
    Navin Mirpuri on at

    Hello Frank,

    As per the link below, from what I understood that you could have multiple GP ERP instances integrated in the same Data Mart. I wasn't able to test it yet but I saw the option to add another instance. Yes, definitely have to ensure that the data mart is updated with each GP db from their own respective SQL instances.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans