Page 538 Dimension Combinations
src/Layers/W1/BaseApp/Finance/Dimension/DimensionCombinations.Page.al228 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Finance.Dimension;using Microsoft.Finance.Analysis;using Microsoft.Foundation.Enums;/// <summary>/// Matrix page for managing dimension combination restrictions across all dimension pairs./// Provides visual matrix interface for setting Limited or Blocked restrictions on dimension combinations./// </summary>/// <remarks>/// Displays dimensions in both row and column headers with combination restrictions at intersections./// Supports drill-down to specific dimension value combinations for detailed restriction setup./// Essential tool for dimension validation configuration and business rule enforcement./// </remarks>page 538 "Dimension Combinations"{ ApplicationArea = Dimensions; Caption = 'Dimension Combinations'; DataCaptionExpression = ''; DeleteAllowed = false; InsertAllowed = false; LinksAllowed = false; PageType = Card; SaveValues = true; SourceTable = Dimension; UsageCategory = Administration; AboutTitle = 'About Dimension Combinations'; AboutText = 'To avoid posting entries with contradictory or irrelevant dimensions, you can block or limit specific combinations of two dimensions. A blocked dimension combination means you can''t post both dimensions on the same entry regardless of what the dimension values are. In contrast, a limited dimension combination means you can post both dimensions to the same entry, but only for certain combinations of dimension values.'; layout { area(content) { group(General) { Caption = 'General'; field(ShowColumnName; ShowColumnName) { ApplicationArea = Dimensions; Caption = 'Show Column Name'; ToolTip = 'Specifies that the names of columns are shown in the matrix window.'; trigger OnValidate() begin ShowColumnNameOnPush(); ShowColumnNameOnAfterValidate(); end; } } part(MatrixForm; "Dimension Combinations Matrix") { ApplicationArea = Dimensions; } } } actions { area(processing) { action("Previous Set") { ApplicationArea = Dimensions; Caption = 'Previous Set'; Image = PreviousSet; ToolTip = 'Go to the previous set of data.'; trigger OnAction() begin // SetPoints(Direction::Backward); GenerateColumnCaptions("Matrix Page Step Type"::Previous); UpdateMatrixSubform(); end; } action("Previous Column") { ApplicationArea = Dimensions; Caption = 'Previous Column'; Image = PreviousRecord; ToolTip = 'Go to the previous column.'; trigger OnAction() begin // SetPoints(Direction::Backward); GenerateColumnCaptions("Matrix Page Step Type"::PreviousColumn); UpdateMatrixSubform(); end; } action("Next Column") { ApplicationArea = Dimensions; Caption = 'Next Column'; Image = NextRecord; ToolTip = 'Go to the next column.'; trigger OnAction() begin // SetPoints(Direction::Forward); GenerateColumnCaptions("Matrix Page Step Type"::NextColumn); UpdateMatrixSubform(); end; } action("Next Set") { ApplicationArea = Dimensions; Caption = 'Next Set'; Image = NextSet; ToolTip = 'Go to the next set of data.'; trigger OnAction() begin // SetPoints(Direction::Forward); GenerateColumnCaptions("Matrix Page Step Type"::Next); UpdateMatrixSubform(); end; } } area(Promoted) { group(Category_Process) { Caption = 'Process'; actionref("Previous Set_Promoted"; "Previous Set") { } actionref("Previous Column_Promoted"; "Previous Column") { } actionref("Next Column_Promoted"; "Next Column") { } actionref("Next Set_Promoted"; "Next Set") { } } } } trigger OnAfterGetRecord() begin Rec.Name := Rec.GetMLName(GlobalLanguage); end; trigger OnOpenPage() begin MaximumNoOfCaptions := ArrayLen(MATRIX_CaptionSet); GenerateColumnCaptions("Matrix Page Step Type"::Initial); UpdateMatrixSubform(); end; var MatrixRecords: array[32] of Record Dimension; MatrixRecord: Record Dimension; SelectedDimensionCombination: Record "Dimension Combination"; MatrixMgm: Codeunit "Matrix Management"; MATRIX_CaptionSet: array[32] of Text[80]; MATRIX_ColumnSet: Text; MATRIX_CaptionFieldNo: Integer; ShowColumnName: Boolean; MaximumNoOfCaptions: Integer; PrimaryKeyFirstCaptionInCurrSe: Text; MATRIX_CurrSetLength: Integer; NoDimensionsErr: Label 'No dimensions are available in the database.'; local procedure GenerateColumnCaptions(StepType: Enum "Matrix Page Step Type") var RecRef: RecordRef; CurrentMatrixRecordOrdinal: Integer; begin if SelectedDimensionCombination."Dimension 2 Code" <> '' then MatrixRecord.SetRange(Code, SelectedDimensionCombination."Dimension 2 Code"); RecRef.GetTable(MatrixRecord); if RecRef.IsEmpty() then Error(NoDimensionsErr); if ShowColumnName then MATRIX_CaptionFieldNo := 2 else MATRIX_CaptionFieldNo := 1; MatrixMgm.GenerateMatrixData(RecRef, StepType.AsInteger(), MaximumNoOfCaptions, MATRIX_CaptionFieldNo, PrimaryKeyFirstCaptionInCurrSe, MATRIX_CaptionSet, MATRIX_ColumnSet, MATRIX_CurrSetLength); Clear(MatrixRecords); MatrixRecord.SetPosition(PrimaryKeyFirstCaptionInCurrSe); CurrentMatrixRecordOrdinal := 1; repeat MatrixRecords[CurrentMatrixRecordOrdinal].Copy(MatrixRecord); CurrentMatrixRecordOrdinal := CurrentMatrixRecordOrdinal + 1; until (CurrentMatrixRecordOrdinal = ArrayLen(MatrixRecords)) or (MatrixRecord.Next() <> 1); end; local procedure UpdateMatrixSubform() begin CurrPage.MatrixForm.PAGE.SetSelectedDimCode(SelectedDimensionCombination."Dimension 1 Code"); CurrPage.MatrixForm.PAGE.Load(MATRIX_CaptionSet, MatrixRecords, ShowColumnName); CurrPage.Update(false); end; /// <summary> /// Sets the selected dimension combination record for page initialization and context. /// Used to position the page matrix on a specific dimension combination for focused editing. /// </summary> /// <param name="DimensionCombination">Dimension combination record to select and display</param> procedure SetSelectedRecord(DimensionCombination: Record "Dimension Combination") begin SelectedDimensionCombination := DimensionCombination; end; local procedure ShowColumnNameOnAfterValidate() begin UpdateMatrixSubform(); end; local procedure ShowColumnNameOnPush() begin GenerateColumnCaptions("Matrix Page Step Type"::Same); UpdateMatrixSubform(); end;}