Dimensions in NAV 2013 – Part 1 (Improvements)

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

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 endured my soapbox speech related to their value, even within the old database structures, and it seemed potentially valuable to finally create this as a brief blog series. The intent of this article (part 1) is to briefly introduce the underlying dimension changes and why those translate to improved productivity. In part 2, I will explore how dimensions are best used in Dynamics NAV. Finally, in part 3, I will explore ways to further enhance the integration of dimensions through some light customizations. There are two pieces of good news with NAV2013 related to dimensions:

  1. Dimensions were almost completely rewritten, in both tables and posting code
  2. The use of, and interaction with, dimensions will look and feel the same as in prior versions of Dynamics NAV

As you may be aware, for both documents and ledger entries, dimensions were stored in two places previously: in the two global dimension fields on each record, and in separate posted document dimension and ledger entry dimension tables. This was not an optimal design and stemmed from the evolution of NAV in the early product years. The challenge with the old design was that it required many records and a significant amount of code to maintain what would otherwise be a simple transaction. As an example, posting a one-line sales invoice with four dimension values would result in at least 20 secondary dimension records. This took up space in the database and valuable process time during posting. The new model replaces all of these secondary tables with a single field that now goes along for the ride on all entries: Dimension Set ID. This new field references a single global record representing the unique combination of dimension values on that entry. The four dimensions referenced in the above example would instead be passed as a single integer value representing that combination in a central table. As a result, the posting code is relieved of the burden of managing the dimension records and can now process much faster. Likewise, the centrally stored dimension sets don’t clutter up the database.

DimSet

The processing speed gains can exceed 50% for environments which truly take advantage of this powerful tool. Likewise, the database size can be reduced by a significant amount. What’s almost equally as impressive is that all of the underlying changes were made without disrupting the user experience. Entering and accessing dimension information is performed just as it has been in previous versions. NAV is executing very different code and querying new tables, but this is all transparent to the user simply looking for the various attributes on a given record. In Part 2, I will discuss how additional dimensions are best deployed now that performance is not the primary constraint.

Related Posts

  • 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…

  • 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

october

06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

13oct12:00 pm12:30 pmWave 2 Release – What’s Coming for Dynamics 365 Sales and Customer Service

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

november

04nov11:00 am12:00 pmConfab LIVE with Stoneridge - Challenging the Development Paradigm

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