Table 368 "Dimension Selection Buffer"

Base Application · Microsoft.Finance.Dimension · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 562 “Dimension Selection-Multiple” (1 Learn page), Page 564 “Dimension Selection-Level” (1), Page 567 “Dimension Selection-Change” (1), Page 568 “Dimension Selection” (1).

Properties

Property	Value
Caption	Dimension Selection Buffer
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Code Δ BC29	Text[30]	Specifies the code for the dimension.	DataClassification SystemMetadata
2	Description Δ BC29	Text[30]	Specifies a description of the dimension.	DataClassification SystemMetadata
3	Selected Δ BC29	Boolean	Specifies that this dimension will be included.	DataClassification SystemMetadata
4	New Dimension Value Code Δ BC29	Code[20]	Specifies the new dimension value to that you are changing to.	TableRelation Table 15 “G/L Account”, Table 220 “Business Unit”, Table 349 “Dimension Value” (if (Code = const(‘G/L Account’)) “G/L Account”.“No.” else if (Code = const(‘Business Unit’)) “Business Unit”.Code else “Dimension Value”.Code where(“Dimension Code” = field(Code), Blocked = const(false))); DataClassification SystemMetadata
5	Dimension Value Filter Δ BC29	Code[250]	Specifies the dimension value that the analysis view is based on.	TableRelation Table 15 “G/L Account”, Table 220 “Business Unit”, Table 840 “Cash Flow Forecast” (if (“Filter Lookup Table No.” = const(15)) “G/L Account”.“No.” else if (“Filter Lookup Table No.” = const(220)) “Business Unit”.Code else if (“Filter Lookup Table No.” = const(841)) “Cash Flow Account”.“No.” else if (“Filter Lookup Table No.” = const(840)) “Cash Flow Forecast”.“No.” else “Dimension …); DataClassification SystemMetadata
6	Level Δ BC29	Option	Specifies the level for the selected dimension.	OptionCaption: ,Level 1,Level 2,Level 3,Level 4; DataClassification SystemMetadata
7	Filter Lookup Table No.	Integer	—	not editable; DataClassification SystemMetadata

Keys

Key1: Code (clustered)
Key2: Level, Code

Events published

OnAfterSetDimSelectionChange(var DimensionSelectionBuffer: Record "Dimension Selection Buffer"; var TheDimSelectionBuf: Record "Dimension Selection Buffer" temporary) (integration): Integration event raised after completing dimension selection change operations. Provides extensibility for custom processing after dimension selection modifications.
OnBeforeInsertDimSelBufForDimSelectionChange(var DimSelectionChange: Page "Dimension Selection-Change"; Dimension: Record Dimension; ObjectType: Integer; ObjectID: Integer; var IsHandled: Boolean) (integration): Integration event raised before inserting dimension selection buffer records for dimension selection change operations. Allows custom validation and preprocessing before dimension buffer creation.
OnBeforeInsertDimSelBufForDimSelectionMultiple(var DimSelectionMultiple: Page "Dimension Selection-Multiple"; Dimension: Record Dimension; ObjectType: Integer; ObjectID: Integer; var IsHandled: Boolean) (integration): Integration event raised before inserting dimension selection buffer records for multiple dimension selection operations. Allows custom validation and preprocessing before dimension buffer creation in multiple selection scenarios.
OnCompareDimTextOnBeforeSelectedDimFind(var SelectedDimension: Record "Selected Dimension"; ObjectType: Integer; ObjectID: Integer) (integration): Integration event raised in CompareDimText before searching Selected Dimension records. Enables custom filtering and validation before dimension text comparison operations.
OnSetDimSelectionOnAfterSetDefaultRangeOnSelectedDimTable(var SelectedDimension: Record "Selected Dimension"; ObjectType: Integer; ObjectID: Integer) (integration): Integration event raised after setting default range on Selected Dimension table during SetDimSelection operations. Allows additional filtering and validation before dimension selection processing.
OnSetDimSelectionOnBeforeSelectedDimInsert(var SelectedDimension: Record "Selected Dimension"; ObjectType: Integer; ObjectID: Integer) (integration): Integration event raised before inserting Selected Dimension records during SetDimSelection operations. Enables custom validation and modification of dimension selection data before persistence.

Procedures

SetDimSelectionMultiple(ObjectType: Integer; ObjectID: Integer; var SelectedDimText: Text[250]): Opens dimension selection page for multiple dimension selection and updates the selected dimension text. Allows users to select multiple dimensions for analysis views and reporting scenarios.
SetDimSelectionChange(ObjectType: Integer; ObjectID: Integer; var SelectedDimText: Text[250]): Opens a dimension selection page allowing users to change dimension selections for a specific object. Updates the selected dimensions text based on user choices and commits changes to the selected dimensions table.
CompareDimText(ObjectType: Integer; ObjectID: Integer; AnalysisViewCode: Code[10]; SelectedDimText: Text[250]; DimTextFieldName: Text[100]): Compares current dimension selection text with stored dimension selections to ensure data consistency. Validates that the provided dimension text matches the dimensions stored in the Selected Dimension table.
SetDimSelection(ObjectType: Integer; ObjectID: Integer; AnalysisViewCode: Code[10]; var SelectedDimText: Text[250]; var DimSelectionBuf: Record "Dimension Selection Buffer"): Updates dimension selections for a specific object based on user choices from the dimension selection buffer. Replaces existing selections with new ones and updates the dimension text representation.
SetDimSelectionLevelGLAcc(ObjectType: Integer; ObjectID: Integer; AnalysisViewCode: Code[10]; var SelectedDimText: Text[250]): Sets dimension selection level for G/L Account based analysis with manual dimension selection. Provides G/L Account specific dimension management without automatic dimension assignment.
SetDimSelectionLevelGLAccAutoSet(ObjectType: Integer; ObjectID: Integer; AnalysisViewCode: Code[10]; var SelectedDimText: Text[250]): Sets dimension selection level for G/L Account based analysis with automatic dimension assignment. Provides G/L Account specific dimension management with automatic dimension selection based on analysis view configuration.
SetDimSelectionLevelCFAcc(ObjectType: Integer; ObjectID: Integer; AnalysisViewCode: Code[10]; var SelectedDimText: Text[250]): Sets dimension selection level for Cash Flow Account based analysis with manual dimension selection. Provides Cash Flow Account specific dimension management without automatic dimension assignment.
GetDimSelectionText(ObjectType: Integer; ObjectID: Integer; AnalysisViewCode: Code[10]): Text[250]: Retrieves the text representation of currently selected dimensions for a specific object and analysis view. Builds dimension code list from Selected Dimension table records.

Plus 5 local procedures.

Relations

Dimension Value Filter: TableRelation Table 15 “G/L Account” (conditional)
New Dimension Value Code: TableRelation Table 15 “G/L Account” (conditional)
Dimension Value Filter: TableRelation Table 220 “Business Unit” (conditional)
New Dimension Value Code: TableRelation Table 220 “Business Unit” (conditional)
New Dimension Value Code: TableRelation Table 349 “Dimension Value” (conditional)
Dimension Value Filter: TableRelation Table 840 “Cash Flow Forecast” (conditional)
Dimension Value Filter: TableRelation Table 841 “Cash Flow Account” (conditional)

Pages and codeunits on this table

Page 562 “Dimension Selection-Multiple” (source table)
Page 564 “Dimension Selection-Level” (source table)
Page 567 “Dimension Selection-Change” (source table)
Page 568 “Dimension Selection” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Dimension Selection Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.