Jun 12, 2009

Reporting and BI in Microsoft Dynamics AX

Microsoft Dynamics AX Reporting and BI framework and planned future directions to address the following Business Performance Management functional scenarios that are core to current generation Business Management systems:

Ad Hoc Reporting
Production Reporting
Multidimensional Reporting and Analysis
Business Scorecards
Financial Reporting


Ad Hoc Reporting in Microsoft Dynamics AX
Ad Hoc Reporting capabilities enable application users to create, view, and save reports that satisfy their individual information analysis requirements. Abstracted tools and services that do not require user knowledge of the underlying database schemas or experience in programming and advanced report authoring are required to enable this scenario. This scenario is also typically referred to as “self service” reporting. The primary goal for Ad Hoc Reporting is to enable application users to locate, select, filter, sort, group data, view, and format the results using predefined layout templates.

Model driven integration with SQL Server Report Builder is a new feature in Microsoft Dynamics AX that enables secure Ad Hoc Reporting.


SQL Server Report Builder is a new Ad Hoc Reporting framework and tool introduced in SQL Server Reporting Services 2005 to enable self service end-user reporting. The following webcast provides an overview of SQL Report Builder architecture and the scenarios that it enables. We recommend that you view this webcast if you are not aware of the capabilities and scenarios enabled by SQL Report Builder:

End-user Ad Hoc Reporting with SQL Server Reporting Services

Given figure illustrates the integration architecture. This implementation is a prime example of the Microsoft BI stack integration focus of the future direction for Reporting and BI in Microsoft Dynamics AX




The Microsoft Dynamics AX – SQL Report Builder Integration Architecture

Jun 5, 2009

Dynamics AX Pakistan

anyone interested to join Dynamics AX Pakistan group, please email at farhan.ahmad@maison-global.com