The Advanced Dimension Editor for Dynamics NAV data sources allows users to quickly and easily incorporate any number of NAV Advanced Dimensions into their project. This functionality will automatically add the necessary tables, create links between tables, and add the dimensions to the OLAP cubes.
To access the Advanced Dimension Editor the user will click on the Add-Ins button on the Tools ribbon:
The user will then select the Advanced Dimension Editor from the list an click Run.
On the Advanced Dimension Editor screen the user will be provided with a list of all of the cubes that are present in the project along with all of the Advanced Dimensions that exist in their NAV database. The user will simply check the boxes for the appropriate Advanced Dimension – Cube combinations and click Save.
A results screen will then let the user know that everything
was successfully added to the project.
Once finished run a full manual deployment and execution for the changes to take effect.
If a user wishes to remove a dimension that was previously
added they can go back into the Advanced Dimension Editor and deselect any of
the boxes representing dimensions that they wish to remove. A result window
will confirm the removal of the dimension from the specified cube: