Dimensions in Dynamics NAV 2013 – Part 2 (Deployment)

by | Updated June 13, 2018 | Dynamics 365 Business Central, Dynamics NAV

In Part 1, I described how dimension integration in Microsoft Dynamics NAV has been significantly improved with the NAV 2013 release. In this post, I would like to discuss how dimensions in NAV can best be deployed now that performance is no longer the primary constraint. Beyond the dimension itself and its relative importance for your business, you will need to consider three important numbers related to dimensions in Dynamics NAV: 2, 4 and 8.

In NAV, you are able to create an unlimited number of dimensions and use as many of those as you wish on any given transaction. As an example, a company may assign a department, cost center, customer group, item group, and project to a sales invoice line. The requirements for dimensionalization and the rules for combinations may all be maintained in setup tables that are either defined up front or as your company’s use of those dimensions evolves. A company intent enough on various measurements could see well over ten different dimensions in use. As the introduction of additional dimensions is considered, it is important to know how that information will ultimately be used and what additional burden on data entry is acceptable. This is where the numbers 2, 4 and 8 become more important.

2: There are two global dimensions

A global dimension is simply the name NAV assigns to the two most important dimensions. These are not only stored in the parent tables and referenced by their Dimension Set IDs, but they are also included on every posted entry. As such, you are able to filter and sort on these values from posted ledgers and documents.

4: There are four dimensions allowed in an Analysis View

An analysis view is the out-of-the-box business intelligence (BI) tool that NAV provides for slicing and dicing your dimensionalized data. With an analysis view, you are able to review the interplay between dimensions, drop the data to an Excel pivot table via a built-in-tool, or append an existing account schedule to use the included dimensions. You are able to have as many analysis views as you wish and can build them by any combination of up to four dimensions at a time. The limiting factor here is simply that any specific analysis view may only include four dimensions.

8:  The eight dimensions deemed most important, via setup (also called shortcut dimensions)

On most document and journal lines, the first eight dimensions may be edited right on the line. Dimensions beyond these eight may still be entered, but require an extra click by the user to open a separate page.

 

I often recommend a brainstorming session to first identify the dimension candidates. Once the list is compiled, the importance of each of these should be ranked. The cutoffs may then be considered. As an example, if five potential dimensions are identified, the final one may require a little extra consideration as it would fall outside of the four-dimension limit in Analysis Views. It may ultimately still be deployed, but this is where the cutoffs are best considered. With the final list in hand, one additional consideration should be discussed: which of the dimensions are candidates to have their values defaulted into transactions. As an example, it is sometimes advantageous to have the customer numbers duplicated as a customer dimension. In these cases, the user should never need to manage the dimension; it should simply go along for the ride with the customer itself. There are a number of these and examples include customers (and/or groups), vendors/groups, salespeople (and/or territories, regions), items/groups, resources/groups, jobs, etc…

 

Cube

 

An upgrade is a good opportunity to introduce additional dimensions if you want history to also include those values. Alternatively, if you’re on NAV2013 and wish to deploy new dimensions and append history, the process should not be cost-prohibitive. We have scripted a few of these and the investment is not significant. Some additional options will be explored in the next entry: Part 3 (Extension).

 

 

Related Posts

  • While I have always been a strong proponent of the power of dimensions, I have only recently been able to fully embrace the execution in Microsoft Dynamics NAV. Many have…

  • In this final entry on dimensions, I am going to explore some of the ways you might modify Microsoft Dynamics NAV 2013 to better utilize the existing dimension functionality. While…

  • Since the acquisition of the Navision product in 2001, Microsoft has continued to improve the product functionality and features.  The introduction of Dynamics NAV 2009 propelled the product into a…

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

december

02dec9:00 am12:00 pmOnline Workshop - Dynamics GP Year End Close (Morning Session)

03dec11:00 am12:00 pmConfab with Stoneridge - Livestream: Live Agents, Power Virtual Agents, Omnichannel – Oh My!

03dec1:00 pm4:00 pmOnline Workshop - Dynamics GP Year End Close (Afternoon Session)

09dec10:00 am10:30 amThe Modern Manufacturer - Manufacturing Policy Management

17dec11:00 am12:00 pmConfab with Stoneridge - Livestream - Technology in 2020: A Year in Review

january

06jan10:00 am10:30 amThe Modern Manufacturer - MRP v MPS – What, When and How

14jan11:00 am12:00 pmConfab with Stoneridge - Livestream - Looking Forward: Predictions for Technology in 2021

20jan10:00 am10:30 amThe Modern Manufacturer - Demand Forecasting Functionality

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X