Table "Dimension Set Entry"
Stores individual dimension entries that form dimension sets for multi-dimensional analysis. Core table for dimension set management enabling optimized storage and retrieval of dimension combinations.
Remarks
Central to dimension set architecture: dimension sets group multiple dimensions for transaction analysis. Integrates with Dimension Set Tree Node for optimized duplicate detection and dimension set creation. Extensibility: OnBeforeGetDimensionSetID and OnGetDimensionSetIDOnBeforeInsertTreeNode events for custom logic.
Properties
| Name | Value |
|---|---|
| Caption | Dimension Set Entry |
| DrillDownPageID | Page Microsoft.Finance.Dimension."Dimension Set Entries" |
| LookupPageID | Page Microsoft.Finance.Dimension."Dimension Set Entries" |
| Permissions | TableData "Dimension Set Entry" = rim, TableData "Dimension Set Tree Node" = rim |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Dimension Set ID" | Integer | Unique identifier linking multiple dimension entries into a single dimension set. |
| "Dimension Code" | Code[20] | Code identifying the dimension being specified (Department, Project, etc.). |
| "Dimension Value Code" | Code[20] | Specific value for the dimension (Sales, Marketing, Europe, etc.). |
| "Dimension Value ID" | Integer | Internal identifier for the dimension value used for optimized tree node operations. |
| "Dimension Name" | Text[30] | Display name of the dimension from the Dimension table. |
| "Dimension Value Name" | Text[50] | Display name of the dimension value from the Dimension Value table. |
| "Global Dimension No." | Integer | Shortcut dimension number (3-8) for this dimension if configured in General Ledger Setup. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |
Methods
GetDimensionSetID
Creates or retrieves the dimension set ID for a collection of dimension entries. Uses tree structure optimization to avoid duplicate dimension sets and improve performance.
procedure GetDimensionSetID(var DimSetEntry: Record "Dimension Set Entry"): IntegerParameters
| Name | Type | Description |
|---|---|---|
| DimSetEntry | Table Microsoft.Finance.Dimension."Dimension Set Entry" |
Collection of dimension entries to process into a dimension set |
Returns
| Type | Description |
|---|---|
| Integer |
Dimension set ID that uniquely identifies the dimension combination |
Remarks
Core engine for dimension set creation: checks for existing combinations before creating new sets. Integrates with Dimension Set Tree Node for optimized duplicate detection and storage.
UpdateGlobalDimensionNo
Updates the global dimension number for all entries with the specified dimension code. Used when changing shortcut dimension assignments in General Ledger Setup.
procedure UpdateGlobalDimensionNo(DimensionCode: Code[20]; GlobalDimensionNo: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| DimensionCode | Code[20] |
Dimension code to update |
| GlobalDimensionNo | Integer |
New global dimension number (3-8) |
GetGlobalDimNo
Determines the global dimension number (3-8) for the current dimension code. Returns the shortcut dimension number configured in General Ledger Setup.
procedure GetGlobalDimNo(): IntegerReturns
| Type | Description |
|---|---|
| Integer |
Global dimension number (3-8) or 0 if not configured as shortcut dimension |
Events
OnBeforeGetDimensionSetID
Integration event raised before starting dimension set ID creation or retrieval process. Enables custom preprocessing or validation of dimension entries before set processing.
[IntegrationEvent(False,False)]
local procedure OnBeforeGetDimensionSetID(var DimensionSetEntry: Record "Dimension Set Entry")Parameters
| Name | Type | Description |
|---|---|---|
| DimensionSetEntry | Table Microsoft.Finance.Dimension."Dimension Set Entry" |
Dimension entries being processed into a set |
OnGetDimensionSetIDOnBeforeInsertTreeNode
Integration event raised before inserting nodes into the dimension set tree structure. Enables custom logic during tree node creation and duplicate detection process.
[IntegrationEvent(False,False)]
local procedure OnGetDimensionSetIDOnBeforeInsertTreeNode(var DimensionSetEntry: Record "Dimension Set Entry"; var Found: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| DimensionSetEntry | Table Microsoft.Finance.Dimension."Dimension Set Entry" |
Current dimension entry being processed |
| Found | Boolean |
Whether matching tree node was found |
OnAfterGetGlobalDimNo
Integration event raised after determining global dimension number for a dimension code. Enables custom logic to assign global dimension numbers for dimensions not configured as shortcuts.
[IntegrationEvent(False,False)]
local procedure OnAfterGetGlobalDimNo(DimensionCode: Code[20]; var GlobalDimensionNo: Integer)Parameters
| Name | Type | Description |
|---|---|---|
| DimensionCode | Code[20] |
Dimension code being evaluated |
| GlobalDimensionNo | Integer |
Determined global dimension number |