Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Rebuilding DataMart not showing correct info

Posted on by 120

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
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 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
    ARand 120 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
    Richard Wheeler 75,730 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans