Reporting and Analytics in Dynamics AX 2009

Play Reporting and Analytics in Dynamics AX 2009
Sign in to queue


I spent some time with Manoj Nuthakki on the Dynamics team chatting about how we take full advantage of SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) in the recently released Dynamics AX 2009.  AX 2009 ships with 10 SSAS cubes out of the box so includes tons of prebuilt KPIs and reports all built on the SQL Server BI platform.

Manoj walks us through how reports and charts are built in Visual Studio including conditional formating or custom business logic in C# while pulling metadata and data directly out of AX.  The reports are easily put into the AX 2009 rich desktop client and the enterprise portal web client (built on SharePoint).  With the role center integration a developer can build reports, charts and KPIs that appear only for the appropriate roles.  Since AX is an international product, localization is built right in.



Download this episode

The Discussion

Add Your 2 Cents