Greg Byer [MSFT] articles

Greg Byer [MSFT]
Published 
1 min read

Management Reporter 2012 compatibility with Microsoft SQL Server 2017 

Management Reporter 2012 is currently not compatible with Microsoft SQL Server 2017. When you try to install Management Reporter 2012 on SQL Server 2017, you receive this error: The database deployment failed. Additional information: Microsoft.SqlServer.Dac.DacServicesException: Could not deploy package. —> Microsoft.Data.Tools.Schema.Sql.Deployment.DeploymentFailedException: Unable to connect to target server. There are no plans to support Microsoft SQL
Published 
1 min read

Management Reporter 2012 CU 16 Hotfix 3813390 

This hotfix addresses an issue where user security may be removed during the Company to Company mapping if there is a SQLException. If a SQLException occurs during the AX 2012 Companies to Company integration task, such as a SQL server being offline, users may be removed from the security groups in Management Reporter Security and
Published 
<1 min read

Configuring HTTPS with Management Reporter CU16 

Management Reporter CU16 offers a new HTTPS feature to enable encrypted communication between the Management Reporter server and client (Report Designer, Report Viewer and the web client). This article will guide you through setting up the HTTPS feature in CU16. It is recommended that you test this in a test environment to confirm that the
Published 
2 min read

SQL scripts to check the MR integration 

Support uses two scripts to help identify the current state of an integration and to review the integration history as well. These are useful in identifying how long the initial integration takes, knowing when the initial integration has completed, and reviewing the integration history to identify if any issues have occurred. The first script shows
Published 
1 min read

Resetting the Management Reporter data mart for Dynamics 365 for Operations 

If you need to reset the Management Reporter data mart for Dynamics 365 for Operations, you can use the steps listed below. These steps are for a sandbox/UAT environment. If you need to reset the data mart in your production environment, contact support. To rebuild the data mart using the steps found here: https://mix.office.com/watch/36g9prxvg885  
Published 
5 min read

Troubleshooting Management Reporter Data Mart Staging Records 

Management Reporter (CU10+) integration for Dynamics AX 2012 pulls subsets of AX financial data first into staging tables in the data mart database. The Maintenance Task, which is run every minute by the Management Reporter Process Service, attempts to resolve the staging records into the main Data mart tables. If a staging record cannot be
Published 
2 min read

Management Reporter AX 2012 Integration Overview 

Management Reporter has several maps that integrate subsets of the AX financial data into the data mart database. A portion of the MR Process Service code called the Scheduler runs these integration maps at regular intervals (1 or 5 minutes by default) to ensure the report data is up-to-date. During the integration, a number of
Published 
1 min read

Using the Weighted Average translated type in Management Reporter 

Rates entered in AX for USD to GBP that will be used by MR when doing currency translation. The weighted average is calculated by taking the rates multiplied by the days in effect and divided by number of days in the period. (rate * days in effect)/day in period           YTD/BB
Published 
1 min read

Using the Average translation type in Management Reporter 

Rates entered in AX for USD to GBP that will be used by MR when doing currency translation. The average rate is calculated by taking the sum of the rates and dividing by the number of rates in the period.           YTD/BB Column Average translation type accounts are typically P&L accounts
Published 
1 min read

Using the Current translation type in Management Reporter 

Rates entered in AX for USD to GBP that will be used by MR when doing currency translation.         YTD/BB Column The report date is March 31st. The columns are set to return YTD/BB data. The data comes from the year end process run on 12/31 so uses the rate from that