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

  • Navin Mirpuri Profile Picture
    Navin Mirpuri on at
    RE: Management Reporter Multi-Entity Data Consolidation

    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.

  • Navin Mirpuri Profile Picture
    Navin Mirpuri on at
    RE: Management Reporter Multi-Entity Data Consolidation

    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.

  • Verified answer
    sueconrod Profile Picture
    sueconrod 335 on at
    RE: Management Reporter Multi-Entity Data Consolidation

    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

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    RE: Management Reporter Multi-Entity Data Consolidation

    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.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans