With Microsoft Dynamics 365 for Finance and Operations (and also the last update for Dynamics AX2012 R3), the Entity database was introduced. In it…
With Microsoft Dynamics 365 for Finance and Operations (and also the last update for Dynamics AX2012 R3), the Entity database was introduced. In it, selected transactional data (sales, invoices, production runs, etc.) is duplicated from the operational database and is thus available almost in real time (after just a few minutes) for statistical analysis. In combination with PowerBI, Microsoft's self-service BI tool, BI analyses can now be displayed within the AX application. The integration of the dashboards and reports provides the functionalities of «PowerBI Online», which means the graphics can not only be viewed but are also available interactively for filtering functions and drilldowns In addition, PowerBI offers the option to load data from other sources and display it together with AX data. For example, in addition to sales figures from AX, access data from the web shop or social networks can be queried and put into context with one another. BI thus moves closer to the ERP system; the data can be viewed without leaving the operational system and enriched with external data.