Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Rebuilding DataMart not showing correct info

(0) ShareShare
ReportReport
Posted on by 122

I am working with a client. I have rebuilt the DataMart multiple times and it completes with no errors but it looks like it is only pulling old data and not current data. I do not see any errors in the log. The weird thing is it runs quickly. This is another reason I think it is not grabbing all of the data. Any suggestions as to why it would not be grabbing current data?

Thank you,

Angie

*This post is locked for comments

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at
    RE: Rebuilding DataMart not showing correct info

    You might probably want to look at your MR Configuratio console and make sure the various settings to refresh your financial data is enabled..

    Did your try to rebuild the Datamart completly ? and one more question : how many companies are your retrieving into MR 2012 ? which build or MR2012 is installed ?

  • ARand Profile Picture
    122 on at
    RE: Rebuilding DataMart not showing correct info

    What I mean is it looks like it is rebuilding with the same number of transactions each time it does not look like it is updating with new info. It runs all the way thru the process but it runs thru pretty quickly. It is probably a few months that it has refreshed. If I am recreating the data would the refresh rate matter?

  • Richard Wheeler Profile Picture
    75,848 Moderator on at
    RE: Rebuilding DataMart not showing correct info

    What do you mean by old data? Only previous years? Is this a multi-tenant installation? I would first determine the location of this old data and go from there. Has the refresh rate been set to some really long period? Are we talking days or years of old data?

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans