Dimensions in NAV 2013 – Part 1 (Improvements)

by | May 29, 2014 | 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.

0 Comments

Submit a Comment

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

Upcoming Events

february

26feb12:00 pm1:00 pmShorten your Quote-to-Cash Cycle with CPQ

27feb11:00 am12:00 pmConfab With Stoneridge - Livestream - Cool Features in Dynamics 365 Business Central

march

04mar12:00 pm12:30 pmPower BI & Reporting with Dynamics 365 Customer Engagement

04mar2:00 pm3:00 pmHow to Incorporate the Power Platform with Dynamics 365 Finance and Supply Chain Management

12mar11:00 am12:00 pmConfab With Stoneridge - Livestream - Power Apps AI Builder

18mar12:00 pm1:00 pmMoving from CRM On Prem to the Cloud – Is it worth It?

18mar2:00 pm3:00 pmThe Past, Present, and Future of Dynamics 365 with Machine Learning and Artificial Intelligence

25mar2:00 pm3:00 pmAchieve Total Data Access & Future-Proof Your Reporting

26mar11:00 am12:00 pmConfab With Stoneridge - Livestream - Portals

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