Page 554 Analysis by Dimensions

Base Application, Microsoft.Finance.Analysis

src/Layers/W1/BaseApp/Finance/Analysis/AnalysisbyDimensions.Page.al1,481 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.Analysis;using Microsoft.CashFlow.Account;using Microsoft.CashFlow.Forecast;using Microsoft.Finance.Consolidation;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Budget;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.Enums;using Microsoft.Foundation.Period;using System.Reflection;using System.Text;using System.Utilities;/// <summary>/// Interactive analysis page providing multi-dimensional financial data analysis with matrix display capabilities./// Supports G/L account and cash flow analysis with flexible dimension filtering and period-based reporting./// </summary>/// <remarks>/// Primary interface for analysis by dimensions functionality with configurable rows, columns, and filters./// Integrates with Analysis View setup for dimension definitions and supports both actual and budget analysis./// Matrix navigation enables period-based analysis with various rounding and display options./// </remarks>page 554 "Analysis by Dimensions"{    Caption = 'Analysis by Dimensions';    DeleteAllowed = false;    InsertAllowed = false;    LinksAllowed = false;    PageType = Card;    SaveValues = true;    SourceTable = "Analysis by Dim. Parameters";    SourceTableTemporary = true;    layout    {        area(content)        {            group(General)            {                Caption = 'General';                field(AnalysisViewCode; Rec."Analysis View Code")                {                    ApplicationArea = Dimensions;                    Caption = 'Analysis View Code';                    TableRelation = "Analysis View";                    Editable = false;                }                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 := GetDimSelection(LineDimCode);                        if NewCode = LineDimCode then                            exit(false);                        Text := NewCode;                        LineDimCode := NewCode;                        ValidateLineDimCode();                        exit(true);                    end;                    trigger OnValidate()                    begin                        if (UpperCase(LineDimCode) = UpperCase(ColumnDimCode)) and (LineDimCode <> '') then begin                            ColumnDimCode := '';                            ValidateColumnDimCode();                        end;                        ValidateLineDimCode();                        if Rec."Line Dim Option" = Rec."Line Dim Option"::Period then                            TempDimensionCodeBuffer.SetCurrentKey("Period Start")                        else                            TempDimensionCodeBuffer.SetCurrentKey(Code);                    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 := GetDimSelection(ColumnDimCode);                        if NewCode = ColumnDimCode then                            exit(false);                        Text := NewCode;                        ColumnDimCode := NewCode;                        ValidateColumnDimCode();                        CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                        exit(true);                    end;                    trigger OnValidate()                    begin                        if (UpperCase(LineDimCode) = UpperCase(ColumnDimCode)) and (LineDimCode <> '') then begin                            LineDimCode := '';                            ValidateLineDimCode();                        end;                        ValidateColumnDimCode();                        CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }            }            group(Filters)            {                Caption = 'Filters';                field(DateFilter; Rec."Date Filter")                {                    ApplicationArea = Dimensions;                    Caption = 'Date Filter';                    trigger OnValidate()                    var                        GLAcc: Record "G/L Account";                        FilterTokens: Codeunit "Filter Tokens";                    begin                        FilterTokens.MakeDateFilter(Rec."Date Filter");                        GLAcc.SetFilter("Date Filter", Rec."Date Filter");                        Rec."Date Filter" := GLAcc.GetFilter("Date Filter");                        InternalDateFilter := Rec."Date Filter";                        if Rec."Column Dim Option" = Rec."Column Dim Option"::Period then                            CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }                field(AccFilter; Rec."Account Filter")                {                    ApplicationArea = Dimensions;                    Caption = 'Account Filter';                    trigger OnLookup(var Text: Text): Boolean                    var                        GLAccList: Page "G/L Account List";                        CFAccList: Page "Cash Flow Account List";                    begin                        case AnalysisView."Account Source" of                            AnalysisView."Account Source"::"G/L Account":                                begin                                    GLAccList.LookupMode(true);                                    if not (GLAccList.RunModal() = ACTION::LookupOK) then                                        exit(false);                                    Text := GLAccList.GetSelectionFilter();                                end;                            AnalysisView."Account Source"::"Cash Flow Account":                                begin                                    CFAccList.LookupMode(true);                                    if not (CFAccList.RunModal() = ACTION::LookupOK) then                                        exit(false);                                    Text := CFAccList.GetSelectionFilter();                                end;                            else                                OnLookupAccountFilterOnAccountSourceElseCase(Rec, AnalysisView);                        end;                        exit(true);                    end;                    trigger OnValidate()                    begin                        if (Rec."Column Dim Option" = Rec."Column Dim Option"::"G/L Account") or (Rec."Column Dim Option" = Rec."Column Dim Option"::"Cash Flow Account") then                            CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }                field(BusUnitFilter; Rec."Bus. Unit Filter")                {                    ApplicationArea = Dimensions;                    CaptionClass = '3,' + BusUnitFilterCaption;                    Visible = GLAccountSource;                    trigger OnLookup(var Text: Text): Boolean                    var                        BusUnitList: Page "Business Unit List";                    begin                        BusUnitList.LookupMode(true);                        if not (BusUnitList.RunModal() = ACTION::LookupOK) then                            exit(false);                        Text := BusUnitList.GetSelectionFilter();                        exit(true);                    end;                }                field(CashFlowFilter; Rec."Cash Flow Forecast Filter")                {                    ApplicationArea = Dimensions;                    Caption = 'Cash Flow Forecast Filter';                    LookupPageID = "Cash Flow Forecast List";                    TableRelation = "Cash Flow Forecast";                    Visible = (GLAccountSource = false);                    trigger OnValidate()                    begin                        if Rec."Column Dim Option" = Rec."Column Dim Option"::"Cash Flow Forecast" then                            CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }                field(BudgetFilter; Rec."Budget Filter")                {                    ApplicationArea = Dimensions;                    Caption = 'Budget Filter';                    LookupPageID = "G/L Budget Names";                    TableRelation = "G/L Budget Name".Name;                    Visible = GLAccountSource;                }                field(Dim1Filter; Rec."Dimension 1 Filter")                {                    ApplicationArea = Dimensions;                    CaptionClass = GetCaptionClass(1);                    Caption = 'Dimension 1 Filter';                    Enabled = Dim1FilterEnable;                    trigger OnLookup(var Text: Text): Boolean                    begin                        exit(LookUpDimFilter(AnalysisView."Dimension 1 Code", Text));                    end;                    trigger OnValidate()                    begin                        if Rec."Column Dim Option" = Rec."Column Dim Option"::"Dimension 1" then                            CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }                field(Dim2Filter; Rec."Dimension 2 Filter")                {                    ApplicationArea = Dimensions;                    CaptionClass = GetCaptionClass(2);                    Caption = 'Dimension 2 Filter';                    Enabled = Dim2FilterEnable;                    trigger OnLookup(var Text: Text): Boolean                    begin                        exit(LookUpDimFilter(AnalysisView."Dimension 2 Code", Text));                    end;                    trigger OnValidate()                    begin                        if Rec."Column Dim Option" = Rec."Column Dim Option"::"Dimension 2" then                            CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }                field(Dim3Filter; Rec."Dimension 3 Filter")                {                    ApplicationArea = Dimensions;                    CaptionClass = GetCaptionClass(3);                    Caption = 'Dimension 3 Filter';                    Enabled = Dim3FilterEnable;                    trigger OnLookup(var Text: Text): Boolean                    begin                        exit(LookUpDimFilter(AnalysisView."Dimension 3 Code", Text));                    end;                    trigger OnValidate()                    begin                        if Rec."Column Dim Option" = Rec."Column Dim Option"::"Dimension 3" then                            CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }                field(Dim4Filter; Rec."Dimension 4 Filter")                {                    ApplicationArea = Dimensions;                    CaptionClass = GetCaptionClass(4);                    Caption = 'Dimension 4 Filter';                    Enabled = Dim4FilterEnable;                    trigger OnLookup(var Text: Text): Boolean                    begin                        exit(LookUpDimFilter(AnalysisView."Dimension 4 Code", Text));                    end;                    trigger OnValidate()                    begin                        if Rec."Column Dim Option" = Rec."Column Dim Option"::"Dimension 4" then                            CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }            }            group(Options)            {                Caption = 'Options';                field(ShowActualBudg; Rec."Show Actual/Budgets")                {                    ApplicationArea = Dimensions;                    Visible = GLAccountSource;                }                field(AmountField; Rec."Show Amount Field")                {                    ApplicationArea = Dimensions;                    Caption = 'Show Amount Field';                }                field(ClosingEntryFilter; Rec."Closing Entries")                {                    ApplicationArea = Dimensions;                    OptionCaption = 'Include,Exclude';                    ToolTip = 'Specifies whether the amounts shown in the matrix window will include closing entries.';                    Visible = GLAccountSource;                    trigger OnValidate()                    begin                        FindPeriod('=');                    end;                }                field(RoundingFactor; Rec."Rounding Factor")                {                    ApplicationArea = Dimensions;                }                field(ShowInAddCurr; Rec."Show In Add. Currency")                {                    ApplicationArea = Dimensions;                    MultiLine = true;                    ToolTip = 'Specifies if the reported amounts are shown in the additional reporting currency.';                    Visible = GLAccountSource;                }                field(ShowColumnName; Rec."Show Column Name")                {                    ApplicationArea = Dimensions;                    trigger OnValidate()                    begin                        CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }                field(ShowOppositeSign; Rec."Show Opposite Sign")                {                    ApplicationArea = Dimensions;                    MultiLine = true;                }            }            group("Matrix Options")            {                Caption = 'Matrix Options';                field(PeriodType; Rec."Period Type")                {                    ApplicationArea = Dimensions;                    trigger OnValidate()                    begin                        FindPeriod('');                        if Rec."Column Dim Option" = Rec."Column Dim Option"::Period then                            CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }                field(ColumnsSet; Rec."Column Set")                {                    ApplicationArea = Dimensions;                    Editable = false;                }                field(QtyType; Rec."Amount Type")                {                    ApplicationArea = Dimensions;                }            }        }    }    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;                        ValidateLineDimCode();                        ValidateColumnDimCode();                        CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                    end;                }            }        }        area(processing)        {            action(ShowMatrix)            {                ApplicationArea = Dimensions;                Caption = '&Show Matrix';                Image = ShowMatrix;                ToolTip = 'View the data overview according to the selected filters and options.';                trigger OnAction()                var                    MatrixForm: Page "Analysis by Dimensions Matrix";                begin                    Clear(MatrixForm);                    if GLAccountSource then                        Rec."Cash Flow Forecast Filter" := '';                    MatrixForm.Load(Rec, LineDimCode, ColumnDimCode, ColumnCaptions, PrimaryKeyFirstColInSet);                    MatrixForm.RunModal();                end;            }            action("Previous Set")            {                ApplicationArea = Dimensions;                Caption = 'Previous Set';                Image = PreviousSet;                ToolTip = 'Go to the previous set of data.';                trigger OnAction()                begin                    CreateCaptionSet(TempDimensionCodeBuffer, Step::Previous, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                end;            }            action("Next Set")            {                ApplicationArea = Dimensions;                Caption = 'Next Set';                Image = NextSet;                ToolTip = 'Go to the next set of data.';                trigger OnAction()                begin                    CreateCaptionSet(TempDimensionCodeBuffer, Step::Next, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");                end;            }        }        area(Promoted)        {            group(Category_Process)            {                Caption = 'Process', Comment = 'Generated from the PromotedActionCategories property index 1.';                actionref("Previous Set_Promoted"; "Previous Set")                {                }                actionref(ShowMatrix_Promoted; ShowMatrix)                {                }                actionref("Next Set_Promoted"; "Next Set")                {                }                actionref("Reverse Lines and Columns_Promoted"; "Reverse Lines and Columns")                {                }            }        }    }    trigger OnFindRecord(Which: Text): Boolean    begin        exit(FindRecord(Rec."Line Dim Option", TempDimensionCodeBuffer, Which));    end;    trigger OnInit()    begin        Dim4FilterEnable := true;        Dim3FilterEnable := true;        Dim2FilterEnable := true;        Dim1FilterEnable := true;    end;    trigger OnOpenPage()    var        GLAcc: Record "G/L Account";        "Field": Record "Field";        CashFlowAccount: Record "Cash Flow Account";        AnalysisByDimUserParam: Record "Analysis by Dim. User Param.";        AccountCaption: Text[30];        UnitCaption: Text[30];    begin        OnBeforeOpenPage(Rec);        if (NewAnalysisViewCode <> '') and (NewAnalysisViewCode <> Rec."Analysis View Code") then            Rec."Analysis View Code" := NewAnalysisViewCode;        AnalysisByDimUserParam.Load(Rec, Page::"Analysis by Dimensions");        ValidateAnalysisViewCode();        GLSetup.Get();        if GLSetup."Additional Reporting Currency" = '' then            Rec."Show In Add. Currency" := false        else            Currency.Get(GLSetup."Additional Reporting Currency");        case Rec."Analysis Account Source" of            Rec."Analysis Account Source"::"G/L Account":                LineDimCode := GLAcc.TableCaption;            Rec."Analysis Account Source"::"Cash Flow Account":                LineDimCode := CashFlowAccount.TableCaption();            else                OnGetCaptions(AnalysisView, LineDimCode, AccountCaption, UnitCaption, true);        end;        ColumnDimCode := Text000;        Rec."Line Dim Option" := DimCodeToDimOption(LineDimCode);        Rec."Column Dim Option" := DimCodeToDimOption(ColumnDimCode);        case Rec."Analysis Account Source" of            Rec."Analysis Account Source"::"G/L Account":                begin                    Field.Get(DATABASE::"G/L Account", 42);                    BusUnitFilterCaption := Field."Field Caption";                end;            else                OnOpenPageOnGetBusUnitFilterCaptionElseCase(Rec, AnalysisView, BusUnitFilterCaption);        end;        FindPeriod('');        CreateCaptionSet(TempDimensionCodeBuffer, Step::First, 32, PrimaryKeyFirstColInSet, ColumnCaptions, Rec."Column Set");    end;    trigger OnQueryClosePage(CloseAction: Action): Boolean    var        AnalysisByDimUserParam: Record "Analysis by Dim. User Param.";    begin        AnalysisByDimUserParam.Save(Rec, Page::"Analysis by Dimensions");    end;    var#pragma warning disable AA0074        Text000: Label 'Period';        Text002: Label 'You have not yet defined an analysis view.';#pragma warning disable AA0470        Text003: Label '%1 is not a valid line definition.';        Text004: Label '%1 is not a valid column definition.';#pragma warning restore AA0470        Text005: Label '1,6,,Dimension 1 Filter';        Text006: Label '1,6,,Dimension 2 Filter';        Text007: Label '1,6,,Dimension 3 Filter';        Text008: Label '1,6,,Dimension 4 Filter';#pragma warning restore AA0074        GLSetup: Record "General Ledger Setup";        AnalysisView: Record "Analysis View";        AnalysisViewEntry: Record "Analysis View Entry";        Currency: Record Currency;        AmountType: Enum "Analysis Amount Type";        GLAccountSource: Boolean;        LineDimCode: Text[30];        ColumnDimCode: Text[30];        InternalDateFilter: Text;        NewAnalysisViewCode: Code[10];        PeriodInitialized: Boolean;        BusUnitFilterCaption: Text[80];        Dim1FilterEnable: Boolean;        Dim2FilterEnable: Boolean;        Dim3FilterEnable: Boolean;        Dim4FilterEnable: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470        Text009: Label 'Unsupported Account Source %1.';#pragma warning restore AA0470#pragma warning restore AA0074    protected var        TempDimensionCodeBuffer: Record "Dimension Code Buffer" temporary;        ColumnCaptions: array[32] of Text[80];        PrimaryKeyFirstColInSet: Text[1024];        Step: Option First,Previous,Same,Next;    /// <summary>    /// Converts dimension code text to corresponding Analysis Dimension Option enum value.    /// Maps dimension codes to appropriate enum values for matrix row and column configuration.    /// </summary>    /// <param name="DimCode">Dimension code text to convert (Account, Period, Dimension 1-4)</param>    /// <returns>Corresponding Analysis Dimension Option enum value for the dimension code</returns>    procedure DimCodeToDimOption(DimCode: Text[30]) Result: Enum "Analysis Dimension Option"    var        AccountCaption: Text[30];        UnitCaption: Text[30];        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeDimCodeToDimOption(DimCode, AnalysisView, Result, IsHandled);        if IsHandled then            exit(Result);        GetAccountCaption(AccountCaption, UnitCaption);        case DimCode of            AccountCaption:                case Rec."Analysis Account Source" of                    Rec."Analysis Account Source"::"G/L Account":                        exit(Enum::"Analysis Dimension Option"::"G/L Account");                    Rec."Analysis Account Source"::"Cash Flow Account":                        exit(Enum::"Analysis Dimension Option"::"Cash Flow Account");                    else begin                        OnGetAnalysisViewDimensionOption(AnalysisView, Result, DimCode);                        exit(Result);                    end;                end;            Text000:                exit(Enum::"Analysis Dimension Option"::Period);            UnitCaption:                case Rec."Analysis Account Source" of                    Rec."Analysis Account Source"::"G/L Account":                        exit(Enum::"Analysis Dimension Option"::"Business Unit");                    Rec."Analysis Account Source"::"Cash Flow Account":                        exit(Enum::"Analysis Dimension Option"::"Cash Flow Forecast");                    else begin                        OnGetAnalysisViewDimensionOption(AnalysisView, Result, DimCode);                        exit(Result);                    end;                end;            AnalysisView."Dimension 1 Code":                exit(Enum::"Analysis Dimension Option"::"Dimension 1");            AnalysisView."Dimension 2 Code":                exit(Enum::"Analysis Dimension Option"::"Dimension 2");            AnalysisView."Dimension 3 Code":                exit(Enum::"Analysis Dimension Option"::"Dimension 3");            AnalysisView."Dimension 4 Code":                exit(Enum::"Analysis Dimension Option"::"Dimension 4");            else                exit(Enum::"Analysis Dimension Option"::Undefined);        end;    end;    /// <summary>    /// Finds records based on dimension option and populates dimension code buffer for matrix display.    /// Handles navigation through G/L accounts, periods, business units, cash flow, and dimension values.    /// </summary>    /// <param name="DimOption">Type of dimension to search (G/L Account, Period, Dimension 1-4, etc.)</param>    /// <param name="DimCodeBuf">Dimension code buffer to populate with found record data</param>    /// <param name="Which">Search direction or position (-, +, =, etc.)</param>    /// <returns>True if record was found and buffer was populated, false otherwise</returns>    procedure FindRecord(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Which: Text[250]) Found: Boolean    var        GLAcc: Record "G/L Account";        BusUnit: Record "Business Unit";        CFAccount: Record "Cash Flow Account";        CashFlowForecast: Record "Cash Flow Forecast";        Period: Record Date;        DimVal: Record "Dimension Value";        PeriodPageMgt: Codeunit PeriodPageManagement;    begin        OnBeforeFindRecord(DimOption, DimVal);        case DimOption of            DimOption::"G/L Account":                begin                    GLAcc."No." := DimCodeBuf.Code;                    if Rec."Account Filter" <> '' then                        GLAcc.SetFilter("No.", Rec."Account Filter");                    Found := GLAcc.Find(Which);                    if Found then                        CopyGLAccToBuf(GLAcc, DimCodeBuf);                end;            DimOption::"Cash Flow Account":                begin                    CFAccount."No." := DimCodeBuf.Code;                    if Rec."Account Filter" <> '' then                        CFAccount.SetFilter("No.", Rec."Account Filter");                    Found := CFAccount.Find(Which);                    if Found then                        CopyCFAccToBuf(CFAccount, DimCodeBuf);                end;            DimOption::Period:                begin                    if not PeriodInitialized then                        Rec."Date Filter" := '';                    PeriodInitialized := true;                    Period."Period Start" := DimCodeBuf."Period Start";                    if Rec."Date Filter" <> '' then                        Period.SetFilter("Period Start", Rec."Date Filter")                    else                        if Period."Period Start" <> 0D then                            Period.SetFilter("Period Start", '%1..%2', Period."Period Start", ClosingDate(Period."Period Start"))                        else                            if InternalDateFilter <> '' then                                Period.SetFilter("Period Start", InternalDateFilter);                    Found := PeriodPageMgt.FindDate(Which, Period, Rec."Period Type");                    if Found then                        CopyPeriodToBuf(Period, DimCodeBuf);                end;            DimOption::"Business Unit":                begin                    BusUnit.Code := DimCodeBuf.Code;                    if Rec."Bus. Unit Filter" <> '' then                        BusUnit.SetFilter(Code, Rec."Bus. Unit Filter");                    Found := BusUnit.Find(Which);                    if Found then                        CopyBusUnitToBuf(BusUnit, DimCodeBuf);                end;            DimOption::"Cash Flow Forecast":                begin                    CashFlowForecast."No." := DimCodeBuf.Code;                    if Rec."Cash Flow Forecast Filter" <> '' then                        CashFlowForecast.SetFilter("No.", Rec."Cash Flow Forecast Filter");                    Found := CashFlowForecast.Find(Which);                    if Found then                        CopyCashFlowToBuf(CashFlowForecast, DimCodeBuf);                end;            DimOption::"Dimension 1":                begin                    if Rec."Dimension 1 Filter" <> '' then                        DimVal.SetFilter(Code, Rec."Dimension 1 Filter");                    DimVal."Dimension Code" := AnalysisView."Dimension 1 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    Found := DimVal.Find(Which);                    if Found then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;            DimOption::"Dimension 2":                begin                    if Rec."Dimension 2 Filter" <> '' then                        DimVal.SetFilter(Code, Rec."Dimension 2 Filter");                    DimVal."Dimension Code" := AnalysisView."Dimension 2 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    Found := DimVal.Find(Which);                    if Found then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;            DimOption::"Dimension 3":                begin                    if Rec."Dimension 3 Filter" <> '' then                        DimVal.SetFilter(Code, Rec."Dimension 3 Filter");                    DimVal."Dimension Code" := AnalysisView."Dimension 3 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    Found := DimVal.Find(Which);                    if Found then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;            DimOption::"Dimension 4":                begin                    if Rec."Dimension 4 Filter" <> '' then                        DimVal.SetFilter(Code, Rec."Dimension 4 Filter");                    DimVal."Dimension Code" := AnalysisView."Dimension 4 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    Found := DimVal.Find(Which);                    if Found then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;        end;        OnAfterFindRecord(DimOption, DimCodeBuf, AnalysisView, Which, Found, Rec);    end;    /// <summary>    /// Navigates to next/previous records in dimension data for matrix column generation.    /// Advances through dimension values by specified number of steps for pagination.    /// </summary>    /// <param name="DimOption">Type of dimension to navigate (G/L Account, Period, Dimension 1-4, etc.)</param>    /// <param name="DimCodeBuf">Dimension code buffer to update with navigation result</param>    /// <param name="Steps">Number of steps to advance (positive=forward, negative=backward)</param>    /// <returns>Actual number of steps taken (may be less than requested if end reached)</returns>    procedure NextRecord(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Steps: Integer) ResultSteps: Integer    var        GLAcc: Record "G/L Account";        BusUnit: Record "Business Unit";        CFAccount: Record "Cash Flow Account";        CashFlowForecast: Record "Cash Flow Forecast";        Period: Record Date;        DimVal: Record "Dimension Value";        PeriodPageMgt: Codeunit PeriodPageManagement;    begin        OnBeforeNextRecord(DimOption, DimVal);        case DimOption of            DimOption::"G/L Account":                begin                    GLAcc."No." := DimCodeBuf.Code;                    if Rec."Account Filter" <> '' then                        GLAcc.SetFilter("No.", Rec."Account Filter");                    ResultSteps := GLAcc.Next(Steps);                    if ResultSteps <> 0 then                        CopyGLAccToBuf(GLAcc, DimCodeBuf);                end;            DimOption::"Cash Flow Account":                begin                    CFAccount."No." := DimCodeBuf.Code;                    if Rec."Account Filter" <> '' then                        CFAccount.SetFilter("No.", Rec."Account Filter");                    ResultSteps := CFAccount.Next(Steps);                    if ResultSteps <> 0 then                        CopyCFAccToBuf(CFAccount, DimCodeBuf);                end;            DimOption::Period:                begin                    if Rec."Date Filter" <> '' then                        Period.SetFilter("Period Start", Rec."Date Filter");                    Period."Period Start" := DimCodeBuf."Period Start";                    ResultSteps := PeriodPageMgt.NextDate(Steps, Period, Rec."Period Type");                    if ResultSteps <> 0 then                        CopyPeriodToBuf(Period, DimCodeBuf);                end;            DimOption::"Business Unit":                begin                    BusUnit.Code := DimCodeBuf.Code;                    if Rec."Bus. Unit Filter" <> '' then                        BusUnit.SetFilter(Code, Rec."Bus. Unit Filter");                    ResultSteps := BusUnit.Next(Steps);                    if ResultSteps <> 0 then                        CopyBusUnitToBuf(BusUnit, DimCodeBuf);                end;            DimOption::"Cash Flow Forecast":                begin                    CashFlowForecast."No." := DimCodeBuf.Code;                    if Rec."Cash Flow Forecast Filter" <> '' then                        CashFlowForecast.SetFilter("No.", Rec."Cash Flow Forecast Filter");                    ResultSteps := CashFlowForecast.Next(Steps);                    if ResultSteps <> 0 then                        CopyCashFlowToBuf(CashFlowForecast, DimCodeBuf);                end;            DimOption::"Dimension 1":                begin                    if Rec."Dimension 1 Filter" <> '' then                        DimVal.SetFilter(Code, Rec."Dimension 1 Filter");                    DimVal."Dimension Code" := AnalysisView."Dimension 1 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    ResultSteps := DimVal.Next(Steps);                    if ResultSteps <> 0 then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;            DimOption::"Dimension 2":                begin                    if Rec."Dimension 2 Filter" <> '' then                        DimVal.SetFilter(Code, Rec."Dimension 2 Filter");                    DimVal."Dimension Code" := AnalysisView."Dimension 2 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    ResultSteps := DimVal.Next(Steps);                    if ResultSteps <> 0 then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;            DimOption::"Dimension 3":                begin                    if Rec."Dimension 3 Filter" <> '' then                        DimVal.SetFilter(Code, Rec."Dimension 3 Filter");                    DimVal."Dimension Code" := AnalysisView."Dimension 3 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    ResultSteps := DimVal.Next(Steps);                    if ResultSteps <> 0 then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;            DimOption::"Dimension 4":                begin                    if Rec."Dimension 4 Filter" <> '' then                        DimVal.SetFilter(Code, Rec."Dimension 4 Filter");                    DimVal."Dimension Code" := AnalysisView."Dimension 4 Code";                    DimVal.SetRange("Dimension Code", DimVal."Dimension Code");                    DimVal.Code := DimCodeBuf.Code;                    ResultSteps := DimVal.Next(Steps);                    if ResultSteps <> 0 then                        CopyDimValueToBuf(DimVal, DimCodeBuf);                end;        end;        OnAfterNextRecord(DimOption, DimCodeBuf, AnalysisView, Steps, ResultSteps);    end;    local procedure CopyGLAccToBuf(var TheGLAcc: Record "G/L Account"; var TheDimCodeBuf: Record "Dimension Code Buffer")    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := TheGLAcc."No.";        TheDimCodeBuf.Name := TheGLAcc.Name;        TheDimCodeBuf.Totaling := TheGLAcc.Totaling;        TheDimCodeBuf.Indentation := TheGLAcc.Indentation;        TheDimCodeBuf."Show in Bold" := TheGLAcc."Account Type" <> TheGLAcc."Account Type"::Posting;    end;    local procedure CopyCFAccToBuf(var TheCFAcc: Record "Cash Flow Account"; var TheDimCodeBuf: Record "Dimension Code Buffer")    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := TheCFAcc."No.";        TheDimCodeBuf.Name := TheCFAcc.Name;        TheDimCodeBuf.Totaling := TheCFAcc.Totaling;        TheDimCodeBuf.Indentation := TheCFAcc.Indentation;        TheDimCodeBuf."Show in Bold" := TheCFAcc."Account Type" <> TheCFAcc."Account Type"::Entry;    end;    local procedure CopyPeriodToBuf(var ThePeriod: Record Date; var TheDimCodeBuf: Record "Dimension Code Buffer")    var        Period2: Record Date;    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := Format(ThePeriod."Period Start");        TheDimCodeBuf."Period Start" := ThePeriod."Period Start";        if Rec."Closing Entries" = Rec."Closing Entries"::Include then            TheDimCodeBuf."Period End" := ClosingDate(ThePeriod."Period End")        else            TheDimCodeBuf."Period End" := ThePeriod."Period End";        if Rec."Date Filter" <> '' then begin            Period2.SetFilter("Period End", Rec."Date Filter");            if Period2.GetRangeMax("Period End") < TheDimCodeBuf."Period End" then                TheDimCodeBuf."Period End" := Period2.GetRangeMax("Period End");        end;        TheDimCodeBuf.Name := ThePeriod."Period Name";    end;    local procedure CopyBusUnitToBuf(var TheBusUnit: Record "Business Unit"; var TheDimCodeBuf: Record "Dimension Code Buffer")    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := TheBusUnit.Code;        TheDimCodeBuf.Name := TheBusUnit.Name;    end;    local procedure CopyCashFlowToBuf(var TheCashFlowForecast: Record "Cash Flow Forecast"; var TheDimCodeBuf: Record "Dimension Code Buffer")    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := TheCashFlowForecast."No.";        TheDimCodeBuf.Name := TheCashFlowForecast.Description;    end;    local procedure CopyDimValueToBuf(var TheDimVal: Record "Dimension Value"; var TheDimCodeBuf: Record "Dimension Code Buffer")    begin        TheDimCodeBuf.Init();        TheDimCodeBuf.Code := TheDimVal.Code;        TheDimCodeBuf.Name := TheDimVal.Name;        TheDimCodeBuf.Totaling := TheDimVal.Totaling;        TheDimCodeBuf.Indentation := TheDimVal.Indentation;        TheDimCodeBuf."Show in Bold" :=          TheDimVal."Dimension Value Type" <> TheDimVal."Dimension Value Type"::Standard;    end;    local procedure FindPeriod(SearchText: Code[10])    var        Calendar: Record Date;        PeriodPageMgt: Codeunit PeriodPageManagement;        TempDate: Date;    begin        if not PeriodInitialized then            Rec."Date Filter" := '';        if (Rec."Date Filter" <> '') and Evaluate(TempDate, Rec."Date Filter") then begin            Calendar.SetFilter("Period Start", Rec."Date Filter");            if not PeriodPageMgt.FindDate('+', Calendar, Rec."Period Type") then                PeriodPageMgt.FindDate('+', Calendar, Rec."Period Type"::Day);            Calendar.SetRange("Period Start");        end;        if PeriodPageMgt.FindDate(SearchText, Calendar, Rec."Period Type") then            if Rec."Closing Entries" = Rec."Closing Entries"::Include then                Calendar."Period End" := ClosingDate(Calendar."Period End");        if AmountType = AmountType::"Net Change" then begin            AnalysisViewEntry.SetRange("Posting Date", Calendar."Period Start", Calendar."Period End");            if AnalysisViewEntry.GetRangeMin("Posting Date") = AnalysisViewEntry.GetRangeMax("Posting Date") then                AnalysisViewEntry.SetRange("Posting Date", AnalysisViewEntry.GetRangeMin("Posting Date"));        end else            AnalysisViewEntry.SetRange("Posting Date", 0D, Calendar."Period End");        InternalDateFilter := AnalysisViewEntry.GetFilter("Posting Date");        OnFindPeriodOnAfterSetInternalDateFilter(Rec."Period Type", InternalDateFilter);        if (Rec."Line Dim Option" <> Rec."Line Dim Option"::Period) and (Rec."Column Dim Option" <> Rec."Column Dim Option"::Period) then            Rec."Date Filter" := InternalDateFilter;    end;    local procedure GetDimSelection(OldDimSelCode: Text[30]): Text[30]    var        DimSelection: Page "Dimension Selection";        AccountCaption: Text[30];        UnitCaption: Text[30];    begin        GetAccountCaption(AccountCaption, UnitCaption);        DimSelection.InsertDimSelBuf(false, AccountCaption, AccountCaption);        DimSelection.InsertDimSelBuf(false, Text000, Text000);        if UnitCaption <> '' then            DimSelection.InsertDimSelBuf(false, UnitCaption, UnitCaption);        if AnalysisView."Dimension 1 Code" <> '' then            DimSelection.InsertDimSelBuf(false, AnalysisView."Dimension 1 Code", '');        if AnalysisView."Dimension 2 Code" <> '' then            DimSelection.InsertDimSelBuf(false, AnalysisView."Dimension 2 Code", '');        if AnalysisView."Dimension 3 Code" <> '' then            DimSelection.InsertDimSelBuf(false, AnalysisView."Dimension 3 Code", '');        if AnalysisView."Dimension 4 Code" <> '' then            DimSelection.InsertDimSelBuf(false, AnalysisView."Dimension 4 Code", '');        OnGetDimSelectionOnBeforeDimSelectionLookup(AnalysisView, DimSelection);        DimSelection.LookupMode := true;        if DimSelection.RunModal() = ACTION::LookupOK then            exit(DimSelection.GetDimSelCode());        exit(OldDimSelCode);    end;    local procedure LookUpDimFilter(Dim: Code[20]; var Text: Text): Boolean    var        DimVal: Record "Dimension Value";        DimValList: Page "Dimension Value List";    begin        if Dim = '' then            exit(false);        DimValList.LookupMode(true);        DimVal.SetRange("Dimension Code", Dim);        DimValList.SetTableView(DimVal);        if DimValList.RunModal() = ACTION::LookupOK then begin            DimValList.GetRecord(DimVal);            Text := DimValList.GetSelectionFilter();            exit(true);        end;        exit(false)    end;    local procedure ValidateAnalysisViewCode()    var        AnalysisViewFilter: Record "Analysis View Filter";        IsSupported: Boolean;    begin        AnalysisView.Code := Rec."Analysis View Code";        if not AnalysisView.Find('=<>') then            Error(Text002);        Rec."Analysis View Code" := AnalysisView.Code;        if ((Rec."Analysis Account Source" = AnalysisView."Account Source") or (Rec."Account Filter" = '')) then            Rec."Account Filter" := AnalysisView."Account Filter";        Rec."Dimension 1 Filter" := '';        Rec."Dimension 2 Filter" := '';        Rec."Dimension 3 Filter" := '';        Rec."Dimension 4 Filter" := '';        Dim1FilterEnable :=          (AnalysisView."Dimension 1 Code" <> '') and          (Rec."Dimension 1 Filter" = '');        Dim2FilterEnable :=          (AnalysisView."Dimension 2 Code" <> '') and          (Rec."Dimension 2 Filter" = '');        Dim3FilterEnable :=          (AnalysisView."Dimension 3 Code" <> '') and          (Rec."Dimension 3 Filter" = '');        Dim4FilterEnable :=          (AnalysisView."Dimension 4 Code" <> '') and          (Rec."Dimension 4 Filter" = '');        if Dim1FilterEnable then            if AnalysisViewFilter.Get(AnalysisView.Code, AnalysisView."Dimension 1 Code") then                Rec."Dimension 1 Filter" := AnalysisViewFilter."Dimension Value Filter";        if Dim2FilterEnable then            if AnalysisViewFilter.Get(AnalysisView.Code, AnalysisView."Dimension 2 Code") then                Rec."Dimension 2 Filter" := AnalysisViewFilter."Dimension Value Filter";        if Dim3FilterEnable then            if AnalysisViewFilter.Get(AnalysisView.Code, AnalysisView."Dimension 3 Code") then                Rec."Dimension 3 Filter" := AnalysisViewFilter."Dimension Value Filter";        if Dim4FilterEnable then            if AnalysisViewFilter.Get(AnalysisView.Code, AnalysisView."Dimension 4 Code") then                Rec."Dimension 4 Filter" := AnalysisViewFilter."Dimension Value Filter";        OnValidateAnalysisViewCodeOnAfterRecSetFilters(Rec, AnalysisView);        case Rec."Analysis Account Source" of            Rec."Analysis Account Source"::"G/L Account":                GLAccountSource := true;            Rec."Analysis Account Source"::"Cash Flow Account":                GLAccountSource := false;            else begin                AnalysisView.OnGetAnalysisViewSupported(AnalysisView, IsSupported);                if not IsSupported then                    Error(Text009, AnalysisView."Account Source");            end;        end;    end;    local procedure ValidateLineDimCode()    var        AccountCaption: Text[30];        UnitCaption: Text[30];        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeValidateLineDimCode(GLAccountSource, LineDimCode, InternalDateFilter, IsHandled, Rec, AnalysisView, AnalysisViewEntry);        if IsHandled then            exit;        GetAccountCaption(AccountCaption, UnitCaption);        if (UpperCase(LineDimCode) <> UpperCase(AccountCaption)) and           (UpperCase(LineDimCode) <> UpperCase(UnitCaption)) and           (UpperCase(LineDimCode) <> UpperCase(Text000)) and           (UpperCase(LineDimCode) <> AnalysisView."Dimension 1 Code") and           (UpperCase(LineDimCode) <> AnalysisView."Dimension 2 Code") and           (UpperCase(LineDimCode) <> AnalysisView."Dimension 3 Code") and           (UpperCase(LineDimCode) <> AnalysisView."Dimension 4 Code") and           (LineDimCode <> '')        then begin            Message(Text003, LineDimCode);            LineDimCode := '';        end;        Rec."Line Dim Option" := DimCodeToDimOption(LineDimCode);        InternalDateFilter := AnalysisViewEntry.GetFilter("Posting Date");        if (Rec."Line Dim Option" <> Rec."Line Dim Option"::Period) and (Rec."Column Dim Option" <> Rec."Column Dim Option"::Period) then begin            Rec."Date Filter" := InternalDateFilter;            if StrPos(Rec."Date Filter", '&') > 1 then                Rec."Date Filter" := CopyStr(Rec."Date Filter", 1, StrPos(Rec."Date Filter", '&') - 1);        end;    end;    local procedure ValidateColumnDimCode()    var        AccountCaption: Text[30];        UnitCaption: Text[30];        IsHandled: Boolean;    begin        IsHandled := false;        OnBeforeValidateColumnDimCode(GLAccountSource, ColumnDimCode, InternalDateFilter, IsHandled, Rec, AnalysisView, AnalysisViewEntry, PeriodInitialized);        if IsHandled then            exit;        GetAccountCaption(AccountCaption, UnitCaption);        if (UpperCase(ColumnDimCode) <> UpperCase(AccountCaption)) and           (UpperCase(ColumnDimCode) <> UpperCase(UnitCaption)) and           (UpperCase(ColumnDimCode) <> UpperCase(Text000)) and           (UpperCase(ColumnDimCode) <> AnalysisView."Dimension 1 Code") and           (UpperCase(ColumnDimCode) <> AnalysisView."Dimension 2 Code") and           (UpperCase(ColumnDimCode) <> AnalysisView."Dimension 3 Code") and           (UpperCase(ColumnDimCode) <> AnalysisView."Dimension 4 Code") and           (ColumnDimCode <> '')        then begin            Message(Text004, ColumnDimCode);            ColumnDimCode := '';        end;        Rec."Column Dim Option" := DimCodeToDimOption(ColumnDimCode);        InternalDateFilter := AnalysisViewEntry.GetFilter("Posting Date");        if (Rec."Line Dim Option" <> Rec."Line Dim Option"::Period) and (Rec."Column Dim Option" <> Rec."Column Dim Option"::Period) then begin            Rec."Date Filter" := InternalDateFilter;            if StrPos(Rec."Date Filter", '&') > 1 then                Rec."Date Filter" := CopyStr(Rec."Date Filter", 1, StrPos(Rec."Date Filter", '&') - 1);        end else            PeriodInitialized := false;    end;    /// <summary>    /// Generates caption class string for dimension filter fields based on analysis view configuration.    /// Provides dynamic captions for dimension 1-4 filters using actual dimension codes from analysis view.    /// </summary>    /// <param name="AnalysisViewDimType">Dimension type identifier (1-4) for caption generation</param>    /// <returns>Caption class string for dimension filter field display</returns>    procedure GetCaptionClass(AnalysisViewDimType: Integer) Result: Text[250]    var        DummyAnalysisbyDimParameters: Record "Analysis by Dim. Parameters";    begin        if AnalysisView.Code <> Rec."Analysis View Code" then            if AnalysisView.Get(Rec."Analysis View Code") then                if Rec."Analysis Account Source" = DummyAnalysisbyDimParameters."Analysis Account Source" then                    Rec."Analysis Account Source" := AnalysisView."Account Source";        case AnalysisViewDimType of            1:                begin                    if AnalysisView."Dimension 1 Code" <> '' then                        exit('1,6,' + AnalysisView."Dimension 1 Code");                    exit(Text005);                end;            2:                begin                    if AnalysisView."Dimension 2 Code" <> '' then                        exit('1,6,' + AnalysisView."Dimension 2 Code");                    exit(Text006);                end;            3:                begin                    if AnalysisView."Dimension 3 Code" <> '' then                        exit('1,6,' + AnalysisView."Dimension 3 Code");                    exit(Text007);                end;            4:                begin                    if AnalysisView."Dimension 4 Code" <> '' then                        exit('1,6,' + AnalysisView."Dimension 4 Code");                    exit(Text008);                end;        end;        OnAfterGetCaptionClass(AnalysisViewDimType, AnalysisView, Result);    end;    protected procedure CreateCaptionSet(RecRef: Record "Dimension Code Buffer"; Step: Option First,Previous,Same,Next; MaximumNoOfCaptions: Integer; var PrimaryKeyFirstCaptionInCurrSe: Text[1024]; var CaptionSet: array[32] of Text[1024]; var CaptionRange: Text[1024])    var        CurrentCaptionOrdinal: Integer;    begin        Clear(CaptionSet);        CaptionRange := '';        CurrentCaptionOrdinal := 0;        case Step of            Step::First:                if (Rec."Column Dim Option" = Rec."Column Dim Option"::Period) and (Rec."Date Filter" = '') then                    FindRecord(Rec."Column Dim Option", RecRef, '=><')                else                    if not FindRecord(Rec."Column Dim Option", RecRef, '-') then                        exit;            Step::Previous:                begin                    RecRef.SetPosition(PrimaryKeyFirstCaptionInCurrSe);                    if Rec."Column Dim Option" = Rec."Column Dim Option"::Period then                        Evaluate(RecRef."Period Start", RecRef.Code);                    if not FindRecord(Rec."Column Dim Option", RecRef, '=') then                        exit;                    NextRecord(Rec."Column Dim Option", RecRef, -MaximumNoOfCaptions);                end;            Step::Same:                begin                    RecRef.SetPosition(PrimaryKeyFirstCaptionInCurrSe);                    if Rec."Column Dim Option" = Rec."Column Dim Option"::Period then                        Evaluate(RecRef."Period Start", RecRef.Code);                    if not FindRecord(Rec."Column Dim Option", RecRef, '=') then                        exit;                end;            Step::Next:                begin                    RecRef.SetPosition(PrimaryKeyFirstCaptionInCurrSe);                    if Rec."Column Dim Option" = Rec."Column Dim Option"::Period then                        Evaluate(RecRef."Period Start", RecRef.Code);                    if not FindRecord(Rec."Column Dim Option", RecRef, '=') then                        exit;                    if not (NextRecord(Rec."Column Dim Option", RecRef, MaximumNoOfCaptions) = MaximumNoOfCaptions) then begin                        RecRef.SetPosition(PrimaryKeyFirstCaptionInCurrSe);                        FindRecord(Rec."Column Dim Option", RecRef, '=');                    end;                end;        end;        PrimaryKeyFirstCaptionInCurrSe := RecRef.GetPosition();        repeat            CurrentCaptionOrdinal := CurrentCaptionOrdinal + 1;            if Rec."Show Column Name" then                CaptionSet[CurrentCaptionOrdinal] := RecRef.Name            else                CaptionSet[CurrentCaptionOrdinal] := RecRef.Code;        until (CurrentCaptionOrdinal = MaximumNoOfCaptions) or (NextRecord(Rec."Column Dim Option", RecRef, 1) <> 1);        if CurrentCaptionOrdinal = 1 then            CaptionRange := CaptionSet[1]        else            CaptionRange := CopyStr(CaptionSet[1] + '..' + CaptionSet[CurrentCaptionOrdinal], 1, MaxStrLen(CaptionRange));    end;    /// <summary>    /// Sets the analysis view code for the page and initializes the record for analysis configuration.    /// Prepares the temporary record with the specified analysis view for dimension analysis setup.    /// </summary>    /// <param name="NextAnalysisViewCode">Analysis view code to set for analysis by dimensions</param>    procedure SetAnalysisViewCode(NextAnalysisViewCode: Code[10])    begin        NewAnalysisViewCode := NextAnalysisViewCode;        Rec."Analysis View Code" := NextAnalysisViewCode;        Rec.Insert();    end;    local procedure GetAccountCaption(var AccountCaption: Text[30]; var UnitCaption: Text[30])    var        GLAcc: Record "G/L Account";        CFAccount: Record "Cash Flow Account";        BusUnit: Record "Business Unit";        CashFlowForecast: Record "Cash Flow Forecast";    begin        case Rec."Analysis Account Source" of            Rec."Analysis Account Source"::"G/L Account":                begin                    AccountCaption := GLAcc.TableCaption();                    UnitCaption := BusUnit.TableCaption();                end;            Rec."Analysis Account Source"::"Cash Flow Account":                begin                    AccountCaption := CFAccount.TableCaption();                    UnitCaption := CashFlowForecast.TableCaption();                end;            else                OnGetCaptions(AnalysisView, LineDimCode, AccountCaption, UnitCaption, false);        end;    end;    /// <summary>    /// Integration event raised after finding dimension records for matrix display.    /// Enables customization of dimension record processing and buffer population logic.    /// </summary>    /// <param name="DimOption">Dimension option that was processed</param>    /// <param name="DimCodeBuf">Dimension code buffer populated with found data</param>    /// <param name="AnalysisView">Analysis view configuration</param>    /// <param name="Which">Search direction or position used</param>    /// <param name="Found">Whether record was found</param>    /// <param name="AnalysisByDimParameters">Analysis parameters for context</param>    [IntegrationEvent(true, false)]    local procedure OnAfterFindRecord(var DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; var AnalysisView: Record "Analysis View"; Which: Text[250]; var Found: Boolean; var AnalysisByDimParameters: Record "Analysis by Dim. Parameters")    begin    end;    /// <summary>    /// Integration event raised after generating caption class for dimension filters.    /// Enables customization of caption class formatting for dimension filter fields.    /// </summary>    /// <param name="AnalysisViewDimType">Dimension type being processed (1-4)</param>    /// <param name="AnalysisView">Analysis view configuration</param>    /// <param name="ReturnValue">Caption class string that can be modified</param>    [IntegrationEvent(false, false)]    local procedure OnAfterGetCaptionClass(AnalysisViewDimType: Integer; var AnalysisView: Record "Analysis View"; var ReturnValue: Text[250])    begin    end;    /// <summary>    /// Integration event raised after navigating through dimension records in matrix.    /// Enables customization of dimension navigation and result processing logic.    /// </summary>    /// <param name="DimOption">Dimension option that was navigated</param>    /// <param name="DimCodeBuf">Dimension code buffer with navigation results</param>    /// <param name="AnalysisView">Analysis view configuration</param>    /// <param name="Steps">Number of steps requested for navigation</param>    /// <param name="ResultSteps">Actual number of steps taken</param>    [IntegrationEvent(true, false)]    local procedure OnAfterNextRecord(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; var AnalysisView: Record "Analysis View"; Steps: Integer; var ResultSteps: Integer)    begin    end;    /// <summary>    /// Integration event raised before page opens for analysis by dimensions initialization.    /// Enables customization of analysis parameters before page display.    /// </summary>    /// <param name="AnalysisByDimParameters">Analysis parameters to be customized</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeOpenPage(var AnalysisByDimParameters: Record "Analysis by Dim. Parameters")    begin    end;    /// <summary>    /// Integration event raised before converting dimension code to dimension option enum.    /// Enables custom dimension code mapping for extended analysis view types.    /// </summary>    /// <param name="DimCode">Dimension code being converted</param>    /// <param name="AnalysisView">Analysis view configuration for context</param>    /// <param name="Result">Resulting dimension option enum value</param>    /// <param name="IsHandled">Set to true to skip standard conversion logic</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeDimCodeToDimOption(DimCode: Text[30]; var AnalysisView: Record "Analysis View"; var Result: Enum "Analysis Dimension Option"; var IsHandled: Boolean)    begin    end;    /// <summary>    /// Integration event for custom dimension navigation logic in analysis by dimensions.    /// </summary>    /// <param name="DimOption">Dimension option for navigation context</param>    /// <param name="DimensionValue">Dimension value being navigated</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeNextRecord(DimOption: Enum "Analysis Dimension Option"; var DimensionValue: Record "Dimension Value")    begin    end;    /// <summary>    /// Integration event for custom dimension record finding logic in analysis by dimensions.    /// </summary>    /// <param name="DimOption">Dimension option for record finding context</param>    /// <param name="DimensionValue">Dimension value being found</param>    [IntegrationEvent(false, false)]    local procedure OnBeforeFindRecord(DimOption: Enum "Analysis Dimension Option"; var DimensionValue: Record "Dimension Value")    begin    end;    /// <summary>    /// Integration event for custom validation logic when column dimension code is changed.    /// </summary>    /// <param name="GLAccountSource">Whether G/L Account is the data source</param>    /// <param name="ColumnDimCode">Column dimension code being validated</param>    /// <param name="InternalDateFilter">Internal date filter for analysis</param>    /// <param name="IsHandled">Set to true to skip standard validation</param>    /// <param name="AnalysisByDimParameters">Analysis parameters record</param>    /// <param name="AnalysisView">Analysis view configuration</param>    /// <param name="AnalysisViewEntry">Analysis view entry for data context</param>    /// <param name="PeriodInitialized">Whether period has been initialized</param>    [IntegrationEvent(true, false)]    local procedure OnBeforeValidateColumnDimCode(var GLAccountSource: Boolean; var ColumnDimCode: Text[30]; var InternalDateFilter: Text; var IsHandled: Boolean; var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var AnalysisView: Record "Analysis View"; var AnalysisViewEntry: Record "Analysis View Entry"; var PeriodInitialized: Boolean)    begin    end;    /// <summary>    /// Integration event for custom validation logic when line dimension code is changed.    /// </summary>    /// <param name="GLAccountSource">Whether G/L Account is the data source</param>    /// <param name="LineDimCode">Line dimension code being validated</param>    /// <param name="InternalDateFilter">Internal date filter for analysis</param>    /// <param name="IsHandled">Set to true to skip standard validation</param>    /// <param name="AnalysisByDimParameters">Analysis parameters record</param>    /// <param name="AnalysisView">Analysis view configuration</param>    /// <param name="AnalysisViewEntry">Analysis view entry for data context</param>    [IntegrationEvent(true, false)]    local procedure OnBeforeValidateLineDimCode(var GLAccountSource: Boolean; var LineDimCode: Text[30]; var InternalDateFilter: Text; var IsHandled: Boolean; var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var AnalysisView: Record "Analysis View"; var AnalysisViewEntry: Record "Analysis View Entry")    begin    end;    /// <summary>    /// Integration event for customizing dimension selection lookup before opening the page.    /// </summary>    /// <param name="AnalysisView">Analysis view configuration</param>    /// <param name="DimSelection">Dimension selection page to be customized</param>    [IntegrationEvent(false, false)]    local procedure OnGetDimSelectionOnBeforeDimSelectionLookup(var AnalysisView: Record "Analysis View"; var DimSelection: Page "Dimension Selection")    begin    end;    /// <summary>    /// Integration event for custom logic after setting analysis view filters on record.    /// </summary>    /// <param name="AnalysisByDimParameters">Analysis parameters with updated filters</param>    /// <param name="AnalysisView">Analysis view configuration</param>    [IntegrationEvent(false, false)]    local procedure OnValidateAnalysisViewCodeOnAfterRecSetFilters(var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var AnalysisView: Record "Analysis View")    begin    end;    /// <summary>    /// Integration event for customizing captions in analysis by dimensions display.    /// </summary>    /// <param name="AnalysisView">Analysis view configuration</param>    /// <param name="LineDimCode">Line dimension code for caption context</param>    /// <param name="AccountCaption">Account caption to be customized</param>    /// <param name="UnitCaption">Unit caption to be customized</param>    /// <param name="OpenPage">Whether the page is being opened</param>    [IntegrationEvent(false, false)]    local procedure OnGetCaptions(var AnalysisView: Record "Analysis View"; var LineDimCode: Text[30]; var AccountCaption: Text[30]; var UnitCaption: Text[30]; OpenPage: Boolean)    begin    end;    /// <summary>    /// Integration event for determining analysis view dimension option from dimension code.    /// </summary>    /// <param name="AnalysisView">Analysis view configuration</param>    /// <param name="Result">Resulting analysis dimension option</param>    /// <param name="DimCode">Dimension code for option determination</param>    [IntegrationEvent(false, false)]    local procedure OnGetAnalysisViewDimensionOption(var AnalysisView: Record "Analysis View"; var Result: enum "Analysis Dimension Option"; DimCode: Text[30])    begin    end;    /// <summary>    /// Integration event for custom account filter lookup when account source is not standard.    /// </summary>    /// <param name="AnalysisByDimParameters">Analysis parameters for filter context</param>    /// <param name="AnalysisView">Analysis view configuration</param>    [IntegrationEvent(false, false)]    local procedure OnLookupAccountFilterOnAccountSourceElseCase(var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; AnalysisView: Record "Analysis View")    begin    end;    /// <summary>    /// Integration event for customizing business unit filter caption when account source is not standard.    /// </summary>    /// <param name="AnalysisByDimParameters">Analysis parameters for caption context</param>    /// <param name="AnalysisView">Analysis view configuration</param>    /// <param name="BusUnitFilterCaption">Business unit filter caption to be customized</param>    [IntegrationEvent(false, false)]    local procedure OnOpenPageOnGetBusUnitFilterCaptionElseCase(var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; AnalysisView: Record "Analysis View"; var BusUnitFilterCaption: Text[80])    begin    end;    /// <summary>    /// Integration event for customizing date filter after period finding logic.    /// </summary>    /// <param name="PeriodType">Period type for date filter context</param>    /// <param name="DateFilter">Date filter text to be customized</param>    [IntegrationEvent(false, false)]    local procedure OnFindPeriodOnAfterSetInternalDateFilter(PeriodType: Enum "Analysis Period Type"; var DateFilter: Text)    begin    end;}