Data Warehouse Automation (DWA)

BI4Dynamics is a DWA solution that improves productivity, reduces cost, and improves overall quality. All SQL code is generated automatically. Any change to existing or new functionality is just one click away.

Customization D365 (AX)   Customization BC (NAV)

Modeling is based on metadata

BI4Dynamics Data Warehouse Automation (DWA) process is build based on the D365(AX)/NAV metadata. This powerful concept ensures that all properties such as fields types, table relations, primary keys, etc. are intuitively entered to the user interface.  Because of this, you can create Enum based scripts in D365 (AX) or option fields from NAV fast and accurate. This brings customization of Data Warehouse to a completely different level and significantly improves users productivity.

100% open SQL scripts for modifications

DWA generates SQL scripts (T-SQL, XML) that are 100% open for any modification. Sections separated by placeholders structure all SQL scripts. Because of this users have control and understanding when doing manual customizations.

Mix automatically generated and manual SQL code

Inserting manual SQL code to DWA generated SQL script is a feature that supports further DWA generation of the same script and preserving manual code intact.

Empowerment of D365(AX)/NAV consultants

D365(AX)/NAV consultants can deliver most tasks with brief training since the key to success is understanding Microsoft Dynamics data structures. BI Project can be either edit or build in the five simple steps.

Documentation Automation

Last minute change? No worries. Complete documentation in the form of a White Paper is generated automatically with a click of a mouse. Documentation delivers all technical details about Data Warehouse architecture, Data Warehouse and OLAP Cubes formulas, dimension hierarchies, top tables information and even execution times of top procedures.

Click below for more information and how-to-videos on:

Customization D365 (AX)   Customization BC (NAV)