Design Details: Searching for Dimension Combinations

Article
07/01/2017

When you close a window after you edit a set of dimensions, Dynamics NAV evaluates whether the edited set of dimensions exists. If the set does not exist, a new set is created and the dimension combination ID is returned.

Building Search Tree

Table 481 Dimension Set Tree Node is used when Dynamics NAV evaluates whether a set of dimensions already exists in table 480 Dimension Set Entry table. The evaluation is performed by recursively traversing the search tree starting at the top level numbered 0. The top level 0 represents a dimension set with no dimension set entries. The children of this dimension set represent dimension sets with only one dimension set entry. The children of these dimension sets represent dimension sets with two children, and so on.

Example 1

The following diagram represents a search tree with six dimension sets. Only the distinguishing dimension set entry is displayed in the diagram.

Dimension tree structure

The following table describes a complete list of dimension set entries that make up each dimension set.

Dimension Sets	Dimension Set Entries
Set 0	None
Set 1	AREA 30
Set 2	AREA 30, DEPT ADM
Set 3	AREA 30, DEPT PROD
Set 4	AREA 30, DEPT ADM, PROJ VW
Set 5	AREA 40
Set 6	AREA 40, PROJ VW

Example 2

This example shows how Dynamics NAV evaluates whether a dimension set that consists of the dimension set entries AREA 40, DEPT PROD exists.

First, Dynamics NAV also updates the Dimension Set Tree Node table to make sure that the search tree looks like the following diagram. Thus dimension set 7 becomes a child of the dimension set 5.

NAV2013_Dimension_Tree_Example 2

Finding Dimension Set ID

At a conceptual level, Parent ID, Dimension, and Dimension Value, in the search tree, are combined and used as the primary key because Dynamics NAV traverses the tree in the same order as the dimension entries. The GET function (record) is used to search for dimension set ID. The following code example shows how to find the dimension set ID when there are three dimension values.

DimSet."Parent ID" := 0;  // 'root'  
IF UserDim.FINDSET THEN  
  REPEAT  
      DimSet.GET(DimSet."Parent ID",UserDim.DimCode,UserDim.DimValueCode);  
  UNTIL UserDim.NEXT = 0;  
EXIT(DimSet.ID);

However, to preserve the ability of Dynamics NAV to rename a dimension and dimension value, table 348 Dimension Value is extended with an integer field of Dimension Value ID. This table converts the field pair Dimension and Dimension Value to an integer value. When you rename the dimension and dimension value, the integer value is not changed.

DimSet."Parent ID" := 0;  // 'root'  
IF UserDim.FINDSET THEN  
  REPEAT  
      DimSet.GET(DimSet.ParentID,UserDim."Dimension Value ID");  
  UNTIL UserDim.NEXT = 0;  
EXIT(DimSet.ID);

Share via

Design Details: Searching for Dimension Combinations

Building Search Tree

Example 1

Example 2

Finding Dimension Set ID

See Also

Additional resources