New Model – Table Based Entity approach
To export the data from Dynamics 365 Finance and Operations we are now following Table based entity approach which not only allows us to be more agile but also makes the system robust. Now all the entities provided in the product supports incremental approach, which reduces the export time for data and makes the process much more faster than the legacy model.
This also provides us the ability to add any field to the model as and when needed as all fields are now exposed and simple SQL query script modification allows us access to the field avoiding another development life cycle and code promotions from Dynamics 365 F&O.
We have designed 6 new reports based on the product’s data model which will give insights to the business and take appropriate decisions based the data. Details on each report can be found by navigating to the report guide section.
- Project portfolio
- Project details
- Contract portfolio
- Contract details
- General Ledger Analysis
New FACTs/Dimension Added
New Dimension added : Contract
New dimension has been added to the model which will provide feasibility to design report related to project contracts and slice and dice data using contract.
New FACT added : Resourcing
New FACT has been added to the model which will provide feasibility to design report related to resource forecast and booking.
Deep Links (Preview)
Deep links are URLs that open a specific record or filter within a D365FO form.
In this release, deep link features are provided that can be setup against any form in D365FO. The links can be exported from D365FO via a Data Entity, most commonly to a BYOD configured for BI. Deep links can be used with any external application, enabling users to quickly navigate back to D365FO to update information. The most common and targeted use case is looking at a Power BI report and directly opening up a record for editing or viewing additional information.
Because this concept has been designed to be broadly applicable across D365FO, only limited scenarios have been tested. Therefore this feature is classified as a Preview feature as additional unique scenarios are validated.