With the next release of SQL Server code named Katmai, due next year and Dynamics AX 5.0 to follow right behind, its time to start thinking about what this means for the Dynamics AX eco-system.
Basically if you read up on Katmai, one of the major goals is Business Analaysis, and tighter integration with the Office 2007 platform, including SharePoint. For Dynamics AX, this means more out of the box ability for Ad-Hoc report generation from Excel, with Dynamics AX data. What comes to mind here is the Business Data Catalog. This will enable Report Models (refernce current perspectives in DAX 4.0) that will allow an end user to select from a given report model set, and drag and drop into Excel, SSRS, and work with that via SharPoint.
Ok maybe I am getting ahead of the ability curve here, but it will be close. This also means that the Business Scorecard manager will become more web part based, and start to turn into a RIA (Rich Interactive Application) experince hosted via SharePoint. This also means the business analysis in Dynamics AX will have more interactivity and interaction abilities with Excel 2007, SharePoint, etc.
So when we look at the overall picture, one of the big pushed for Katmai SQL Server, and Dynamics AX 5.0 is tighter integration with the Office 2007 platform. This means for the information worker, more and more job role responsibilities can start to live back into the Office domain, and less dependant on having to live and work inside Dynamics AX client itself.
Well check back soon!Find a job at: www.DynamicsAXJobs.com
Labels: Business Analysis, Dynamics AX, Dynamics AX 5.0, Excel 2007, Katmai, Office 2007, SQL, SQL Server