How to build an entry table with free dimensions is one of the topics covered in the Dimension Set Entry Overview.
A set of dimensions is called a dimension set.It is stored in a database.Each set entry has a single value.The dimensions are identified by a common set ID that is assigned to each set entry.
There are three dimensions set entries in the following example.The dimensions are identified by a dimensions set ID.
The dimensions are stored in the Dimension Set Entry table.
You can specify a combination of dimensions when you create a new journal line.A dimension set ID is assigned to the journal line or document line to specify the dimensions in the database.
A check is performed to see if the combination of values is a set in the table.If the combination occurs in the table, the corresponding dimensions set ID is assigned to the journal line or document line.A new dimension set is added to the table, and the new set ID is assigned to a journal line or document line.
Codeunit 408 is a function library that handles common tasks that are related to dimensions, such as copying from one table to another.
The space in the database is preserved and the performance is improved.
The table structure design details are related to the set entries.