Connect for Dynamics AX 2012 BI – Product Overview

Connect for Microsoft Dynamics AX 2012 BIPrecisionPoint Connect is an out-of-the-box BI & reporting solution for Microsoft Dynamics AX2012 BI. It is designed for the business user and greatly enhances the close-to-report cycle and general reporting & analysis experience of AX2012®.

The solution comprises an integrated financial data warehouse back-end (automatically reconciled to GL) as well as a number of front-end options for report & KPI design, information access, and information delivery. A powerful Excel add-in allows business users to create highly-specified reports in Excel and distribute these via either Excel, web, email or dashboard.

The PrecisionPoint Connect data warehouse runs a rapid automated process which evaluates the existing structures in the Microsoft Dynamics AX2012® system and creates database structures appropriate for analytics. Data is extracted from the Microsoft Dynamics AX2012 BI system and PrecisionPoint restructures and optimizes the data by joining ledgers together to create a complete and balanced analytic business warehouse.

This approach means that PrecisionPoint does not allow itself to be restricted by the modular or tabular structures of the underlying ERP system. Instead, it provides a single environment where information is integrated and the underlying transactional information (along with all its associated analysis information) is always maintained at the appropriate level of detail, irrespective of its source within Microsoft Dynamics AX2012 BI.

As a result, it is possible to move from one area of analysis to another, crossing ledger boundaries seamlessly; to perform analysis, information exploration and reporting of unprecedented breadth and depth; to drill up, down and across information which is organised logically and intuitively.

The data warehouse can be accessed via table or cube. If desired, an organization can define restricted or selective views of the cube information so that individual users or groups of users only access the information they are allowed to or need to see. This is managed by the organization using the in-built security in Microsoft SQL Server® Analysis Services.

PrecisionPoint is self-maintaining and will automatically be refreshed overnight, or on-demand at an interval of choice. It is also adaptive which means it will identify and reflect changes made in the underlying Microsoft Dynamics AX2012 BI system, such as Chart of Account or Dimension structure changes.

The product is delivered with a number of configured Excel report templates and the data warehouse can be customised to incorporate and integrate additional data from outside of AX® into the same singular data structure.

PrecisionPoint’s managed service offers both technical and business users on-hand expertise and advice with day-to-day Dynamics AX 2012 BI issues and reporting challenges, helping you get the best value out of the product.


For more please contact or call +44 845 1306 278 or +1 316 448 1033