This post continues exploring the topic of Dimensions in Dynamics NAV (further, “NAV”) and Dynamics 365 Business Central (further, “D365BC”). Other posts have already discussed what Dimensions and Dimensions Values are; how to create; and assign them to Master Data and GL Accounts as well as how to block Dimension Combinations. This post focuses on how to use Dimensions in reporting in particular.
A few months ago, I worked on a case where a client was having a problem with the analysis by dimensions matrix in Microsoft Dynamics NAV. It was a tricky problem (and quite hard to state in a descriptive manner), so I’ll demonstrate it using pictures.
If you are expecting an output that looks like this (the analysis by dimensions matrix shows the G/L accounts per month):
A coworker in Advania is working on a Business Intelligence solution called Advania Insight. He is working on the installation for a company that is running NAV. This company has data from Navigator since 1994.
One of the problem we saw was that some of the dimension codes used where not a standard dimension but for example a heading or a footer. This did not go to well through the analysis and we needed to fix this
You must have seen my blog video “How to Import and Post Opening Balances along with Dimensions in NAV2013 using Rapid Start Services” here.
You can see the Dimensions in Conf. Package tables fields but you cant see Dimensions as fields in Newly created package.
How to add the Dimensions in newly created package table fields?
Setting up dimensions should not be something we exclusively do when we implement NAV for the first time at our businesses. Change is the norm in business, and I would be genuinely surprised to hear from anyone at this point that their business has not changed significantly in the last five years.