Page 7157 Purch. Analysis by Dimensions

Base Application, Microsoft.Purchases.Analysis

src/Layers/W1/BaseApp/Purchases/Analysis/PurchAnalysisbyDimensions.Page.al824 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.Purchases.Analysis;using Microsoft.Finance.Analysis;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using Microsoft.Inventory.Analysis;using Microsoft.Inventory.Item;using Microsoft.Inventory.Location;using System.Text;using System.Utilities;page 7157 "Purch. Analysis by Dimensions"{    Caption = 'Purch. Analysis by Dimensions';    DataCaptionExpression = CurrentItemAnalysisViewCode;    DeleteAllowed = false;    InsertAllowed = false;    LinksAllowed = false;    ModifyAllowed = false;    PageType = Card;    SaveValues = true;    SourceTable = "Dimension Code Buffer";    layout    {        area(content)        {            group(General)            {                Caption = 'General';                field(CurrentItemAnalysisViewCode; CurrentItemAnalysisViewCode)                {                    ApplicationArea = Dimensions;                    Caption = 'Analysis View Code';                    ToolTip = 'Specifies the code for the analysis view that the filter belongs to.';                    trigger OnLookup(var Text: Text): Boolean                    begin                        ItemAnalysisMgt.LookupItemAnalysisView(                          CurrentAnalysisArea.AsInteger(), CurrentItemAnalysisViewCode, ItemAnalysisView, ItemStatisticsBuffer,                          Dim1Filter, Dim2Filter, Dim3Filter);                        ItemAnalysisMgt.SetLineAndColumnDim(                          ItemAnalysisView, LineDimCode, LineDimType, ColumnDimCode, ColumnDimType);                        UpdateFilterFields();                        CurrPage.Update(false);                    end;                    trigger OnValidate()                    begin                        ItemAnalysisMgt.CheckAnalysisView(CurrentAnalysisArea.AsInteger(), CurrentItemAnalysisViewCode, ItemAnalysisView);                        CurrentItemAnalysisViewCodeOnA();                    end;                }                field(LineDimCode; LineDimCode)                {                    ApplicationArea = Dimensions;                    Caption = 'Show as Lines';                    ToolTip = 'Specifies which values you want to show as lines in the window. This allows you to see the same matrix window from various perspectives, especially when you use both the Show as Lines field and the Show as Columns field.';                    trigger OnLookup(var Text: Text): Boolean                    var                        NewCode: Text[30];                    begin                        NewCode := ItemAnalysisMgt.GetDimSelection(LineDimCode, ItemAnalysisView);                        if NewCode <> LineDimCode then begin                            Text := NewCode;                            exit(true);                        end;                    end;                    trigger OnValidate()                    begin                        if (UpperCase(LineDimCode) = UpperCase(ColumnDimCode)) and (LineDimCode <> '') then begin                            ColumnDimCode := '';                            ItemAnalysisMgt.ValidateColumnDimTypeAndCode(                              ItemAnalysisView, ColumnDimCode, ColumnDimType, LineDimType,                              InternalDateFilter, DateFilter, ItemStatisticsBuffer, PeriodInitialized);                        end;                        ItemAnalysisMgt.ValidateLineDimTypeAndCode(                          ItemAnalysisView, LineDimCode, LineDimType, ColumnDimType,                          InternalDateFilter, DateFilter, ItemStatisticsBuffer, PeriodInitialized);                        if LineDimType = LineDimType::Period then                            Rec.SetCurrentKey("Period Start")                        else                            Rec.SetCurrentKey(Code);                        LineDimCodeOnAfterValidate();                    end;                }                field(ColumnDimCode; ColumnDimCode)                {                    ApplicationArea = Dimensions;                    Caption = 'Show as Columns';                    ToolTip = 'Specifies which values you want to show as columns in the window. This allows you to see the same matrix window from various perspectives, especially when you use both the Show as Lines field and the Show as Columns field.';                    trigger OnLookup(var Text: Text): Boolean                    var                        NewCode: Text[30];                    begin                        NewCode := ItemAnalysisMgt.GetDimSelection(ColumnDimCode, ItemAnalysisView);                        if NewCode <> ColumnDimCode then begin                            Text := NewCode;                            exit(true);                        end;                    end;                    trigger OnValidate()                    begin                        if (UpperCase(LineDimCode) = UpperCase(ColumnDimCode)) and (LineDimCode <> '') then begin                            LineDimCode := '';                            ItemAnalysisMgt.ValidateLineDimTypeAndCode(                              ItemAnalysisView, LineDimCode, LineDimType, ColumnDimType,                              InternalDateFilter, DateFilter, ItemStatisticsBuffer, PeriodInitialized);                        end;                        ItemAnalysisMgt.ValidateColumnDimTypeAndCode(                          ItemAnalysisView, ColumnDimCode, ColumnDimType, LineDimType,                          InternalDateFilter, DateFilter, ItemStatisticsBuffer, PeriodInitialized);                        GenerateColumnCaptions("Matrix Page Step Type"::Initial);                        ColumnDimCodeOnAfterValidate();                    end;                }                field(ValueType; ValueType)                {                    ApplicationArea = Dimensions;                    Caption = 'Show Value As';                    ToolTip = 'Specifies how data is shown in the analysis view.';                }            }            group(Filters)            {                Caption = 'Filters';                field(DateFilter; DateFilter)                {                    ApplicationArea = Dimensions;                    Caption = 'Date Filter';                    ToolTip = 'Specifies the dates that will be used to filter the amounts in the window.';                    trigger OnValidate()                    var                        FilterTokens: Codeunit "Filter Tokens";                    begin                        FilterTokens.MakeDateFilter(DateFilter);                        ItemStatisticsBuffer.SetFilter("Date Filter", DateFilter);                        DateFilter := ItemStatisticsBuffer.GetFilter("Date Filter");                        InternalDateFilter := DateFilter;                        GenerateColumnCaptions("Matrix Page Step Type"::Initial);                        DateFilterOnAfterValidate();                    end;                }                field(ItemFilter; ItemFilter)                {                    ApplicationArea = Dimensions;                    Caption = 'Item Filter';                    ToolTip = 'Specifies a filter to specify the items for which values will be shown in the matrix window.';                    trigger OnLookup(var Text: Text): Boolean                    var                        ItemList: Page "Item List";                    begin                        ItemList.LookupMode(true);                        if ItemList.RunModal() = ACTION::LookupOK then begin                            Text := ItemList.GetSelectionFilter();                            exit(true);                        end;                    end;                    trigger OnValidate()                    begin                        GenerateColumnCaptions("Matrix Page Step Type"::Initial);                        ItemFilterOnAfterValidate();                    end;                }                field(LocationFilter; LocationFilter)                {                    ApplicationArea = Location;                    Caption = 'Location Filter';                    ToolTip = 'Specifies the filter through which you want to analyze purchase entries.';                    trigger OnLookup(var Text: Text): Boolean                    var                        LocationList: Page "Location List";                    begin                        LocationList.LookupMode(true);                        if LocationList.RunModal() = ACTION::LookupOK then begin                            Text := LocationList.GetSelectionFilter();                            exit(true);                        end;                    end;                    trigger OnValidate()                    begin                        LocationFilterOnAfterValidate();                    end;                }                field(BudgetFilter; BudgetFilter)                {                    ApplicationArea = Dimensions;                    Caption = 'Budget Filter';                    ToolTip = 'Specifies the budget that information in the matrix is shown for.';                    trigger OnLookup(var Text: Text): Boolean                    var                        ItemBudgetName: Record "Item Budget Name";                    begin                        ItemBudgetName.FilterGroup := 2;                        ItemBudgetName.SetRange("Analysis Area", CurrentAnalysisArea);                        ItemBudgetName.FilterGroup := 0;                        if PAGE.RunModal(0, ItemBudgetName) = ACTION::LookupOK then begin                            Text := ItemBudgetName.Name;                            exit(true);                        end;                    end;                    trigger OnValidate()                    begin                        GenerateColumnCaptions("Matrix Page Step Type"::Initial);                        BudgetFilterOnAfterValidate();                    end;                }                field(Dim1FilterControl; Dim1Filter)                {                    ApplicationArea = Dimensions;                    CaptionClass = ItemAnalysisMgt.GetCaptionClass(1, ItemAnalysisView);                    Caption = 'Dimension 1 Filter';                    Enabled = Dim1FilterEnable;                    ToolTip = 'Specifies a filter for the Dimension 1 for which entries will be shown in the matrix window.';                    trigger OnLookup(var Text: Text): Boolean                    begin                        exit(ItemAnalysisMgt.LookUpDimFilter(ItemAnalysisView."Dimension 1 Code", Text));                    end;                    trigger OnValidate()                    begin                        ItemStatisticsBuffer.SetFilter("Dimension 1 Filter", Dim1Filter);                        GenerateColumnCaptions("Matrix Page Step Type"::Initial);                        Dim1FilterOnAfterValidate();                    end;                }                field(Dim2FilterControl; Dim2Filter)                {                    ApplicationArea = Dimensions;                    CaptionClass = ItemAnalysisMgt.GetCaptionClass(2, ItemAnalysisView);                    Caption = 'Dimension 2 Filter';                    Enabled = Dim2FilterEnable;                    ToolTip = 'Specifies a filter for the Dimension 2 for which entries will be shown in the matrix window.';                    trigger OnLookup(var Text: Text): Boolean                    begin                        exit(ItemAnalysisMgt.LookUpDimFilter(ItemAnalysisView."Dimension 2 Code", Text));                    end;                    trigger OnValidate()                    begin                        ItemStatisticsBuffer.SetFilter("Dimension 2 Filter", Dim2Filter);                        GenerateColumnCaptions("Matrix Page Step Type"::Initial);                        Dim2FilterOnAfterValidate();                    end;                }                field(Dim3FilterControl; Dim3Filter)                {                    ApplicationArea = Dimensions;                    CaptionClass = ItemAnalysisMgt.GetCaptionClass(3, ItemAnalysisView);                    Caption = 'Dimension 3 Filter';                    Enabled = Dim3FilterEnable;                    ToolTip = 'Specifies a filter for the Dimension 3 for which entries will be shown in the matrix window.';                    trigger OnLookup(var Text: Text): Boolean                    begin                        exit(ItemAnalysisMgt.LookUpDimFilter(ItemAnalysisView."Dimension 3 Code", Text));                    end;                    trigger OnValidate()                    begin                        ItemStatisticsBuffer.SetFilter("Dimension 3 Filter", Dim3Filter);                        GenerateColumnCaptions("Matrix Page Step Type"::Initial);                        Dim3FilterOnAfterValidate();                    end;                }            }            group(Options)            {                Caption = 'Options';                field(ShowActualBudget; ShowActualBudget)                {                    ApplicationArea = Dimensions;                    Caption = 'Show';                    ToolTip = 'Specifies if the selected value is shown in the window.';                }                field(RoundingFactor; RoundingFactor)                {                    ApplicationArea = Dimensions;                    Caption = 'Rounding Factor';                    ToolTip = 'Specifies the factor that is used to round the amounts.';                }                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                        ShowColumnNameOnAfterValidate();                    end;                }                field(ShowOppositeSign; ShowOppositeSign)                {                    ApplicationArea = Dimensions;                    Caption = 'Show Opposite Sign';                    MultiLine = true;                    ToolTip = 'Specifies whether to show debits as negative amounts (with minus signs) and credits as positive amounts in the matrix window.';                }            }            group("Matrix Options")            {                Caption = 'Matrix Options';                field(PeriodType; PeriodType)                {                    ApplicationArea = Dimensions;                    Caption = 'View by';                    ToolTip = 'Specifies by which period amounts are displayed.';                    trigger OnValidate()                    begin                        FindPeriod('');                        GenerateColumnCaptions("Matrix Page Step Type"::Initial);                    end;                }                field(ColumnSet; MATRIX_CaptionRange)                {                    ApplicationArea = Dimensions;                    Caption = 'Column Set';                    Editable = false;                    ToolTip = 'Specifies the range of values that are displayed in the matrix window, for example, the total period. To change the contents of the field, choose Next Set or Previous Set.';                }            }        }    }    actions    {        area(navigation)        {            group("&Actions")            {                Caption = '&Actions';                Image = "Action";                action("Reverse Lines and Columns")                {                    ApplicationArea = Dimensions;                    Caption = 'Reverse Lines and Columns';                    Image = Undo;                    ToolTip = 'Change the display of the matrix by inverting the values in the Show as Lines and Show as Columns fields.';                    trigger OnAction()                    var                        TempDimCode: Text[30];                    begin                        TempDimCode := ColumnDimCode;                        ColumnDimCode := LineDimCode;                        LineDimCode := TempDimCode;                        ItemAnalysisMgt.ValidateLineDimTypeAndCode(                          ItemAnalysisView, LineDimCode, LineDimType, ColumnDimType,                          InternalDateFilter, DateFilter, ItemStatisticsBuffer, PeriodInitialized);                        ItemAnalysisMgt.ValidateColumnDimTypeAndCode(                          ItemAnalysisView, ColumnDimCode, ColumnDimType, LineDimType,                          InternalDateFilter, DateFilter, ItemStatisticsBuffer, PeriodInitialized);                        GenerateColumnCaptions("Matrix Page Step Type"::Initial);                    end;                }            }        }        area(processing)        {            action(ShowMatrix)            {                ApplicationArea = Dimensions;                Caption = '&Show Matrix';                Image = ShowMatrix;                ToolTip = 'View the actual analysis report according to the selected filters and options.';                trigger OnAction()                begin                    Clear(PurchAnalysisByDimMatrix);                    ShowMatrixPage();                end;            }            action(PreviousSet)            {                ApplicationArea = Dimensions;                Caption = 'Previous Set';                Image = PreviousSet;                ToolTip = 'Go to the previous set of data.';                trigger OnAction()                begin                    GenerateColumnCaptions("Matrix Page Step Type"::Previous);                end;            }            action(NextSet)            {                ApplicationArea = Dimensions;                Caption = 'Next Set';                Image = NextSet;                ToolTip = 'Go to the next set of data.';                trigger OnAction()                begin                    GenerateColumnCaptions("Matrix Page Step Type"::Next);                end;            }        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process';                actionref(PreviousSet_Promoted; PreviousSet)                {                }                actionref(ShowMatrix_Promoted; ShowMatrix)                {                }                actionref(NextSet_Promoted; NextSet)                {                }                actionref("Reverse Lines and Columns_Promoted"; "Reverse Lines and Columns")                {                }            }        }    }    trigger OnFindRecord(Which: Text): Boolean    begin        exit(          ItemAnalysisMgt.FindRecord(            ItemAnalysisView, LineDimType, Rec, Which,            ItemFilter, LocationFilter, PeriodType, DateFilter, PeriodInitialized, InternalDateFilter,            Dim1Filter, Dim2Filter, Dim3Filter));    end;    trigger OnInit()    begin        Dim3FilterEnable := true;        Dim2FilterEnable := true;        Dim1FilterEnable := true;    end;    trigger OnNextRecord(Steps: Integer): Integer    begin        exit(          ItemAnalysisMgt.NextRecord(            ItemAnalysisView, LineDimType, Rec, Steps,            ItemFilter, LocationFilter, PeriodType, DateFilter,            Dim1Filter, Dim2Filter, Dim3Filter));    end;    trigger OnOpenPage()    begin        if ValueType = ValueType::"Sales Amount" then            ValueType := ValueType::"Cost Amount";        CurrentAnalysisArea := CurrentAnalysisArea::Purchase;        GLSetup.Get();        ItemAnalysisMgt.AnalysisViewSelection(          CurrentAnalysisArea.AsInteger(), CurrentItemAnalysisViewCode, ItemAnalysisView, ItemStatisticsBuffer,          Dim1Filter, Dim2Filter, Dim3Filter);        if (NewItemAnalysisCode <> '') and (NewItemAnalysisCode <> CurrentItemAnalysisViewCode) then begin            CurrentItemAnalysisViewCode := NewItemAnalysisCode;            ItemAnalysisMgt.CheckAnalysisView(CurrentAnalysisArea.AsInteger(), CurrentItemAnalysisViewCode, ItemAnalysisView);            ItemAnalysisMgt.SetItemAnalysisView(              CurrentAnalysisArea.AsInteger(), CurrentItemAnalysisViewCode, ItemAnalysisView, ItemStatisticsBuffer,              Dim1Filter, Dim2Filter, Dim3Filter);        end;        ItemAnalysisMgt.SetLineAndColumnDim(          ItemAnalysisView, LineDimCode, LineDimType, ColumnDimCode, ColumnDimType);        UpdateFilterFields();        FindPeriod('');        NoOfColumns := PurchAnalysisByDimMatrix.GetMatrixDimension();        GenerateColumnCaptions("Matrix Page Step Type"::Initial);    end;    var        GLSetup: Record "General Ledger Setup";        ItemAnalysisView: Record "Item Analysis View";        ItemStatisticsBuffer: Record "Item Statistics Buffer";        ItemAnalysisMgt: Codeunit "Item Analysis Management";        MatrixMgt: Codeunit "Matrix Management";        PurchAnalysisByDimMatrix: Page "Purch. Analysis by Dim Matrix";        CurrentItemAnalysisViewCode: Code[10];        CurrentAnalysisArea: Enum "Analysis Area Type";        ValueType: Enum "Item Analysis Value Type";        ShowActualBudget: Enum "Item Analysis Show Type";        RoundingFactor: Enum "Analysis Rounding Factor";        LineDimType: Enum "Item Analysis Dimension Type";        ColumnDimType: Enum "Item Analysis Dimension Type";        PeriodType: Enum "Analysis Period Type";        BudgetFilter: Code[250];        LineDimCode: Text[30];        ColumnDimCode: Text[30];        InternalDateFilter: Text[30];        MatrixColumnCaptions: array[32] of Text[80];        PeriodInitialized: Boolean;        ShowColumnName: Boolean;        ShowOppositeSign: Boolean;        DateFilter: Text[30];        Dim1Filter: Code[250];        Dim2Filter: Code[250];        Dim3Filter: Code[250];        ItemFilter: Code[250];        LocationFilter: Code[250];        FirstColumnDate: Date;        LastColumnDate: Date;        NoOfColumns: Integer;        MATRIX_PKFirstRecInCurrSet: Text;        MATRIX_CaptionRange: Text;        MATRIX_CodeRange: Text[250];        MATRIX_CurrSetLength: Integer;        NewItemAnalysisCode: Code[10];        Dim1FilterEnable: Boolean;        Dim2FilterEnable: Boolean;        Dim3FilterEnable: Boolean;    local procedure FindPeriod(SearchText: Code[3])    var        PeriodPageMgt: Codeunit PeriodPageManagement;    begin        PeriodPageMgt.FindPeriodOnMatrixPage(          DateFilter, InternalDateFilter, SearchText, PeriodType,          (LineDimType <> LineDimType::Period) and (ColumnDimType <> ColumnDimType::Period));    end;    local procedure RefreshInternalDateFilter()    var        Item: Record Item;    begin        Item.SetRange("Date Filter", FirstColumnDate, LastColumnDate);        if Item.GetRangeMin("Date Filter") = Item.GetRangeMax("Date Filter") then            Item.SetRange("Date Filter", Item.GetRangeMin("Date Filter"));        InternalDateFilter := CopyStr(Item.GetFilter("Date Filter"), 1, MaxStrLen(InternalDateFilter));    end;    local procedure UpdateFilterFields()    var        ItemAnalysisViewFilter: Record "Item Analysis View Filter";    begin        ItemFilter := ItemAnalysisView."Item Filter";        Dim1Filter := '';        Dim2Filter := '';        Dim3Filter := '';        Dim1FilterEnable := ItemAnalysisView."Dimension 1 Code" <> '';        Dim2FilterEnable := ItemAnalysisView."Dimension 2 Code" <> '';        Dim3FilterEnable := ItemAnalysisView."Dimension 3 Code" <> '';        if Dim1FilterEnable then            if ItemAnalysisViewFilter.Get(                 ItemAnalysisView."Analysis Area", ItemAnalysisView.Code, ItemAnalysisView."Dimension 1 Code")            then                Dim1Filter := ItemAnalysisViewFilter."Dimension Value Filter";        if Dim2FilterEnable then            if ItemAnalysisViewFilter.Get(                 ItemAnalysisView."Analysis Area", ItemAnalysisView.Code, ItemAnalysisView."Dimension 2 Code")            then                Dim2Filter := ItemAnalysisViewFilter."Dimension Value Filter";        if Dim3FilterEnable then            if ItemAnalysisViewFilter.Get(                 ItemAnalysisView."Analysis Area", ItemAnalysisView.Code, ItemAnalysisView."Dimension 3 Code")            then                Dim3Filter := ItemAnalysisViewFilter."Dimension Value Filter";        OnAfterUpdateFilterFields(ItemAnalysisView, Dim1Filter, Dim2Filter, Dim3Filter);    end;    local procedure GenerateColumnCaptions(StepType: Enum "Matrix Page Step Type")    var        MATRIX_PeriodRecords: array[32] of Record Date;    begin        case ColumnDimType of            ColumnDimType::Item:                SetPointsItem(StepType);            ColumnDimType::Location:                SetPointsLocation(StepType);            ColumnDimType::Period:                begin                    MatrixMgt.GeneratePeriodMatrixData(                        StepType.AsInteger(), NoOfColumns, ShowColumnName, PeriodType, DateFilter, MATRIX_PKFirstRecInCurrSet,                        MatrixColumnCaptions, MATRIX_CaptionRange, MATRIX_CurrSetLength, MATRIX_PeriodRecords);                    if MATRIX_CurrSetLength > 0 then begin                        FirstColumnDate := MATRIX_PeriodRecords[1]."Period Start";                        LastColumnDate := MATRIX_PeriodRecords[MATRIX_CurrSetLength]."Period Start";                    end;                    RefreshInternalDateFilter();                end;            ColumnDimType::"Dimension 1":                SetPointsDim(ItemAnalysisView."Dimension 1 Code", Dim1Filter, StepType);            ColumnDimType::"Dimension 2":                SetPointsDim(ItemAnalysisView."Dimension 2 Code", Dim2Filter, StepType);            ColumnDimType::"Dimension 3":                SetPointsDim(ItemAnalysisView."Dimension 3 Code", Dim3Filter, StepType);        end;    end;    local procedure SetPointsItem(StepType: Enum "Matrix Page Step Type")    var        Item: Record Item;        RecRef: RecordRef;        CaptionFieldNo: Integer;    begin        Clear(MatrixColumnCaptions);        Item.SetFilter("No.", ItemFilter);        RecRef.GetTable(Item);        RecRef.SetTable(Item);        if ShowColumnName then            CaptionFieldNo := Item.FieldNo(Description)        else            CaptionFieldNo := Item.FieldNo("No.");        MatrixMgt.GenerateMatrixData(            RecRef, StepType.AsInteger(), NoOfColumns, CaptionFieldNo, MATRIX_PKFirstRecInCurrSet, MatrixColumnCaptions,            MATRIX_CaptionRange, MATRIX_CurrSetLength);        if ShowColumnName then            MATRIX_CodeRange :=              MatrixMgt.GetPKRange(RecRef, Item.FieldNo("No."), MATRIX_PKFirstRecInCurrSet, MATRIX_CurrSetLength);    end;    local procedure SetPointsLocation(StepType: Enum "Matrix Page Step Type")    var        Location: Record Location;        RecRef: RecordRef;        CaptionFieldNo: Integer;    begin        Clear(MatrixColumnCaptions);        Location.SetFilter(Code, LocationFilter);        RecRef.GetTable(Location);        RecRef.SetTable(Location);        if ShowColumnName then            CaptionFieldNo := Location.FieldNo(Name)        else            CaptionFieldNo := Location.FieldNo(Code);        MatrixMgt.GenerateMatrixData(            RecRef, StepType.AsInteger(), NoOfColumns, CaptionFieldNo, MATRIX_PKFirstRecInCurrSet, MatrixColumnCaptions,            MATRIX_CaptionRange, MATRIX_CurrSetLength);        if ShowColumnName then            MATRIX_CodeRange :=              MatrixMgt.GetPKRange(RecRef, Location.FieldNo(Code), MATRIX_PKFirstRecInCurrSet, MATRIX_CurrSetLength);    end;    local procedure SetPointsDim(DimensionCode: Code[20]; DimFilter: Code[250]; StepType: Enum "Matrix Page Step Type")    var        DimVal: Record "Dimension Value";        MatrixMgt: Codeunit "Matrix Management";        RecRef: RecordRef;        CaptionFieldNo: Integer;    begin        Clear(MatrixColumnCaptions);        DimVal.SetRange("Dimension Code", DimensionCode);        if DimFilter <> '' then            DimVal.SetFilter(Code, DimFilter);        RecRef.GetTable(DimVal);        RecRef.SetTable(DimVal);        if ShowColumnName then            CaptionFieldNo := DimVal.FieldNo(Name)        else            CaptionFieldNo := DimVal.FieldNo(Code);        MatrixMgt.GenerateMatrixData(            RecRef, StepType.AsInteger(), NoOfColumns, CaptionFieldNo, MATRIX_PKFirstRecInCurrSet, MatrixColumnCaptions,            MATRIX_CaptionRange, MATRIX_CurrSetLength);        if ShowColumnName then            MATRIX_CodeRange :=              MatrixMgt.GetPKRange(RecRef, DimVal.FieldNo(Code), MATRIX_PKFirstRecInCurrSet, MATRIX_CurrSetLength);    end;    local procedure ShowMatrixPage()    var        CurItemFilter: Text[250];        CurLocationFilter: Text[250];        CurDim1Filter: Text[250];        CurDim2Filter: Text[250];        CurDim3Filter: Text[250];    begin        case ColumnDimType of            ColumnDimType::Item:                CurItemFilter := MATRIX_CodeRange;            ColumnDimType::Location:                CurLocationFilter := MATRIX_CodeRange;            ColumnDimType::"Dimension 1":                CurDim1Filter := MATRIX_CodeRange;            ColumnDimType::"Dimension 2":                CurDim2Filter := MATRIX_CodeRange;            ColumnDimType::"Dimension 3":                CurDim3Filter := MATRIX_CodeRange;            ColumnDimType::Period:                PeriodInitialized := true;        end;        if CurItemFilter = '' then            CurItemFilter := ItemFilter;        if CurLocationFilter = '' then            CurLocationFilter := LocationFilter;        if CurDim1Filter = '' then            CurDim1Filter := Dim1Filter;        if CurDim2Filter = '' then            CurDim2Filter := Dim2Filter;        if CurDim3Filter = '' then            CurDim3Filter := Dim3Filter;        PurchAnalysisByDimMatrix.LoadMartix(            ItemAnalysisView, CurrentItemAnalysisViewCode, CurrentAnalysisArea,            LineDimType, ColumnDimType, PeriodType, ValueType,            RoundingFactor, ShowActualBudget, MatrixColumnCaptions,            ShowOppositeSign, PeriodInitialized, ShowColumnName, MATRIX_CurrSetLength);        PurchAnalysisByDimMatrix.LoadFilters(            CurItemFilter, CurLocationFilter, CurDim1Filter, CurDim2Filter, CurDim3Filter,            DateFilter, BudgetFilter, InternalDateFilter);        PurchAnalysisByDimMatrix.RunModal();    end;    procedure SetCurrentAnalysisViewCode(NewAnalysisViewCode: Code[10])    begin        NewItemAnalysisCode := NewAnalysisViewCode;    end;    local procedure CurrentItemAnalysisViewCodeOnA()    begin        ItemAnalysisMgt.SetItemAnalysisView(          CurrentAnalysisArea.AsInteger(), CurrentItemAnalysisViewCode, ItemAnalysisView, ItemStatisticsBuffer,          Dim1Filter, Dim2Filter, Dim3Filter);        ItemAnalysisMgt.SetLineAndColumnDim(          ItemAnalysisView, LineDimCode, LineDimType, ColumnDimCode, ColumnDimType);        UpdateFilterFields();        CurrPage.Update(false);    end;    local procedure LineDimCodeOnAfterValidate()    begin        CurrPage.Update(false);    end;    local procedure ColumnDimCodeOnAfterValidate()    begin        CurrPage.Update(false);    end;    local procedure Dim2FilterOnAfterValidate()    begin        CurrPage.Update();        GenerateColumnCaptions("Matrix Page Step Type"::Initial);    end;    local procedure Dim1FilterOnAfterValidate()    begin        CurrPage.Update();        GenerateColumnCaptions("Matrix Page Step Type"::Initial);    end;    local procedure Dim3FilterOnAfterValidate()    begin        CurrPage.Update();        GenerateColumnCaptions("Matrix Page Step Type"::Initial);    end;    local procedure ItemFilterOnAfterValidate()    begin        ItemStatisticsBuffer.SetFilter("Item Filter", ItemFilter);        CurrPage.Update(false);        GenerateColumnCaptions("Matrix Page Step Type"::Initial);    end;    local procedure LocationFilterOnAfterValidate()    begin        ItemStatisticsBuffer.SetFilter("Location Filter", LocationFilter);        CurrPage.Update(false);        GenerateColumnCaptions("Matrix Page Step Type"::Initial);    end;    local procedure BudgetFilterOnAfterValidate()    begin        ItemStatisticsBuffer.SetFilter("Budget Filter", BudgetFilter);        CurrPage.Update(false);    end;    local procedure DateFilterOnAfterValidate()    begin        CurrPage.Update();    end;    local procedure ShowColumnNameOnAfterValidate()    begin        GenerateColumnCaptions("Matrix Page Step Type"::Same);    end;    [IntegrationEvent(false, false)]    local procedure OnAfterUpdateFilterFields(ItemAnalysisView: Record "Item Analysis View"; var Dim1Filter: Code[250]; var Dim2Filter: Code[250]; var Dim3Filter: Code[250])    begin    end;}