D365 Finance & Operations and Dynamics AX Forum

  • 1.  MR Data Mart

    Posted 15 days ago
    We have over 8 years of data in our AX 2012 database and we would like to limit the number of years we put in the MR data mart.  We found the following instructions but this did not seem to work.  Is there more to it than this or is there a better suggestion on how to limit the data.

    4. To limit all Microsoft Dynamics SL databases, follow these steps:

    1. Locate the MRServiceHost.settings.config file, and then edit the file in Notepad. The default location of the file is <Program Files>\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Services. Note: You must install the Management Reporter Server component first.

    2. Add a line that resembles the following. <add key="IntegrationFiscalYearStart" value="2009" />

    3. Change the year shown to the start fiscal year limit that you want to specify. For example, if you specify 2009, the Management Reporter reports will include data from fiscal year 2009 and later.

    4. Save the changes to the MRServiceHost.settings.config file.

    Joe Geist
    Manager Financial Systems
    Regal Entertainment Group
    Knoxville TN
    The first step toward cloud success. - Migrate from AX to D365 with expert guidance from Microsoft. I'm Ready

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