Microsoft Dynamics AX Users Seek Custom, Third Party Solutions to Business Intelligence Needs

Microsoft Dynamics AX 2009 and 2012 may both come with hundreds of standard reports, but among about 150 AXUG members assembled at AXUG Summit 2011 for a discussion on BI best practices, almost none reported using using either standard operational reports in AX or using FRx or Management Reporter for financial reporting.

The complaints for the standard tools varied - performance problems, requirements mismatches, unsophisticated financials, and a lacking easily available analysis capabilities. And beyond any real shortcomings of the products, several users admitted to simple lack of awareness about what those hundreds of pre-built reports can really do. Based on a show of hands, about 80 percent were AX 2009 users, about 15 percent were on AX 3.0 or 4.0, and just a handful were on AX 2012.

"For all the AX deployments I've done, I have yet to see a customer use a lot of the standard reports," said moderator James Gurney of ideaca. "The standard reports are good guidelines but expect to create new ones." But from what members of the audience shared, AX customers are typically looking to one of several alternative approaches- SQL Server Reporting Service (SSRS), Excel, a third party BI solution, or a full-fledged data warehouse (DW) or operational data store (ODS).

...

Requires FREE Membership to View

Login
Become a Member Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more, and it’s all FREE. You’ll also receive periodic email newsletters with the latest relevant articles and content updates.
About Jason Gumpert

As the editor of MSDynamicsWorld.com, Jason oversees all editorial content on the site and at our events, as well as providing site management and strategy. Prior to co-founding MSDynamicsWorld.com, Jason was a Principal Software Consultant at Parametric Technology Corporation (PTC), where he implemented solutions, trained customers, managed software development, and spent some time in the pre-sales engineering organization. Jason has also held consulting positions at CSC Consulting and Monitor Group.

Read full bio...

minivan