Microsoft Dynamics 365 Blog

Greg Byer [MSFT]

Posts

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 Read more

0 Comments

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 Read more

0 Comments

Hotfix 3815274 is an optional hotfix that can be applied to CU16. It can be loaded to revert a CU16 change with reporting tree rollups. The hotfix will allow children nodes to be rolled up to a parent that contains a Dimension filter. Before making any changes, be sure to have a backup of the Read more

0 Comments

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 Read more

0 Comments

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 Read more

0 Comments

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   Read more

0 Comments

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 Read more

0 Comments

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 Read more

0 Comments

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       January Column The Read more

0 Comments

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.       January Column The report date is March 31st. The columns are set Read more

0 Comments

Rates entered in AX for USD to GBP that will be used by MR when doing currency translation.     January Column The report date is March 31st. The columns are set to return January data. The rate used will be the rate in effect on 1/31 – .63428         March Column Read more

0 Comments