Request a demo
Fill in the form below or contact us directly
BIBuilder4AX
Powered by SCALES
Get insight to your AX data with RAPID, AGILE, AUTOMATED business intelligence.

Getting insight into your data can often be a time-consuming and costly affair. Reporting and analysis projects usually require large investments in resources and time.
ERP systems are optimized for user interaction and not for heavy reporting and data analysis. This will often cause sluggish and un-intuitive built-in reporting options.
To overcome these challenges, SCALES has developed a tool, that can either build your entire Business Intelligence (BI) platform, giving you insight within days, or be used by your internal BI development team to substantially speed up AX BI development. Either way, there are no trade-offs in regards to neither infrastructure challenges nor proper BI best practices.


Optimized for Microsoft Dynamics AX 2009, 2012 and AX7 data analysis
Quickly gain insight to your data in interactive reports and dashboards
Rapid and agile development allows insight in a matter of days
Access your analysis from anywhere on any device
Substantially simplifies the complex data structures in AX
Open your data up for self-service BI, without compromising security

Get an introduction to BIBuilder4AX.
Watch the video below.


Your data and analysis should always be easily accessible without compromising security. Authoring reports should be intuitive and fast, and not only a task for IT professionals.
These are some of the reasons why SCALES recommends using Microsoft Power BI as the reporting and analysis front end.
By using Power BI, you can access your data from anywhere on any device, without complex infrastructure or expensive licenses and startup costs.
BIBuilder4AX builds a model tailored for consumption in Power BI. It can optionally deploy this model to the cloud, eliminating the need for setting up cloud/on-premise connectivity.
Below is a couple of screenshots, showing the user experience in Power BI. Click here to read more or to try it out yourself.


Self-service BI has become a common demand. Opening data up for business users quickly becomes a complex task in relation to security concerns and source system performance impact.
BIBuilder4AX can help you overcome these challenges. It will generate a staging database that is a simplified version of the AX database, optimized for self-service analysis. You can even copy the security setup from AX, so that users only see the data they have been granted access to inside AX*.


Structure is optimized for self-service BI
Substantially simplifies the complex data structures in AX by combining tables automatically
Translate database values (enums) to human readable values
Simplifies combination of multiple interval controlled tables
Generates one-column keys between already simplified tables
Optionally add an extra security layer so that users only see the data they have been allowed to see in AX*

*Security is based on company and table

The architecture is built to allow easy adoption in your organization. Whether you are starting from scratch, or already have an established BI platform, BIBuilder4AX can speed up your process and automatically handle some or all of the complicated and time-consuming tasks involved in the development.
BIBuilder4AX will create a simplified, enhanced staging SQL database. This database can be accessed directly by existing or new infrastructure. It is also optimized for self-service BI (see previous section).
With BIBuilder4AX you can optionally build a data warehouse and cubes based on the staging layer to allow for immediate reporting.


After installation and configuration, BIBuilder4AX creates a BI solution based 100% on Microsoft SQL Server components. At this point, BIBuilder4AX can be completely uninstalled, as everything will run based on databases, SSIS packages and an agent job.
It is however recommended to leave BIBuilder4AX installed, as it will allow for agile evolvement of your BI solution. Extending your BI Solution is very easy and quick with BIBuilder4AX.


Creates a Kimball and Microsoft "best practice" ETL process
Relies on and generates 100% standard Microsoft SQL Server components
Decoupled from AX - Minimum performance impact and short development and release cycles
Easily add both source based (via SQL Server Change Tracking) and target based delta load
Every aspect of the solution from AX to staging to Data Warehouse to cubes can be automatically build
Developers can still utilize the power of SSIS and SSDT to implement complex business logic

BIBuilder4AX is a tool for rapidly building a durable BI solution where AX is the primary source of data. To ensure complete and relevant coverage, BIBuilder4AX doesn't assume which areas is important for your organization in a prepackaged reporting solution. Instead it lets you choose which data to analyze, and automatically builds all the BI stack components. This ensures that any data can be analyzed, whether it is standard AX, customizations or ISV solutions.
The below screenshots outlines the complete process of building a BI solution from scratch using BIBuilder4AX.


There are three price tiers for BIBuilder4AX. All features are included in every price tier. The price for BIBuilder4AX is only dependent on the number of users in the AX source system. To calculate the price, first derive the calculated users:

Calculated users = number of licensed enterprise user plus a third of licensed functional users

Calculated users below 150


- Small -
Calculated users between 150 and 500

- Medium -
Calculated users above 500


- Large -

Contact SCALES for exact prices

If you have any questions or would like to see a demo, please contact us:
Søren Sparsø
BI Technical Lead
Tlf.: 5146 5747
soren.sparso@scales-group.com
Jakob Bjerg-Heise
BI Business Lead
Tlf.: 5358 8495
jakob.bjerg-heise@scales-group.com
SCALES AS Automatikvej 1 DK-2860 Søborg +45 7026 8888

http://scales-group.com