Open Forum

Expand all | Collapse all

Management Reporter - TEST Refresh

Jump to Best Answer
  • 1.  Management Reporter - TEST Refresh

    Posted Dec 05, 2017 10:02 AM

    Hello,

    We're planning to install Management Reporter in our TEST environment.  Our partner mentioned that when we do a data refresh from our LIVE environment to our TEST environment, the MR DataMart will not know to refresh it's data.

    Does anyone know of a resource or script to re-build the MR DataMart when we do a data refresh​ from LIVE to TEST?

    Thanks,

    Sharon



    ------------------------------
    Sharon Hine
    Manager, Program and Financial Systems
    CANARIE Inc
    Canada
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Management Reporter - TEST Refresh
    Best Answer

    GPUG ALL STAR
    Posted Dec 05, 2017 10:38 AM
      |   view attached
    Hi @Sharon Hine

    Here is a quick checklist that I've used in the past when I had to rebuild my datamart.

    Hope it helps!​​​​​

    ------------------------------
    Frank Heslin
    Financial Systems Administrator
    ExamWorks, Inc.
    Atlanta GA

    GPUG Advisory Committee Member
    Summit Track Leader
    GPUG All Star 2016

    GP2015 R2
    MR CU14
    ------------------------------

    Attachment(s)

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Management Reporter - TEST Refresh

    Posted Dec 05, 2017 10:41 AM

    ​Hi @Frank Heslin

    Thank you for sharing that - I believe it will be extremely helpful.

    Cheers,

    Sharon​



    ------------------------------
    Sharon Hine
    Manager, Program and Financial Systems
    CANARIE Inc
    Canada
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Management Reporter - TEST Refresh

    GPUG ALL STAR
    Posted Dec 06, 2017 11:43 AM
    Hi Sharon,
    You don't say how you're going to refresh your TEST environment... but if it's a clone of your production server, then yes, Frank's guide to refresh MR will be helpful..
    Be careful, as there are other parameters than just MR when it comes to refresh TEST environments (not TEST companies).. like report server setup and so on.. Many parameters inside your GP TEST environment will still point to URL's form the Production.. make sure you fix them before starting to play with any upgrade process, or it's going to bite you back at some point :-)

    If updating your TEST environment only consist of restoring your GP companies onto a different server, then installating MR 2012 from scratch on that test server will be no problem.. Again, pay attention of the restored parameters from your LIVE system, which can still point to some shared production folders.

    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP MVP
    Ultra-Electronics Forensic Technology Inc.
    Montreal QC/Canada
    @GP_Beat http://dyngpbeat.wordpress.com/
    Montreal QC GPUG Chapter Leader
    GP2013R2 / MR2012 CU14
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Management Reporter - TEST Refresh

    Posted 24 days ago
    Hello Frank,

    does your checklist refer to a repointing a clone of production into a "another" environment , say Production 2?
    just asking, as i have a similar task on the horizon.
    thx,

    ------------------------------
    Toulou Yong
    Senior software engineer
    Arch Insurance Group Inc
    Raleigh NC
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role