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
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
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156