Introduction

Atlas XL

In addition, Atlas xl is an add-in for Microsoft Excel that gives you access to all Dynamics Ax data without requiring you to understand relational database concepts or the structured query language (SQL). With Atlas xl users can create reports and analyze data directly in Excel. The information they need is retrieved and refreshed from Dynamics Ax on demand and placed in the spreadsheet. The result is a direct and seamless link between Dynamics Ax and Microsoft Excel. Dynamics Ax appears as a dropdown menu within Excel. The menu is consistent, grouping the functionality similar to the Dynamics Ax Modules. A valid Dynamics Ax username and password is required before Atlas xl can report on your Dynamics Ax data.

Axnosis BI Engine

Axnosis has developed a BI engine in Dynamics Ax for Dynamics Ax that allows user to use the power of Atlas XL and Microsoft® SQL Server™ Reporting Services. The engine support ETL principles but with the advantage of never leaving the Dynamics Ax environment. This engine incorporates: mapping rules on the Chart of Accounts to summarise GL accounts into Management Accounts. extraction and normalization of OLTP tables. aggregation and consolidations of transactions.