Page 9253 Dim. Value Combinations Matrix, source in 29
Source29
src/Layers/W1/BaseApp/Finance/Dimension/DimValueCombinationsMatrix.Page.al679 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;
/// <summary>
/// Matrix page displaying dimension value combinations and their restrictions in a grid format.
/// Provides visual representation of allowed and blocked dimension value combinations for analysis and configuration.
/// </summary>
page 9253 "Dim. Value Combinations Matrix"
{
Caption = 'Dimension Value Combinations Matrix';
DataCaptionExpression = '';
Editable = false;
LinksAllowed = false;
PageType = ListPart;
SourceTable = "Dimension Value";
layout
{
area(content)
{
repeater(Control1)
{
ShowCaption = false;
field("Code"; Rec.Code)
{
ApplicationArea = Dimensions;
}
field(Name; Rec.Name)
{
ApplicationArea = Dimensions;
}
field(Field1; MATRIX_CellData[1])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[1];
Visible = Field1Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(1);
end;
}
field(Field2; MATRIX_CellData[2])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[2];
Visible = Field2Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(2);
end;
}
field(Field3; MATRIX_CellData[3])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[3];
Visible = Field3Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(3);
end;
}
field(Field4; MATRIX_CellData[4])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[4];
Visible = Field4Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(4);
end;
}
field(Field5; MATRIX_CellData[5])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[5];
Visible = Field5Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(5);
end;
}
field(Field6; MATRIX_CellData[6])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[6];
Visible = Field6Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(6);
end;
}
field(Field7; MATRIX_CellData[7])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[7];
Visible = Field7Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(7);
end;
}
field(Field8; MATRIX_CellData[8])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[8];
Visible = Field8Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(8);
end;
}
field(Field9; MATRIX_CellData[9])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[9];
Visible = Field9Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(9);
end;
}
field(Field10; MATRIX_CellData[10])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[10];
Visible = Field10Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(10);
end;
}
field(Field11; MATRIX_CellData[11])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[11];
Visible = Field11Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(11);
end;
}
field(Field12; MATRIX_CellData[12])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[12];
Visible = Field12Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(12);
end;
}
field(Field13; MATRIX_CellData[13])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[13];
Visible = Field13Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(13);
end;
}
field(Field14; MATRIX_CellData[14])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[14];
Visible = Field14Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(14);
end;
}
field(Field15; MATRIX_CellData[15])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[15];
Visible = Field15Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(15);
end;
}
field(Field16; MATRIX_CellData[16])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[16];
Visible = Field16Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(16);
end;
}
field(Field17; MATRIX_CellData[17])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[17];
Visible = Field17Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(17);
end;
}
field(Field18; MATRIX_CellData[18])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[18];
Visible = Field18Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(18);
end;
}
field(Field19; MATRIX_CellData[19])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[19];
Visible = Field19Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(19);
end;
}
field(Field20; MATRIX_CellData[20])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[20];
Visible = Field20Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(20);
end;
}
field(Field21; MATRIX_CellData[21])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[21];
Visible = Field21Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(21);
end;
}
field(Field22; MATRIX_CellData[22])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[22];
Visible = Field22Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(22);
end;
}
field(Field23; MATRIX_CellData[23])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[23];
Visible = Field23Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(23);
end;
}
field(Field24; MATRIX_CellData[24])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[24];
Visible = Field24Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(24);
end;
}
field(Field25; MATRIX_CellData[25])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[25];
Visible = Field25Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(25);
end;
}
field(Field26; MATRIX_CellData[26])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[26];
Visible = Field26Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(26);
end;
}
field(Field27; MATRIX_CellData[27])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[27];
Visible = Field27Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(27);
end;
}
field(Field28; MATRIX_CellData[28])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[28];
Visible = Field28Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(28);
end;
}
field(Field29; MATRIX_CellData[29])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[29];
Visible = Field29Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(29);
end;
}
field(Field30; MATRIX_CellData[30])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[30];
Visible = Field30Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(30);
end;
}
field(Field31; MATRIX_CellData[31])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[31];
Visible = Field31Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(31);
end;
}
field(Field32; MATRIX_CellData[32])
{
ApplicationArea = All;
CaptionClass = '3,' + MATRIX_ColumnCaption[32];
Visible = Field32Visible;
trigger OnAssistEdit()
begin
MatrixOnAssistEdit(32);
end;
}
}
}
}
actions
{
}
trigger OnAfterGetRecord()
var
MATRIX_CurrentColumnOrdinal: Integer;
begin
MATRIX_CurrentColumnOrdinal := 0;
while MATRIX_CurrentColumnOrdinal < MATRIX_CurrentNoOfMatrixColumn do begin
MATRIX_CurrentColumnOrdinal := MATRIX_CurrentColumnOrdinal + 1;
MATRIX_OnAfterGetRecord(MATRIX_CurrentColumnOrdinal);
end;
end;
trigger OnInit()
begin
Field32Visible := true;
Field31Visible := true;
Field30Visible := true;
Field29Visible := true;
Field28Visible := true;
Field27Visible := true;
Field26Visible := true;
Field25Visible := true;
Field24Visible := true;
Field23Visible := true;
Field22Visible := true;
Field21Visible := true;
Field20Visible := true;
Field19Visible := true;
Field18Visible := true;
Field17Visible := true;
Field16Visible := true;
Field15Visible := true;
Field14Visible := true;
Field13Visible := true;
Field12Visible := true;
Field11Visible := true;
Field10Visible := true;
Field9Visible := true;
Field8Visible := true;
Field7Visible := true;
Field6Visible := true;
Field5Visible := true;
Field4Visible := true;
Field3Visible := true;
Field2Visible := true;
Field1Visible := true;
end;
trigger OnOpenPage()
begin
SetColumnVisibility();
Rec.FilterGroup(2);
Rec.SetRange("Dimension Code", Row);
Rec.FilterGroup(0);
if SelectedDimValueCode <> '' then
Rec.SetRange(Code, SelectedDimValueCode);
end;
var
DimValueComb: Record "Dimension Value Combination";
MatrixRecords: array[32] of Record "Dimension Value";
CombRestriction: Option " ",Blocked;
MATRIX_CurrentNoOfMatrixColumn: Integer;
MATRIX_CellData: array[32] of Text[1024];
MATRIX_ColumnCaption: array[32] of Text[1024];
#pragma warning disable AA0074
Text000: Label 'Open,Blocked';
#pragma warning restore AA0074
Row: Code[20];
SelectedDimValueCode: Code[20];
Field1Visible: Boolean;
Field2Visible: Boolean;
Field3Visible: Boolean;
Field4Visible: Boolean;
Field5Visible: Boolean;
Field6Visible: Boolean;
Field7Visible: Boolean;
Field8Visible: Boolean;
Field9Visible: Boolean;
Field10Visible: Boolean;
Field11Visible: Boolean;
Field12Visible: Boolean;
Field13Visible: Boolean;
Field14Visible: Boolean;
Field15Visible: Boolean;
Field16Visible: Boolean;
Field17Visible: Boolean;
Field18Visible: Boolean;
Field19Visible: Boolean;
Field20Visible: Boolean;
Field21Visible: Boolean;
Field22Visible: Boolean;
Field23Visible: Boolean;
Field24Visible: Boolean;
Field25Visible: Boolean;
Field26Visible: Boolean;
Field27Visible: Boolean;
Field28Visible: Boolean;
Field29Visible: Boolean;
Field30Visible: Boolean;
Field31Visible: Boolean;
Field32Visible: Boolean;
/// <summary>
/// Sets the selected dimension value code for matrix row filtering.
/// </summary>
/// <param name="DimValueCode">Dimension value code to set as selected</param>
procedure SetSelectedDimValue(DimValueCode: Code[20])
begin
SelectedDimValueCode := DimValueCode;
end;
/// <summary>
/// Loads dimension value combination matrix data with column headers and dimension restrictions.
/// Populates the matrix cells with combination restriction indicators for visual display.
/// </summary>
/// <param name="MatrixColumns1">Array of column header texts for the matrix display</param>
/// <param name="MatrixRecords1">Array of dimension value records corresponding to matrix columns</param>
/// <param name="_Row">Row dimension value code being displayed</param>
/// <param name="CurrentNoOfMatrixColumn">Number of active matrix columns to display</param>
procedure Load(MatrixColumns1: array[32] of Text[1024]; var MatrixRecords1: array[32] of Record "Dimension Value"; _Row: Code[20]; CurrentNoOfMatrixColumn: Integer)
var
IsHandled: Boolean;
begin
IsHandled := false;
OnBeforeLoad(MatrixColumns1, MatrixRecords1, _Row, CurrentNoOfMatrixColumn, IsHandled);
if IsHandled then
exit;
CopyArray(MATRIX_ColumnCaption, MatrixColumns1, 1);
CopyArray(MatrixRecords, MatrixRecords1, 1);
MATRIX_CurrentNoOfMatrixColumn := CurrentNoOfMatrixColumn;
Row := _Row;
SetColumnVisibility();
end;
local procedure MatrixOnAssistEdit(ColumnID: Integer)
var
DimLimVal: Integer;
NewDimLimVal: Integer;
Dim1Code: Code[20];
Dim1ValueCode: Code[20];
Dim2Code: Code[20];
Dim2ValueCode: Code[20];
begin
if Rec."Dimension Code" > MatrixRecords[ColumnID]."Dimension Code" then begin
Dim1Code := MatrixRecords[ColumnID]."Dimension Code";
Dim1ValueCode := MatrixRecords[ColumnID].Code;
Dim2Code := Rec."Dimension Code";
Dim2ValueCode := Rec.Code;
end else begin
Dim1Code := Rec."Dimension Code";
Dim1ValueCode := Rec.Code;
Dim2Code := MatrixRecords[ColumnID]."Dimension Code";
Dim2ValueCode := MatrixRecords[ColumnID].Code;
end;
CombRestriction := CombRestriction::Blocked;
if not DimValueComb.Get(Dim1Code, Dim1ValueCode, Dim2Code, Dim2ValueCode) then
if not DimValueComb.Get(Dim2Code, Dim2ValueCode, Dim1Code, Dim1ValueCode) then
CombRestriction := CombRestriction::" ";
DimLimVal := CombRestriction + 1;
NewDimLimVal := StrMenu(Text000, DimLimVal);
if DimLimVal <> NewDimLimVal then begin
CombRestriction := NewDimLimVal - 1;
ChangeCombRestriction(Dim1Code, Dim1ValueCode, Dim2Code, Dim2ValueCode);
end;
end;
local procedure MATRIX_OnAfterGetRecord(ColumnID: Integer)
begin
ShowCombRestriction(ColumnID);
if CombRestriction = CombRestriction::" " then
MATRIX_CellData[ColumnID] := ''
else
MATRIX_CellData[ColumnID] := SelectStr(CombRestriction + 1, Text000);
end;
local procedure ShowCombRestriction(ColumnID: Integer)
var
Dim1Code: Code[20];
Dim1ValueCode: Code[20];
Dim2Code: Code[20];
Dim2ValueCode: Code[20];
begin
if Rec."Dimension Code" > MatrixRecords[ColumnID]."Dimension Code" then begin
Dim1Code := MatrixRecords[ColumnID]."Dimension Code";
Dim1ValueCode := MatrixRecords[ColumnID].Code;
Dim2Code := Rec."Dimension Code";
Dim2ValueCode := Rec.Code;
end else begin
Dim1Code := Rec."Dimension Code";
Dim1ValueCode := Rec.Code;
Dim2Code := MatrixRecords[ColumnID]."Dimension Code";
Dim2ValueCode := MatrixRecords[ColumnID].Code;
end;
if not DimValueComb.Get(Dim1Code, Dim1ValueCode, Dim2Code, Dim2ValueCode) then
if not DimValueComb.Get(Dim2Code, Dim2ValueCode, Dim1Code, Dim1ValueCode) then begin
DimValueComb.Init();
DimValueComb."Dimension 1 Code" := Dim1Code;
DimValueComb."Dimension 1 Value Code" := Dim1ValueCode;
DimValueComb."Dimension 2 Code" := Dim2Code;
DimValueComb."Dimension 2 Value Code" := Dim2ValueCode;
CombRestriction := CombRestriction::" ";
exit;
end;
CombRestriction := CombRestriction::Blocked;
end;
local procedure ChangeCombRestriction(Dim1Code: Code[20]; Dim1ValueCode: Code[20]; Dim2Code: Code[20]; Dim2ValueCode: Code[20])
begin
if not DimValueComb.Get(Dim1Code, Dim1ValueCode, Dim2Code, Dim2ValueCode) then
if not DimValueComb.Get(Dim2Code, Dim2ValueCode, Dim1Code, Dim1ValueCode) then
if CombRestriction = CombRestriction::Blocked then begin
DimValueComb."Dimension 1 Code" := Dim1Code;
DimValueComb."Dimension 2 Code" := Dim2Code;
DimValueComb."Dimension 1 Value Code" := Dim1ValueCode;
DimValueComb."Dimension 2 Value Code" := Dim2ValueCode;
DimValueComb.Insert(true);
exit;
end;
if CombRestriction = CombRestriction::" " then
DimValueComb.Delete(true);
end;
/// <summary>
/// Sets the visibility of matrix columns based on the current number of active columns.
/// Controls which matrix fields are displayed to optimize page performance and layout.
/// </summary>
procedure SetColumnVisibility()
begin
Field1Visible := MATRIX_CurrentNoOfMatrixColumn >= 1;
Field2Visible := MATRIX_CurrentNoOfMatrixColumn >= 2;
Field3Visible := MATRIX_CurrentNoOfMatrixColumn >= 3;
Field4Visible := MATRIX_CurrentNoOfMatrixColumn >= 4;
Field5Visible := MATRIX_CurrentNoOfMatrixColumn >= 5;
Field6Visible := MATRIX_CurrentNoOfMatrixColumn >= 6;
Field7Visible := MATRIX_CurrentNoOfMatrixColumn >= 7;
Field8Visible := MATRIX_CurrentNoOfMatrixColumn >= 8;
Field9Visible := MATRIX_CurrentNoOfMatrixColumn >= 9;
Field10Visible := MATRIX_CurrentNoOfMatrixColumn >= 10;
Field11Visible := MATRIX_CurrentNoOfMatrixColumn >= 11;
Field12Visible := MATRIX_CurrentNoOfMatrixColumn >= 12;
Field13Visible := MATRIX_CurrentNoOfMatrixColumn >= 13;
Field14Visible := MATRIX_CurrentNoOfMatrixColumn >= 14;
Field15Visible := MATRIX_CurrentNoOfMatrixColumn >= 15;
Field16Visible := MATRIX_CurrentNoOfMatrixColumn >= 16;
Field17Visible := MATRIX_CurrentNoOfMatrixColumn >= 17;
Field18Visible := MATRIX_CurrentNoOfMatrixColumn >= 18;
Field19Visible := MATRIX_CurrentNoOfMatrixColumn >= 19;
Field20Visible := MATRIX_CurrentNoOfMatrixColumn >= 20;
Field21Visible := MATRIX_CurrentNoOfMatrixColumn >= 21;
Field22Visible := MATRIX_CurrentNoOfMatrixColumn >= 22;
Field23Visible := MATRIX_CurrentNoOfMatrixColumn >= 23;
Field24Visible := MATRIX_CurrentNoOfMatrixColumn >= 24;
Field25Visible := MATRIX_CurrentNoOfMatrixColumn >= 25;
Field26Visible := MATRIX_CurrentNoOfMatrixColumn >= 26;
Field27Visible := MATRIX_CurrentNoOfMatrixColumn >= 27;
Field28Visible := MATRIX_CurrentNoOfMatrixColumn >= 28;
Field29Visible := MATRIX_CurrentNoOfMatrixColumn >= 29;
Field30Visible := MATRIX_CurrentNoOfMatrixColumn >= 30;
Field31Visible := MATRIX_CurrentNoOfMatrixColumn >= 31;
Field32Visible := MATRIX_CurrentNoOfMatrixColumn >= 32;
end;
/// <summary>
/// Integration event raised before loading matrix data to enable custom matrix loading logic.
/// Allows modification of matrix parameters and handling before standard matrix population occurs.
/// </summary>
/// <param name="MatrixColumns1">Array of column header texts for the matrix</param>
/// <param name="MatrixRecords1">Array of dimension value records for matrix columns</param>
/// <param name="_Row">Row dimension value code being processed</param>
/// <param name="CurrentNoOfMatrixColumn">Number of active matrix columns</param>
/// <param name="IsHandled">Set to true to skip standard matrix loading</param>
[IntegrationEvent(false, false)]
local procedure OnBeforeLoad(MatrixColumns1: array[32] of Text[1024]; var MatrixRecords1: array[32] of Record "Dimension Value"; _Row: Code[20]; CurrentNoOfMatrixColumn: Integer; var IsHandled: Boolean)
begin
end;
}