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 pre-built KPI’s 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 formatting 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 KPI’s that appear only for the appropriate roles. Since AX is an international product, localization is built right in.