Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Auto Rebuild Management Reporter Datamart

Posted on by Microsoft Employee

Hello:

Does anyone know of a way to automatically rebuild the MR Datamart daily?

Dynamics SL 2011 SP2 with MR CU14.

Thanks,

Mike

*This post is locked for comments

  • John_Joyce Profile Picture
    John_Joyce 1,040 on at
    RE: Auto Rebuild Management Reporter Datamart

    Just saw that MR2012 CU15 has just been released.  Among the new features is this:

    ·         PowerShell module to enable reset of data mart

    Not sure if this will help you or not. Here's a link to info on the new CU:

    blogs.msdn.microsoft.com/.../management-reporter-cu15-now-available

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Auto Rebuild Management Reporter Datamart

    Hi John:

    Thanks for the reply.  No, there is not a function to auto rebuild.  Hoping someone has ideas for scheduling and scripting the processes.

    We have multi-company within app db and multi-company with distinct app db's, multiple ledger, multi-currency, FST, integrated apps.  It's pretty complicated.  We think MR may not be up to the task.

    Best,

    Mike

  • John_Joyce Profile Picture
    John_Joyce 1,040 on at
    RE: Auto Rebuild Management Reporter Datamart

    I am not aware of any such functionality. What type of problems are you having that you would want this? I've got one client that was on an older version of MR (CU8) and on two crappy App/SQL servers.  Once we upgraded the servers and moved them to CU14, we've only had to re-build the Datamart twice in six months.

    What I'm trying to say is that with the proper hardware, we've found CU14 to be very stable. And this client has 3 separate SL App DB's and a total of 54 companies.

    John

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans