Is in-memory BI technology a better reporting solution than traditional query-based?

Although in-memory database structures have been around for a while, they are getting more traction in the Microsoft Dynamics AX world thanks to the efficiency they achieve over traditional query-based engines. They offer the ability to take snapshots of table data for use in a highly efficient BI execution framework. In-memory reporting is changing the way Microsoft approaches reporting Dynamics AX, and customers need to develop an understanding of this evolving technology and its implications for the future.

...

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 Don Riggs

Don Riggs is a well-seasoned veteran with 25+ years of implementation consulting and 13+ years of Microsoft Dynamics AX experience. In his career, he has been involved in anything from helping design ERP systems, developing and marketing ISV solutions, to delivering a number of successful AX ERP implementations. As a regular participant in AXUG, he has delivered many courses and presentations. Don is considered by many to be an AX expert, particularly in the areas of inventory costing, manufacturing, AX project module, and implementation processes. Having attained APICS certification in the early 1980's, Don considerers himself a manufacturing consultant by trade and his love and enthusiasm for the industry has never waned. Always interested in new challenges, his branching out into other areas of the product has allowed him to become very knowledgeable in many areas. 

Read full bio...

Queries

One of the issues with MDX and queries was the difficulty in making MDX work for complex aspects that are needed in reporting and KPIs. How does in memory relate to this as few things are pure queries.

Also great article.