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.

Best practices for Table Based Entity Creation

New reports

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.

  1. Project portfolio
  2. Project details
  3. Contract portfolio
  4. Contract details
  5. Utilization
  6. 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.

Preview Features

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.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment