Dynamics AX has an add-on for Microsoft Excel that allows you to retrieve data from Dynamics AX, and also publish changes back to the database in a controlled way. You can use this to give users a simpler way to manipulate the information in the database. As an example, you can use this to create a better way to update demand forecasts, since the default maintenance forms within Dynamics AX.
In this walkthrough we will show how you can:
- Build your initial forecast model
- Link to your forecast within Excel
- Create total matrix fields
- Create period total matrix fields
- Create summary forecast dashboards in PowerView Read More