Page 9249 Analysis by Dimensions Matrix
src/Layers/W1/BaseApp/Finance/Analysis/AnalysisbyDimensionsMatrix.Page.al1,741 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.Setup;using Microsoft.Foundation.Period;using System.Utilities;/// <summary>/// Matrix page displaying analysis data in a grid format with configurable dimensions./// Provides interactive drill-down capabilities and dynamic column generation for multi-dimensional analysis./// </summary>/// <remarks>/// Used by Analysis by Dimensions to display financial data in matrix format./// Supports up to 32 matrix columns with dynamic captions and drill-down to underlying entries./// </remarks>page 9249 "Analysis by Dimensions Matrix"{ Caption = 'Analysis by Dimensions Matrix'; DataCaptionExpression = AnalysisViewCode; DeleteAllowed = false; Editable = false; InsertAllowed = false; LinksAllowed = false; ModifyAllowed = false; PageType = List; SourceTable = "Dimension Code Buffer"; SourceTableTemporary = true; layout { area(content) { repeater(Control1) { IndentationColumn = Rec.Indentation; IndentationControls = Name; ShowCaption = false; field("Code"; Rec.Code) { ApplicationArea = Dimensions; Style = Strong; StyleExpr = Emphasize; trigger OnLookup(var Text: Text): Boolean begin LookupDimCode(AnalysisByDimParameters."Line Dim Option", LineDimCode, Rec.Code); end; } field(Name; Rec.Name) { ApplicationArea = Dimensions; Style = Strong; StyleExpr = Emphasize; } field(TotalAmount; Rec.Amount) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; Caption = 'Total Amount'; Style = Strong; StyleExpr = Emphasize; ToolTip = 'Specifies the total amount for the amount type that you select in the Show field in the Options FastTab.'; trigger OnDrillDown() begin DrillDown(false); end; } field(Field1; MATRIX_CellData[1]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[1]; Style = Strong; StyleExpr = Emphasize; Visible = Field1Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(1); DrillDown(true); end; } field(Field2; MATRIX_CellData[2]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[2]; Style = Strong; StyleExpr = Emphasize; Visible = Field2Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(2); DrillDown(true); end; } field(Field3; MATRIX_CellData[3]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[3]; Style = Strong; StyleExpr = Emphasize; Visible = Field3Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(3); DrillDown(true); end; } field(Field4; MATRIX_CellData[4]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[4]; Style = Strong; StyleExpr = Emphasize; Visible = Field4Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(4); DrillDown(true); end; } field(Field5; MATRIX_CellData[5]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[5]; Style = Strong; StyleExpr = Emphasize; Visible = Field5Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(5); DrillDown(true); end; } field(Field6; MATRIX_CellData[6]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[6]; Style = Strong; StyleExpr = Emphasize; Visible = Field6Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(6); DrillDown(true); end; } field(Field7; MATRIX_CellData[7]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[7]; Style = Strong; StyleExpr = Emphasize; Visible = Field7Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(7); DrillDown(true); end; } field(Field8; MATRIX_CellData[8]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[8]; Style = Strong; StyleExpr = Emphasize; Visible = Field8Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(8); DrillDown(true); end; } field(Field9; MATRIX_CellData[9]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[9]; Style = Strong; StyleExpr = Emphasize; Visible = Field9Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(9); DrillDown(true); end; } field(Field10; MATRIX_CellData[10]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[10]; Style = Strong; StyleExpr = Emphasize; Visible = Field10Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(10); DrillDown(true); end; } field(Field11; MATRIX_CellData[11]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[11]; Style = Strong; StyleExpr = Emphasize; Visible = Field11Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(11); DrillDown(true); end; } field(Field12; MATRIX_CellData[12]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[12]; Style = Strong; StyleExpr = Emphasize; Visible = Field12Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(12); DrillDown(true); end; } field(Field13; MATRIX_CellData[13]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[13]; Style = Strong; StyleExpr = Emphasize; Visible = Field13Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(13); DrillDown(true); end; } field(Field14; MATRIX_CellData[14]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[14]; Style = Strong; StyleExpr = Emphasize; Visible = Field14Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(14); DrillDown(true); end; } field(Field15; MATRIX_CellData[15]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[15]; Style = Strong; StyleExpr = Emphasize; Visible = Field15Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(15); DrillDown(true); end; } field(Field16; MATRIX_CellData[16]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[16]; Style = Strong; StyleExpr = Emphasize; Visible = Field16Visible; trigger OnAssistEdit() begin MATRIX_UpdateMatrixRecord(16); DrillDown(true); end; } field(Field17; MATRIX_CellData[17]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[17]; Style = Strong; StyleExpr = Emphasize; Visible = Field17Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(17); DrillDown(true); end; } field(Field18; MATRIX_CellData[18]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[18]; Style = Strong; StyleExpr = Emphasize; Visible = Field18Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(18); DrillDown(true); end; } field(Field19; MATRIX_CellData[19]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[19]; Style = Strong; StyleExpr = Emphasize; Visible = Field19Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(19); DrillDown(true); end; } field(Field20; MATRIX_CellData[20]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[20]; Style = Strong; StyleExpr = Emphasize; Visible = Field20Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(20); DrillDown(true); end; } field(Field21; MATRIX_CellData[21]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[21]; Style = Strong; StyleExpr = Emphasize; Visible = Field21Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(21); DrillDown(true); end; } field(Field22; MATRIX_CellData[22]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[22]; Style = Strong; StyleExpr = Emphasize; Visible = Field22Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(22); DrillDown(true); end; } field(Field23; MATRIX_CellData[23]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[23]; Style = Strong; StyleExpr = Emphasize; Visible = Field23Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(23); DrillDown(true); end; } field(Field24; MATRIX_CellData[24]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[24]; Style = Strong; StyleExpr = Emphasize; Visible = Field24Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(24); DrillDown(true); end; } field(Field25; MATRIX_CellData[25]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[25]; Style = Strong; StyleExpr = Emphasize; Visible = Field25Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(25); DrillDown(true); end; } field(Field26; MATRIX_CellData[26]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[26]; Style = Strong; StyleExpr = Emphasize; Visible = Field26Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(26); DrillDown(true); end; } field(Field27; MATRIX_CellData[27]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[27]; Style = Strong; StyleExpr = Emphasize; Visible = Field27Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(27); DrillDown(true); end; } field(Field28; MATRIX_CellData[28]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[28]; Style = Strong; StyleExpr = Emphasize; Visible = Field28Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(28); DrillDown(true); end; } field(Field29; MATRIX_CellData[29]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[29]; Style = Strong; StyleExpr = Emphasize; Visible = Field29Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(29); DrillDown(true); end; } field(Field30; MATRIX_CellData[30]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[30]; Style = Strong; StyleExpr = Emphasize; Visible = Field30Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(30); DrillDown(true); end; } field(Field31; MATRIX_CellData[31]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[31]; Style = Strong; StyleExpr = Emphasize; Visible = Field31Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(31); DrillDown(true); end; } field(Field32; MATRIX_CellData[32]) { ApplicationArea = Dimensions; AutoFormatExpression = FormatStr(); AutoFormatType = 11; BlankZero = true; CaptionClass = '3,' + ColumnCaptions[32]; Style = Strong; StyleExpr = Emphasize; Visible = Field32Visible; trigger OnDrillDown() begin MATRIX_UpdateMatrixRecord(32); DrillDown(true); end; } } } } actions { area(navigation) { group("&Actions") { Caption = '&Actions'; Image = "Action"; action(ExportToExcel) { ApplicationArea = Dimensions; Caption = 'Export to Excel'; Image = ExportToExcel; ToolTip = 'Export the information in the analysis report to Excel.'; trigger OnAction() var AnalysisViewEntry: Record "Analysis View Entry"; AnalysisViewToExcel: Codeunit "Export Analysis View"; begin SetCommonFilters(AnalysisViewEntry); if (not AnalysisViewEntry.Find('-')) and (AnalysisByDimParameters."Show Actual/Budgets" = AnalysisByDimParameters."Show Actual/Budgets"::"Actual Amounts") then Error(NoEntriesToExportToExcelErr); AnalysisViewToExcel.ExportData(AnalysisViewEntry, AnalysisByDimParameters); end; } } } area(Promoted) { group(Category_Process) { Caption = 'Process'; actionref(ExportToExcel_Promoted; ExportToExcel) { } } } } trigger OnAfterGetRecord() var MATRIX_CurrentColumnOrdinal: Integer; MATRIX_Steps: Integer; begin Rec.Amount := MatrixMgt.RoundAmount(CalcAmount(false), AnalysisByDimParameters."Rounding Factor"); MATRIX_CurrentColumnOrdinal := 0; if MATRIX_PrimKeyFirstCol <> '' then TempDimensionCodeBuffer.SetPosition(MATRIX_PrimKeyFirstCol); if MATRIX_OnFindRecord('=><') then begin MATRIX_CurrentColumnOrdinal := 1; repeat MATRIX_ColumnOrdinal := MATRIX_CurrentColumnOrdinal; MATRIX_OnAfterGetRecord(); MATRIX_Steps := MATRIX_OnNextRecord(1); MATRIX_CurrentColumnOrdinal := MATRIX_CurrentColumnOrdinal + MATRIX_Steps; until (MATRIX_CurrentColumnOrdinal - MATRIX_Steps = MATRIX_NoOfMatrixColumns) or (MATRIX_Steps = 0); if MATRIX_CurrentColumnOrdinal <> 1 then MATRIX_OnNextRecord(1 - MATRIX_CurrentColumnOrdinal); end; SetVisible(); FormatLine(); end; trigger OnFindRecord(Which: Text): Boolean begin exit(FindRec(AnalysisByDimParameters."Line Dim Option", Rec, Which)); end; trigger OnInit() begin Field32Visible := true; Field31Visible := true; Field30Visible := true; Field29Visible := true; Field28Visible := true; Field27Visible := true; Field26Visible := true; Field25Visible := true; Field24Visible := true; Field23Visible := true; Field22Visible := true; Field21Visible := true; Field20Visible := true; Field19Visible := true; Field18Visible := true; Field17Visible := true; Field16Visible := true; Field15Visible := true; Field14Visible := true; Field13Visible := true; Field12Visible := true; Field11Visible := true; Field10Visible := true; Field9Visible := true; Field8Visible := true; Field7Visible := true; Field6Visible := true; Field5Visible := true; Field4Visible := true; Field3Visible := true; Field2Visible := true; Field1Visible := true; end; trigger OnNextRecord(Steps: Integer): Integer begin exit(NextRecord(AnalysisByDimParameters."Line Dim Option", Rec, Steps)); end; trigger OnOpenPage() var CashFlowForecast: Record "Cash Flow Forecast"; GLAcc: Record "G/L Account"; begin MATRIX_NoOfMatrixColumns := ArrayLen(MATRIX_CellData); ValidateAnalysisViewCode(); InitRecord(Rec, AnalysisByDimParameters."Line Dim Option"); InitRecord(TempDimensionCodeBuffer, AnalysisByDimParameters."Column Dim Option"); if (LineDimCode = '') and (ColumnDimCode = '') then begin case AnalysisByDimParameters."Analysis Account Source" of AnalysisByDimParameters."Analysis Account Source"::"G/L Account": LineDimCode := GLAcc.TableCaption; AnalysisByDimParameters."Analysis Account Source"::"Cash Flow Account": LineDimCode := CashFlowForecast.TableCaption(); else OnOpenPageOnAccountSourceElseCase(AnalysisView, LineDimCode); end; ColumnDimCode := Text000; end; CalculateClosingDateFilter(); SetVisible(); if AnalysisByDimParameters."Line Dim Option" = AnalysisByDimParameters."Line Dim Option"::Period then Rec.Code := ''; end; var#pragma warning disable AA0074 Text000: Label 'Period'; Text002: Label 'You have not yet defined an analysis view.';#pragma warning restore AA0074 TempDimensionCodeBuffer: Record "Dimension Code Buffer" temporary; GLSetup: Record "General Ledger Setup"; AnalysisView: Record "Analysis View"; AnalysisViewEntry: Record "Analysis View Entry"; AnalysisViewBudgetEntry: Record "Analysis View Budget Entry"; TempDimensionCodeAmountBuffer: Record "Dimension Code Amount Buffer" temporary; Currency: Record Currency; CurrExchRate: Record "Currency Exchange Rate"; PeriodOption: Record Date; MatrixMgt: Codeunit "Matrix Management"; AnalysisViewCode: Code[10]; LineDimCode: Text[30]; ColumnDimCode: Text[30]; ExcludeClosingDateFilter: Text; MATRIX_CellData: array[32] of Decimal; MATRIX_PrimKeyFirstCol: Text[1024]; MatrixAmount: Decimal; CurrExchDate: Date; MATRIX_ColumnOrdinal: Integer; MATRIX_NoOfMatrixColumns: Integer; ColumnCaptions: array[32] of Text[250]; RoundingFactorFormatString: Text; Field1Visible: Boolean; Field2Visible: Boolean; Field3Visible: Boolean; Field4Visible: Boolean; Field5Visible: Boolean; Field6Visible: Boolean; Field7Visible: Boolean; Field8Visible: Boolean; Field9Visible: Boolean; Field10Visible: Boolean; Field11Visible: Boolean; Field12Visible: Boolean; Field13Visible: Boolean; Field14Visible: Boolean; Field15Visible: Boolean; Field16Visible: Boolean; Field17Visible: Boolean; Field18Visible: Boolean; Field19Visible: Boolean; Field20Visible: Boolean; Field21Visible: Boolean; Field22Visible: Boolean; Field23Visible: Boolean; Field24Visible: Boolean; Field25Visible: Boolean; Field26Visible: Boolean; Field27Visible: Boolean; Field28Visible: Boolean; Field29Visible: Boolean; Field30Visible: Boolean; Field31Visible: Boolean; Field32Visible: Boolean;#pragma warning disable AA0074#pragma warning disable AA0470 Text003: Label 'Unsupported Account Source %1.';#pragma warning restore AA0470#pragma warning restore AA0074 NoEntriesToExportToExcelErr: Label 'There are no entries to export to Excel.'; protected var AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; Emphasize: Boolean; local procedure InitRecord(var DimCodeBuf: Record "Dimension Code Buffer"; DimOption: Enum "Analysis Dimension Option") var GLAccount: Record "G/L Account"; CashFlowAccount: Record "Cash Flow Account"; BusinessUnit: Record "Business Unit"; CashFlowForecast: Record "Cash Flow Forecast"; begin case DimOption of DimOption::"G/L Account": begin if AnalysisByDimParameters."Account Filter" <> '' then GLAccount.SetFilter("No.", AnalysisByDimParameters."Account Filter"); if GLAccount.FindSet() then repeat CopyGLAccToBuf(GLAccount, DimCodeBuf); until GLAccount.Next() = 0; end; DimOption::"Cash Flow Account": begin if AnalysisByDimParameters."Account Filter" <> '' then CashFlowAccount.SetFilter("No.", AnalysisByDimParameters."Account Filter"); if CashFlowAccount.FindSet() then repeat CopyCFAccToBuf(CashFlowAccount, DimCodeBuf); until CashFlowAccount.Next() = 0; end; DimOption::Period: begin PeriodOption.SetRange("Period Type", AnalysisByDimParameters."Period Type"); if AnalysisByDimParameters."Date Filter" <> '' then begin PeriodOption.FilterGroup(2); PeriodOption.SetFilter("Period Start", AnalysisByDimParameters."Date Filter"); PeriodOption.FilterGroup(0); end; end; DimOption::"Business Unit": begin if AnalysisByDimParameters."Bus. Unit Filter" <> '' then BusinessUnit.SetFilter(Code, AnalysisByDimParameters."Bus. Unit Filter"); if BusinessUnit.FindSet() then repeat CopyBusUnitToBuf(BusinessUnit, DimCodeBuf); until BusinessUnit.Next() = 0; end; DimOption::"Cash Flow Forecast": begin if AnalysisByDimParameters."Cash Flow Forecast Filter" <> '' then CashFlowForecast.SetFilter("No.", AnalysisByDimParameters."Cash Flow Forecast Filter"); if CashFlowForecast.FindSet() then repeat CopyCashFlowToBuf(CashFlowForecast, DimCodeBuf); until CashFlowForecast.Next() = 0; end; DimOption::"Dimension 1": InitDimValue( DimCodeBuf, AnalysisView."Dimension 1 Code", AnalysisByDimParameters."Dimension 1 Filter"); DimOption::"Dimension 2": InitDimValue( DimCodeBuf, AnalysisView."Dimension 2 Code", AnalysisByDimParameters."Dimension 2 Filter"); DimOption::"Dimension 3": InitDimValue( DimCodeBuf, AnalysisView."Dimension 3 Code", AnalysisByDimParameters."Dimension 3 Filter"); DimOption::"Dimension 4": InitDimValue( DimCodeBuf, AnalysisView."Dimension 4 Code", AnalysisByDimParameters."Dimension 4 Filter"); else RunOnInitRecordOnCaseElse(DimOption, DimCodeBuf, AnalysisView, AnalysisByDimParameters); end; if Rec.FindFirst() then; end; local procedure RunOnInitRecordOnCaseElse(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; var AnalysisView: Record "Analysis View"; var AnalysisByDimParameters: Record "Analysis by Dim. Parameters") begin OnInitRecordOnCaseElse(DimOption, DimCodeBuf, AnalysisView, AnalysisByDimParameters); end; local procedure FindRec(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Which: Text[250]) Result: Boolean begin case DimOption of DimOption::"G/L Account", DimOption::"Cash Flow Account", DimOption::"Business Unit", DimOption::"Cash Flow Forecast", DimOption::"Dimension 1", DimOption::"Dimension 2", DimOption::"Dimension 3", DimOption::"Dimension 4": exit(DimCodeBuf.Find(Which)); DimOption::Period: // Make specifial length of Which parameter in order to find PeriodPageMgt.FindDate procedure exit(FindPeriod(DimCodeBuf, CopyStr(Which, 1, 3))); else OnFindRecOnCaseElse(DimOption, Which, DimCodeBuf, Result); end; end; local procedure NextRecord(DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer"; Steps: Integer) Result: Integer begin case DimOption of DimOption::"G/L Account", DimOption::"Cash Flow Account", DimOption::"Business Unit", DimOption::"Cash Flow Forecast", DimOption::"Dimension 1", DimOption::"Dimension 2", DimOption::"Dimension 3", DimOption::"Dimension 4": exit(DimCodeBuf.Next(Steps)); DimOption::Period: exit(NextPeriod(DimCodeBuf, Steps)); else OnNextRecOnCaseElse(DimOption, Steps, DimCodeBuf, Result); end; 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; TheDimCodeBuf.Insert(); 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; TheDimCodeBuf.Insert(); 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 AnalysisByDimParameters."Closing Entries" = AnalysisByDimParameters."Closing Entries"::Include then TheDimCodeBuf."Period End" := ClosingDate(ThePeriod."Period End") else TheDimCodeBuf."Period End" := ThePeriod."Period End"; if AnalysisByDimParameters."Date Filter" <> '' then begin Period2.SetFilter("Period End", AnalysisByDimParameters."Date Filter"); if Period2.GetRangeMax("Period End") < TheDimCodeBuf."Period End" then TheDimCodeBuf."Period End" := Period2.GetRangeMax("Period End"); end; TheDimCodeBuf.Name := ThePeriod."Period Name"; if TheDimCodeBuf.Insert() then; 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; TheDimCodeBuf.Insert(); 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; TheDimCodeBuf.Insert(); 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; TheDimCodeBuf.Insert(); end; local procedure CalculateClosingDateFilter() var AccountingPeriod: Record "Accounting Period"; FirstRec: Boolean; begin if AnalysisByDimParameters."Closing Entries" = AnalysisByDimParameters."Closing Entries"::Include then ExcludeClosingDateFilter := '' else begin AccountingPeriod.SetCurrentKey("New Fiscal Year"); AccountingPeriod.SetRange("New Fiscal Year", true); FirstRec := true; if AccountingPeriod.Find('-') then repeat if FirstRec then ExcludeClosingDateFilter := StrSubstNo('<>%1', ClosingDate(AccountingPeriod."Starting Date" - 1)) else ExcludeClosingDateFilter := ExcludeClosingDateFilter + StrSubstNo('&<>%1', ClosingDate(AccountingPeriod."Starting Date" - 1)); FirstRec := false; until AccountingPeriod.Next() = 0; end; end; local procedure LookupDimCode(DimOption: Enum "Analysis Dimension Option"; DimCode: Text[30]; "Code": Text[30]) var GLAcc: Record "G/L Account"; BusUnit: Record "Business Unit"; CFAccount: Record "Cash Flow Account"; CashFlowForecast: Record "Cash Flow Forecast"; DimVal: Record "Dimension Value"; begin case DimOption of DimOption::"G/L Account": begin GLAcc.Get(Code); PAGE.RunModal(PAGE::"G/L Account List", GLAcc); end; DimOption::Period: ; DimOption::"Business Unit": begin BusUnit.Get(Code); PAGE.RunModal(PAGE::"Business Unit List", BusUnit); end; DimOption::"Cash Flow Account": begin CFAccount.Get(Code); PAGE.RunModal(PAGE::"Cash Flow Account List", CFAccount); end; DimOption::"Cash Flow Forecast": begin CashFlowForecast.Get(Code); PAGE.RunModal(PAGE::"Cash Flow Forecast List", CashFlowForecast); end; DimOption::"Dimension 1", DimOption::"Dimension 2", DimOption::"Dimension 3", DimOption::"Dimension 4": begin DimVal.SetRange("Dimension Code", DimCode); DimVal.Get(DimCode, Code); PAGE.RunModal(PAGE::"Dimension Value List", DimVal); end; else RunOnLookupDimCodeOnCaseElse(DimOption, Code); end; end; local procedure RunOnLookupDimCodeOnCaseElse(DimOption: Enum "Analysis Dimension Option"; var "Code": Text[30]) begin OnLookupDimCodeOnCaseElse(DimOption, Code); end; local procedure SetCommonFilters(var TheAnalysisViewEntry: Record "Analysis View Entry") var DateFilter2: Text; begin if AnalysisByDimParameters."Date Filter" = '' then DateFilter2 := ExcludeClosingDateFilter else begin if AnalysisByDimParameters."Amount Type" = AnalysisByDimParameters."Amount Type"::"Net Change" then DateFilter2 := AnalysisByDimParameters."Date Filter" else begin TheAnalysisViewEntry.SetFilter("Posting Date", AnalysisByDimParameters."Date Filter"); DateFilter2 := StrSubstNo('..%1', TheAnalysisViewEntry.GetRangeMax("Posting Date")); end; if ExcludeClosingDateFilter <> '' then DateFilter2 := StrSubstNo('%1 & %2', DateFilter2, ExcludeClosingDateFilter); end; TheAnalysisViewEntry.Reset(); TheAnalysisViewEntry.SetRange("Analysis View Code", AnalysisView.Code); if AnalysisByDimParameters."Bus. Unit Filter" <> '' then TheAnalysisViewEntry.SetFilter("Business Unit Code", AnalysisByDimParameters."Bus. Unit Filter"); if AnalysisByDimParameters."Cash Flow Forecast Filter" <> '' then TheAnalysisViewEntry.SetFilter("Cash Flow Forecast No.", AnalysisByDimParameters."Cash Flow Forecast Filter"); if AnalysisByDimParameters."Account Filter" <> '' then TheAnalysisViewEntry.SetFilter("Account No.", AnalysisByDimParameters."Account Filter"); TheAnalysisViewEntry.SetRange("Account Source", AnalysisByDimParameters."Analysis Account Source"); TheAnalysisViewEntry.SetFilter("Posting Date", DateFilter2); if AnalysisByDimParameters."Dimension 1 Filter" <> '' then TheAnalysisViewEntry.SetFilter("Dimension 1 Value Code", GetDimValueTotaling(AnalysisByDimParameters."Dimension 1 Filter", AnalysisView."Dimension 1 Code")); if AnalysisByDimParameters."Dimension 2 Filter" <> '' then TheAnalysisViewEntry.SetFilter("Dimension 2 Value Code", GetDimValueTotaling(AnalysisByDimParameters."Dimension 2 Filter", AnalysisView."Dimension 2 Code")); if AnalysisByDimParameters."Dimension 3 Filter" <> '' then TheAnalysisViewEntry.SetFilter("Dimension 3 Value Code", GetDimValueTotaling(AnalysisByDimParameters."Dimension 3 Filter", AnalysisView."Dimension 3 Code")); if AnalysisByDimParameters."Dimension 4 Filter" <> '' then TheAnalysisViewEntry.SetFilter("Dimension 4 Value Code", GetDimValueTotaling(AnalysisByDimParameters."Dimension 4 Filter", AnalysisView."Dimension 4 Code")); OnAfterSetCommonFilters(TheAnalysisViewEntry, AnalysisByDimParameters); end; local procedure SetDimFilters(var TheAnalysisViewEntry: Record "Analysis View Entry"; LineOrColumn: Option Line,Column) var DimCodeBuf: Record "Dimension Code Buffer"; DimOption: Enum "Analysis Dimension Option"; begin if LineOrColumn = LineOrColumn::Line then begin DimCodeBuf := Rec; DimOption := AnalysisByDimParameters."Line Dim Option"; end else begin DimCodeBuf := TempDimensionCodeBuffer; DimOption := AnalysisByDimParameters."Column Dim Option"; end; case DimOption of DimOption::"G/L Account", DimOption::"Cash Flow Account": if DimCodeBuf.Totaling = '' then TheAnalysisViewEntry.SetRange("Account No.", DimCodeBuf.Code) else TheAnalysisViewEntry.SetFilter("Account No.", DimCodeBuf.Totaling); DimOption::Period: begin if AnalysisByDimParameters."Amount Type" = AnalysisByDimParameters."Amount Type"::"Net Change" then TheAnalysisViewEntry.SetRange( "Posting Date", DimCodeBuf."Period Start", DimCodeBuf."Period End") else TheAnalysisViewEntry.SetRange("Posting Date", 0D, DimCodeBuf."Period End"); if (AnalysisByDimParameters."Closing Entries" = AnalysisByDimParameters."Closing Entries"::Exclude) and (ExcludeClosingDateFilter <> '') then TheAnalysisViewEntry.SetFilter( "Posting Date", TheAnalysisViewEntry.GetFilter("Posting Date") + '&' + ExcludeClosingDateFilter); end; DimOption::"Business Unit": TheAnalysisViewEntry.SetRange("Business Unit Code", DimCodeBuf.Code); DimOption::"Cash Flow Forecast": TheAnalysisViewEntry.SetRange("Cash Flow Forecast No.", DimCodeBuf.Code); DimOption::"Dimension 1": if DimCodeBuf.Totaling = '' then TheAnalysisViewEntry.SetRange("Dimension 1 Value Code", DimCodeBuf.Code) else TheAnalysisViewEntry.SetFilter("Dimension 1 Value Code", DimCodeBuf.Totaling); DimOption::"Dimension 2": if DimCodeBuf.Totaling = '' then TheAnalysisViewEntry.SetRange("Dimension 2 Value Code", DimCodeBuf.Code) else TheAnalysisViewEntry.SetFilter("Dimension 2 Value Code", DimCodeBuf.Totaling); DimOption::"Dimension 3": if DimCodeBuf.Totaling = '' then TheAnalysisViewEntry.SetRange("Dimension 3 Value Code", DimCodeBuf.Code) else TheAnalysisViewEntry.SetFilter("Dimension 3 Value Code", DimCodeBuf.Totaling); DimOption::"Dimension 4": if DimCodeBuf.Totaling = '' then TheAnalysisViewEntry.SetRange("Dimension 4 Value Code", DimCodeBuf.Code) else TheAnalysisViewEntry.SetFilter("Dimension 4 Value Code", DimCodeBuf.Totaling); end; OnAfterSetDimFiltersProcedure(TheAnalysisViewEntry, AnalysisView, DimOption, DimCodeBuf); end; local procedure SetCommonBudgetFilters(var TheAnalysisViewBudgetEntry: Record "Analysis View Budget Entry") begin TheAnalysisViewBudgetEntry.Reset(); TheAnalysisViewBudgetEntry.SetRange("Analysis View Code", AnalysisView.Code); if AnalysisByDimParameters."Bus. Unit Filter" <> '' then TheAnalysisViewBudgetEntry.SetFilter("Business Unit Code", AnalysisByDimParameters."Bus. Unit Filter"); if AnalysisByDimParameters."Budget Filter" <> '' then TheAnalysisViewBudgetEntry.SetFilter("Budget Name", AnalysisByDimParameters."Budget Filter"); if AnalysisByDimParameters."Account Filter" <> '' then TheAnalysisViewBudgetEntry.SetFilter("G/L Account No.", AnalysisByDimParameters."Account Filter"); if AnalysisByDimParameters."Date Filter" <> '' then TheAnalysisViewBudgetEntry.SetFilter("Posting Date", AnalysisByDimParameters."Date Filter"); if AnalysisByDimParameters."Dimension 1 Filter" <> '' then TheAnalysisViewBudgetEntry.SetFilter("Dimension 1 Value Code", GetDimValueTotaling(AnalysisByDimParameters."Dimension 1 Filter", AnalysisView."Dimension 1 Code")); if AnalysisByDimParameters."Dimension 2 Filter" <> '' then TheAnalysisViewBudgetEntry.SetFilter("Dimension 2 Value Code", GetDimValueTotaling(AnalysisByDimParameters."Dimension 2 Filter", AnalysisView."Dimension 2 Code")); if AnalysisByDimParameters."Dimension 3 Filter" <> '' then TheAnalysisViewBudgetEntry.SetFilter("Dimension 3 Value Code", GetDimValueTotaling(AnalysisByDimParameters."Dimension 3 Filter", AnalysisView."Dimension 3 Code")); if AnalysisByDimParameters."Dimension 4 Filter" <> '' then TheAnalysisViewBudgetEntry.SetFilter("Dimension 4 Value Code", GetDimValueTotaling(AnalysisByDimParameters."Dimension 4 Filter", AnalysisView."Dimension 4 Code")); OnAfterSetCommonBudgetFilters(TheAnalysisViewBudgetEntry, AnalysisByDimParameters); end; local procedure SetDimBudgetFilters(var TheAnalysisViewBudgetEntry: Record "Analysis View Budget Entry"; LineOrColumn: Option Line,Column) var DimCodeBuf: Record "Dimension Code Buffer"; DimOption: Enum "Analysis Dimension Option"; begin if LineOrColumn = LineOrColumn::Line then begin DimCodeBuf := Rec; DimOption := AnalysisByDimParameters."Line Dim Option"; end else begin DimCodeBuf := TempDimensionCodeBuffer; DimOption := AnalysisByDimParameters."Column Dim Option"; end; case DimOption of DimOption::"G/L Account": if DimCodeBuf.Totaling = '' then TheAnalysisViewBudgetEntry.SetRange("G/L Account No.", DimCodeBuf.Code) else TheAnalysisViewBudgetEntry.SetFilter("G/L Account No.", DimCodeBuf.Totaling); DimOption::Period: if AnalysisByDimParameters."Amount Type" = AnalysisByDimParameters."Amount Type"::"Net Change" then TheAnalysisViewBudgetEntry.SetRange( "Posting Date", DimCodeBuf."Period Start", DimCodeBuf."Period End") else TheAnalysisViewBudgetEntry.SetRange("Posting Date", 0D, DimCodeBuf."Period End"); DimOption::"Business Unit": TheAnalysisViewBudgetEntry.SetRange("Business Unit Code", DimCodeBuf.Code); DimOption::"Dimension 1": if DimCodeBuf.Totaling = '' then TheAnalysisViewBudgetEntry.SetRange("Dimension 1 Value Code", DimCodeBuf.Code) else TheAnalysisViewBudgetEntry.SetFilter("Dimension 1 Value Code", DimCodeBuf.Totaling); DimOption::"Dimension 2": if DimCodeBuf.Totaling = '' then TheAnalysisViewBudgetEntry.SetRange("Dimension 2 Value Code", DimCodeBuf.Code) else TheAnalysisViewBudgetEntry.SetFilter("Dimension 2 Value Code", DimCodeBuf.Totaling); DimOption::"Dimension 3": if DimCodeBuf.Totaling = '' then TheAnalysisViewBudgetEntry.SetRange("Dimension 3 Value Code", DimCodeBuf.Code) else TheAnalysisViewBudgetEntry.SetFilter("Dimension 3 Value Code", DimCodeBuf.Totaling); DimOption::"Dimension 4": if DimCodeBuf.Totaling = '' then TheAnalysisViewBudgetEntry.SetRange("Dimension 4 Value Code", DimCodeBuf.Code) else TheAnalysisViewBudgetEntry.SetFilter("Dimension 4 Value Code", DimCodeBuf.Totaling); end; OnAfterSetDimBudgetFiltersProcedure(TheAnalysisViewBudgetEntry, AnalysisView, DimOption, DimCodeBuf); end; local procedure DrillDown(SetColFilter: Boolean) begin if AnalysisByDimParameters."Show Actual/Budgets" = AnalysisByDimParameters."Show Actual/Budgets"::"Actual Amounts" then begin SetCommonFilters(AnalysisViewEntry); SetDimFilters(AnalysisViewEntry, 0); if SetColFilter then SetDimFilters(AnalysisViewEntry, 1); PAGE.Run(PAGE::"Analysis View Entries", AnalysisViewEntry); end; if AnalysisByDimParameters."Show Actual/Budgets" = AnalysisByDimParameters."Show Actual/Budgets"::"Budgeted Amounts" then begin SetCommonBudgetFilters(AnalysisViewBudgetEntry); SetDimBudgetFilters(AnalysisViewBudgetEntry, 0); if SetColFilter then SetDimBudgetFilters(AnalysisViewBudgetEntry, 1); PAGE.Run(PAGE::"Analysis View Budget Entries", AnalysisViewBudgetEntry); end; end; local procedure ValidateAnalysisViewCode() var IsSupported: Boolean; begin AnalysisView.Code := AnalysisViewCode; if not AnalysisView.Find('=<>') then Error(Text002); AnalysisViewCode := AnalysisView.Code; if not (AnalysisByDimParameters."Analysis Account Source" in [AnalysisByDimParameters."Analysis Account Source"::"G/L Account", AnalysisByDimParameters."Analysis Account Source"::"Cash Flow Account"]) then begin AnalysisView.OnGetAnalysisViewSupported(AnalysisView, IsSupported); if not IsSupported then Error(Text003, AnalysisView."Account Source"); end; end; local procedure CalcAmount(SetColFilter: Boolean): Decimal var Amount: Decimal; ColumnCode: Code[20]; begin if SetColFilter then ColumnCode := TempDimensionCodeBuffer.Code else ColumnCode := ''; if TempDimensionCodeAmountBuffer.Get(Rec.Code, ColumnCode) then exit(TempDimensionCodeAmountBuffer.Amount); case AnalysisByDimParameters."Show Actual/Budgets" of AnalysisByDimParameters."Show Actual/Budgets"::"Actual Amounts": Amount := CalcActualAmount(SetColFilter); AnalysisByDimParameters."Show Actual/Budgets"::"Budgeted Amounts": Amount := CalcBudgAmount(SetColFilter); AnalysisByDimParameters."Show Actual/Budgets"::Variance: Amount := CalcActualAmount(SetColFilter) - CalcBudgAmount(SetColFilter); AnalysisByDimParameters."Show Actual/Budgets"::"Variance%": begin Amount := CalcBudgAmount(SetColFilter); if Amount <> 0 then Amount := Round(100 * (CalcActualAmount(SetColFilter) - Amount) / Amount); end; AnalysisByDimParameters."Show Actual/Budgets"::"Index%": begin Amount := CalcBudgAmount(SetColFilter); if Amount <> 0 then Amount := Round(100 * CalcActualAmount(SetColFilter) / Amount); end; end; if AnalysisByDimParameters."Show Opposite Sign" then Amount := -Amount; TempDimensionCodeAmountBuffer."Line Code" := Rec.Code; TempDimensionCodeAmountBuffer."Column Code" := ColumnCode; TempDimensionCodeAmountBuffer.Amount := Amount; TempDimensionCodeAmountBuffer.Insert(); exit(Amount); end; local procedure CalcActualAmount(SetColFilter: Boolean): Decimal var Amount: Decimal; begin AnalysisViewEntry.Reset(); SetCommonFilters(AnalysisViewEntry); SetDimFilters(AnalysisViewEntry, 0); if SetColFilter then SetDimFilters(AnalysisViewEntry, 1); if AnalysisByDimParameters."Show In Add. Currency" then case AnalysisByDimParameters."Show Amount Field" of AnalysisByDimParameters."Show Amount Field"::Amount: begin AnalysisViewEntry.CalcSums("Add.-Curr. Amount"); Amount := AnalysisViewEntry."Add.-Curr. Amount"; end; AnalysisByDimParameters."Show Amount Field"::"Debit Amount": begin AnalysisViewEntry.CalcSums("Add.-Curr. Debit Amount"); Amount := AnalysisViewEntry."Add.-Curr. Debit Amount"; end; AnalysisByDimParameters."Show Amount Field"::"Credit Amount": begin AnalysisViewEntry.CalcSums("Add.-Curr. Credit Amount"); Amount := AnalysisViewEntry."Add.-Curr. Credit Amount"; end; end else case AnalysisByDimParameters."Show Amount Field" of AnalysisByDimParameters."Show Amount Field"::Amount: begin AnalysisViewEntry.CalcSums(Amount); Amount := AnalysisViewEntry.Amount; end; AnalysisByDimParameters."Show Amount Field"::"Debit Amount": begin AnalysisViewEntry.CalcSums("Debit Amount"); Amount := AnalysisViewEntry."Debit Amount"; end; AnalysisByDimParameters."Show Amount Field"::"Credit Amount": begin AnalysisViewEntry.CalcSums("Credit Amount"); Amount := AnalysisViewEntry."Credit Amount"; end; end; OnAfterCalcActualAmount(AnalysisViewEntry, AnalysisByDimParameters, Amount); exit(Amount); end; local procedure CalcBudgAmount(SetColFilter: Boolean): Decimal var Amount: Decimal; begin AnalysisViewBudgetEntry.Reset(); SetCommonBudgetFilters(AnalysisViewBudgetEntry); SetDimBudgetFilters(AnalysisViewBudgetEntry, 0); if SetColFilter then SetDimBudgetFilters(AnalysisViewBudgetEntry, 1); AnalysisViewBudgetEntry.CalcSums(Amount); Amount := AnalysisViewBudgetEntry.Amount; case AnalysisByDimParameters."Show Amount Field" of AnalysisByDimParameters."Show Amount Field"::"Debit Amount": if Amount < 0 then Amount := 0; AnalysisByDimParameters."Show Amount Field"::"Credit Amount": if Amount > 0 then Amount := 0 else Amount := -Amount; end; if (Amount <> 0) and AnalysisByDimParameters."Show In Add. Currency" then begin if AnalysisViewBudgetEntry.GetFilter("Posting Date") = '' then CurrExchDate := WorkDate() else CurrExchDate := AnalysisViewBudgetEntry.GetRangeMin("Posting Date"); Amount := Round( CurrExchRate.ExchangeAmtLCYToFCY( CurrExchDate, GLSetup."Additional Reporting Currency", Amount, CurrExchRate.ExchangeRate(CurrExchDate, GLSetup."Additional Reporting Currency")), Currency."Amount Rounding Precision"); end; OnAfterCalcBudgetAmount(AnalysisViewBudgetEntry, AnalysisByDimParameters, Amount); exit(Amount); end; local procedure MATRIX_UpdateMatrixRecord(MATRIX_NewColumnOrdinal: Integer) begin MATRIX_ColumnOrdinal := MATRIX_NewColumnOrdinal; TempDimensionCodeBuffer.SetPosition(MATRIX_PrimKeyFirstCol); MATRIX_OnFindRecord('='); if MATRIX_ColumnOrdinal <> 1 then MATRIX_OnNextRecord(MATRIX_ColumnOrdinal - 1); end; local procedure MATRIX_OnFindRecord(Which: Text[1024]): Boolean begin exit(FindRec(AnalysisByDimParameters."Column Dim Option", TempDimensionCodeBuffer, Which)); end; local procedure MATRIX_OnNextRecord(Steps: Integer): Integer begin exit(NextRecord(AnalysisByDimParameters."Column Dim Option", TempDimensionCodeBuffer, Steps)); end; local procedure MATRIX_OnAfterGetRecord() begin MatrixAmount := MatrixMgt.RoundAmount(CalcAmount(true), AnalysisByDimParameters."Rounding Factor"); MATRIX_CellData[MATRIX_ColumnOrdinal] := MatrixAmount; end; /// <summary> /// Sets visibility properties for matrix columns based on column caption availability. /// Controls which matrix fields are displayed in the user interface. /// </summary> procedure SetVisible() begin Field1Visible := ColumnCaptions[1] <> ''; Field2Visible := ColumnCaptions[2] <> ''; Field3Visible := ColumnCaptions[3] <> ''; Field4Visible := ColumnCaptions[4] <> ''; Field5Visible := ColumnCaptions[5] <> ''; Field6Visible := ColumnCaptions[6] <> ''; Field7Visible := ColumnCaptions[7] <> ''; Field8Visible := ColumnCaptions[8] <> ''; Field9Visible := ColumnCaptions[9] <> ''; Field10Visible := ColumnCaptions[10] <> ''; Field11Visible := ColumnCaptions[11] <> ''; Field12Visible := ColumnCaptions[12] <> ''; Field13Visible := ColumnCaptions[13] <> ''; Field14Visible := ColumnCaptions[14] <> ''; Field15Visible := ColumnCaptions[15] <> ''; Field16Visible := ColumnCaptions[16] <> ''; Field17Visible := ColumnCaptions[17] <> ''; Field18Visible := ColumnCaptions[18] <> ''; Field19Visible := ColumnCaptions[19] <> ''; Field20Visible := ColumnCaptions[20] <> ''; Field21Visible := ColumnCaptions[21] <> ''; Field22Visible := ColumnCaptions[22] <> ''; Field23Visible := ColumnCaptions[23] <> ''; Field24Visible := ColumnCaptions[24] <> ''; Field25Visible := ColumnCaptions[25] <> ''; Field26Visible := ColumnCaptions[26] <> ''; Field27Visible := ColumnCaptions[27] <> ''; Field28Visible := ColumnCaptions[28] <> ''; Field29Visible := ColumnCaptions[29] <> ''; Field30Visible := ColumnCaptions[30] <> ''; Field31Visible := ColumnCaptions[31] <> ''; Field32Visible := ColumnCaptions[32] <> ''; end; /// <summary> /// Loads matrix parameters and configures column settings for analysis display. /// Initializes matrix captions, primary key values, and analysis parameters for data retrieval. /// </summary> /// <param name="NewAnalysisByDimParameters">Analysis parameters controlling data filtering and display options</param> /// <param name="LineDimCodeLocal">Dimension code for row grouping in the matrix</param> /// <param name="ColumnDimCodeLocal">Dimension code for column grouping in the matrix</param> /// <param name="NewMATRIX_ColumnCaptions">Array of column captions for matrix headers</param> /// <param name="NewPrimKeyFirstCol">Primary key value for first column in current column set</param> procedure Load(NewAnalysisByDimParameters: Record "Analysis by Dim. Parameters"; LineDimCodeLocal: Text[30]; ColumnDimCodeLocal: Text[30]; NewMATRIX_ColumnCaptions: array[32] of Text[250]; NewPrimKeyFirstCol: Text[1024]) begin AnalysisByDimParameters := NewAnalysisByDimParameters; AnalysisViewCode := AnalysisByDimParameters."Analysis View Code"; LineDimCode := LineDimCodeLocal; ColumnDimCode := ColumnDimCodeLocal; CopyArray(ColumnCaptions, NewMATRIX_ColumnCaptions, 1); MATRIX_PrimKeyFirstCol := NewPrimKeyFirstCol; RoundingFactorFormatString := MatrixMgt.FormatRoundingFactor(AnalysisByDimParameters."Rounding Factor", false); end; local procedure FormatLine() begin Emphasize := Rec."Show in Bold"; end; local procedure FindPeriod(var DimCodeBuf: Record "Dimension Code Buffer"; Which: Text[3]) Found: Boolean var PeriodPageMgt: Codeunit PeriodPageManagement; begin Evaluate(PeriodOption."Period Start", DimCodeBuf.Code); FilterLinePeriod(DimCodeBuf); Found := PeriodPageMgt.FindDate(Which, PeriodOption, AnalysisByDimParameters."Period Type"); if Found then CopyPeriodToBuf(PeriodOption, DimCodeBuf); exit(Found); end; local procedure NextPeriod(var DimCodeBuf: Record "Dimension Code Buffer"; Steps: Integer) ResultSteps: Integer var PeriodPageMgt: Codeunit PeriodPageManagement; begin Evaluate(PeriodOption."Period Start", DimCodeBuf.Code); FilterLinePeriod(DimCodeBuf); ResultSteps := PeriodPageMgt.NextDate(Steps, PeriodOption, AnalysisByDimParameters."Period Type"); if ResultSteps <> 0 then CopyPeriodToBuf(PeriodOption, DimCodeBuf); exit(ResultSteps); end; local procedure FilterLinePeriod(var DimCodeBuf: Record "Dimension Code Buffer") begin if AnalysisByDimParameters."Line Dim Option" = AnalysisByDimParameters."Line Dim Option"::Period then begin PeriodOption.SetRange("Period Start"); PeriodOption.SetRange("Period Name"); PeriodOption.SetFilter("Period Start", DimCodeBuf.GetFilter(Code)); PeriodOption.SetFilter("Period Name", DimCodeBuf.GetFilter(Name)); end; end; local procedure InitDimValue(var DimensionCodeBuffer: Record "Dimension Code Buffer"; DimensionCode: Code[20]; DimensionFilter: Text) var DimensionValue: Record "Dimension Value"; begin OnBeforeInitDimValue(DimensionValue); if DimensionCode <> '' then begin DimensionValue.SetRange("Dimension Code", DimensionCode); if DimensionFilter <> '' then DimensionValue.SetFilter(Code, DimensionFilter); if DimensionValue.FindSet() then repeat CopyDimValueToBuf(DimensionValue, DimensionCodeBuffer); until DimensionValue.Next() = 0; end; end; local procedure FormatStr(): Text begin exit(RoundingFactorFormatString); end; local procedure GetDimValueTotaling(DimValueFilter: Text; DimensionCode: Code[20]): Text var DimensionManagement: Codeunit DimensionManagement; begin DimensionManagement.ResolveDimValueFilter(DimValueFilter, DimensionCode); exit(DimValueFilter); end; /// <summary> /// Integration event raised after setting common filters on analysis view entries. /// Allows custom filtering logic to be applied to analysis view entry records. /// </summary> /// <param name="AnalysisViewEntry">Analysis view entry record with applied filters</param> /// <param name="AnalysisByDimParameters">Parameters controlling the analysis filtering</param> [IntegrationEvent(false, false)] local procedure OnAfterSetCommonFilters(var AnalysisViewEntry: Record "Analysis View Entry"; AnalysisByDimParameters: Record "Analysis by Dim. Parameters") begin end; /// <summary> /// Integration event raised after setting common filters on analysis view budget entries. /// Allows custom filtering logic to be applied to budget entry records. /// </summary> /// <param name="AnalysisViewBudgetEntry">Analysis view budget entry record with applied filters</param> /// <param name="AnalysisByDimParameters">Parameters controlling the analysis filtering</param> [IntegrationEvent(false, false)] local procedure OnAfterSetCommonBudgetFilters(var AnalysisViewBudgetEntry: Record "Analysis View Budget Entry"; AnalysisByDimParameters: Record "Analysis by Dim. Parameters") begin end; /// <summary> /// Integration event raised after calculating actual amounts for analysis view entries. /// Allows modification of calculated amounts based on custom business logic. /// </summary> /// <param name="AnalysisViewEntry">Analysis view entry record used in calculation</param> /// <param name="AnalysisByDimParameters">Parameters controlling the analysis calculation</param> /// <param name="Amount">Calculated amount that can be modified by subscribers</param> [IntegrationEvent(false, false)] local procedure OnAfterCalcActualAmount(var AnalysisViewEntry: Record "Analysis View Entry"; AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var Amount: Decimal) begin end; /// <summary> /// Integration event raised after calculating budget amounts for analysis view budget entries. /// Allows modification of calculated budget amounts based on custom business logic. /// </summary> /// <param name="AnalysisViewBudgetEntry">Analysis view budget entry record used in calculation</param> /// <param name="AnalysisByDimParameters">Parameters controlling the analysis calculation</param> /// <param name="Amount">Calculated budget amount that can be modified by subscribers</param> [IntegrationEvent(false, false)] local procedure OnAfterCalcBudgetAmount(var AnalysisViewBudgetEntry: Record "Analysis View Budget Entry"; AnalysisByDimParameters: Record "Analysis by Dim. Parameters"; var Amount: Decimal) begin end; /// <summary> /// Integration event raised after setting dimension filters on analysis view entries. /// Allows custom dimension filtering logic to be applied beyond standard filtering. /// </summary> /// <param name="TheAnalysisViewEntry">Analysis view entry record with dimension filters applied</param> /// <param name="AnalysisView">Analysis view configuration record</param> /// <param name="DimOption">Dimension option specifying which dimension is being filtered</param> /// <param name="DimCodeBuf">Dimension code buffer containing filter values</param> [IntegrationEvent(false, false)] local procedure OnAfterSetDimFiltersProcedure(var TheAnalysisViewEntry: Record "Analysis View Entry"; AnalysisView: Record "Analysis View"; DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer") begin end; /// <summary> /// Integration event raised after setting dimension filters on analysis view budget entries. /// Allows custom dimension filtering logic to be applied to budget entries beyond standard filtering. /// </summary> /// <param name="TheAnalysisViewBudgetEntry">Analysis view budget entry record with dimension filters applied</param> /// <param name="AnalysisView">Analysis view configuration record</param> /// <param name="DimOption">Dimension option specifying which dimension is being filtered</param> /// <param name="DimCodeBuf">Dimension code buffer containing filter values</param> [IntegrationEvent(false, false)] local procedure OnAfterSetDimBudgetFiltersProcedure(var TheAnalysisViewBudgetEntry: Record "Analysis View Budget Entry"; AnalysisView: Record "Analysis View"; DimOption: Enum "Analysis Dimension Option"; var DimCodeBuf: Record "Dimension Code Buffer") begin end; /// <summary> /// Integration event raised before initializing dimension value for analysis by dimensions matrix. /// Enables custom dimension value initialization logic. /// </summary> /// <param name="DimensionValue">Dimension Value record being initialized</param> [IntegrationEvent(true, false)] local procedure OnBeforeInitDimValue(var DimensionValue: Record "Dimension Value") begin end; /// <summary> /// Integration event raised for custom dimension option handling in record finding. /// Enables extensibility for additional dimension types beyond standard options. /// </summary> /// <param name="DimOption">Dimension option being processed</param> /// <param name="Which">Navigation direction or specific position</param> /// <param name="TheDimCodeBuf">Dimension code buffer for record operations</param> /// <param name="Result">Result of the find operation</param> [IntegrationEvent(true, false)] local procedure OnFindRecOnCaseElse(DimOption: Enum "Analysis Dimension Option"; Which: Text[250]; var TheDimCodeBuf: Record "Dimension Code Buffer"; var Result: Boolean) begin end; /// <summary> /// Integration event raised for custom dimension option handling in record navigation. /// Enables extensibility for additional dimension types in next record operations. /// </summary> /// <param name="DimOption">Dimension option being processed</param> /// <param name="Steps">Number of steps to navigate</param> /// <param name="TheDimCodeBuf">Dimension code buffer for navigation operations</param> /// <param name="Result">Number of steps actually taken</param> [IntegrationEvent(true, false)] local procedure OnNextRecOnCaseElse(DimOption: Enum "Analysis Dimension Option"; Steps: Integer; var TheDimCodeBuf: Record "Dimension Code Buffer"; var Result: Integer); begin end; /// <summary> /// Integration event raised for custom dimension option handling in record initialization. /// Enables extensibility for additional dimension types during record setup. /// </summary> /// <param name="DimOption">Dimension option being processed</param> /// <param name="TheDimCodeBuf">Dimension code buffer being initialized</param> /// <param name="AnalysisView">Analysis view configuration</param> /// <param name="AnalysisByDimParameters">Analysis by dimension parameters</param> [IntegrationEvent(true, false)] local procedure OnInitRecordOnCaseElse(DimOption: Enum "Analysis Dimension Option"; var TheDimCodeBuf: Record "Dimension Code Buffer"; var AnalysisView: Record "Analysis View"; var AnalysisByDimParameters: Record "Analysis by Dim. Parameters") begin end; /// <summary> /// Integration event for custom dimension code lookup handling when dimension option requires custom implementation. /// </summary> /// <param name="DimOption">Dimension option requiring custom lookup logic</param> /// <param name="Code">Dimension code being looked up and selected</param> [IntegrationEvent(true, false)] local procedure OnLookupDimCodeOnCaseElse(DimOption: Enum "Analysis Dimension Option"; var "Code": Text[30]) begin end; /// <summary> /// Integration event for custom page opening logic when account source requires non-standard dimension handling. /// </summary> /// <param name="AnalysisView">Analysis view configuration determining page behavior</param> /// <param name="LineDimCode">Line dimension code for custom page opening logic</param> [IntegrationEvent(false, false)] local procedure OnOpenPageOnAccountSourceElseCase(AnalysisView: Record "Analysis View"; var LineDimCode: Text[30]) begin end;}