Report 7139 Date Comp. Item Budget Entries

Base Application, Microsoft.Inventory.Analysis

src/Layers/W1/BaseApp/Inventory/Analysis/DateCompItemBudgetEntries.Report.al556 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.Inventory.Analysis;using Microsoft.Finance.Analysis;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.Period;using System.DataAdministration;using System.Utilities;report 7139 "Date Comp. Item Budget Entries"{    Caption = 'Date Compr. Item Budget Entries';    ToolTip = 'Save database space by combining related entries in one new entry. You can compress entries from closed fiscal years only.';    ProcessingOnly = true;    dataset    {        dataitem("Item Budget Entry"; "Item Budget Entry")        {            DataItemTableView = sorting("Analysis Area", "Budget Name", "Item No.", Date);            RequestFilterFields = "Budget Name", "Item No.";            trigger OnAfterGetRecord()            var                ItemBudgetName: Record "Item Budget Name";            begin                ItemBudgetName.Get("Analysis Area", "Budget Name");                Retain[3] :=                  TempSelectedDim.Get(                    UserId, 3, REPORT::"Date Comp. Item Budget Entries", '', ItemBudgetName."Budget Dimension 1 Code");                Retain[4] :=                  TempSelectedDim.Get(                    UserId, 3, REPORT::"Date Comp. Item Budget Entries", '', ItemBudgetName."Budget Dimension 2 Code");                Retain[5] :=                  TempSelectedDim.Get(                    UserId, 3, REPORT::"Date Comp. Item Budget Entries", '', ItemBudgetName."Budget Dimension 3 Code");                ItemBudgetEntry2 := "Item Budget Entry";                ItemBudgetEntry2.SetCurrentKey("Analysis Area", "Budget Name", "Item No.", Date);                ItemBudgetEntry2.CopyFilters("Item Budget Entry");                ItemBudgetEntry2.SetFilter(Date, DateComprMgt.GetDateFilter(ItemBudgetEntry2.Date, EntrdDateComprReg, false));                ItemBudgetEntry2.SetRange("Analysis Area", ItemBudgetEntry2."Analysis Area");                ItemBudgetEntry2.SetRange("Budget Name", ItemBudgetEntry2."Budget Name");                ItemBudgetEntry2.SetRange("Item No.", ItemBudgetEntry2."Item No.");                LastEntryNo := LastEntryNo + 1;                if RetainNo(ItemBudgetEntry2.FieldNo("Global Dimension 1 Code")) then                    ItemBudgetEntry2.SetRange(ItemBudgetEntry2."Global Dimension 1 Code", ItemBudgetEntry2."Global Dimension 1 Code");                if RetainNo(ItemBudgetEntry2.FieldNo("Global Dimension 2 Code")) then                    ItemBudgetEntry2.SetRange(ItemBudgetEntry2."Global Dimension 2 Code", ItemBudgetEntry2."Global Dimension 2 Code");                if ItemBudgetEntry2.Quantity >= 0 then                    ItemBudgetEntry2.SetFilter(Quantity, '>=0')                else                    ItemBudgetEntry2.SetFilter(Quantity, '<0');                if ItemBudgetEntry2."Cost Amount" >= 0 then                    ItemBudgetEntry2.SetFilter("Cost Amount", '>=0')                else                    ItemBudgetEntry2.SetFilter("Cost Amount", '<0');                if ItemBudgetEntry2."Sales Amount" >= 0 then                    ItemBudgetEntry2.SetFilter("Sales Amount", '>=0')                else                    ItemBudgetEntry2.SetFilter("Sales Amount", '<0');                InitNewEntry(NewItemBudgetEntry);                DimBufMgt.CollectDimEntryNo(                  TempSelectedDim, ItemBudgetEntry2."Dimension Set ID", ItemBudgetEntry2."Entry No.", 0, false, DimEntryNo);                ComprDimEntryNo := DimEntryNo;                SummarizeEntry(NewItemBudgetEntry, ItemBudgetEntry2);                while ItemBudgetEntry2.Next() <> 0 do begin                    DimBufMgt.CollectDimEntryNo(                      TempSelectedDim, ItemBudgetEntry2."Dimension Set ID", ItemBudgetEntry2."Entry No.", ComprDimEntryNo, true, DimEntryNo);                    if DimEntryNo = ComprDimEntryNo then                        SummarizeEntry(NewItemBudgetEntry, ItemBudgetEntry2);                end;                InsertNewEntry(NewItemBudgetEntry, ComprDimEntryNo);                ComprCollectedEntries();                if DateComprReg."No. Records Deleted" >= NoOfDeleted + 10 then begin                    NoOfDeleted := DateComprReg."No. Records Deleted";                    InsertRegisters(DateComprReg);                    Commit();                    ItemBudgetEntry2.LockTable();                    LastEntryNo := ItemBudgetEntry2.GetLastEntryNo();                end;            end;            trigger OnPostDataItem()            var                UpdateAnalysisView: Codeunit "Update Analysis View";            begin                if DateComprReg."No. Records Deleted" > NoOfDeleted then                    InsertRegisters(DateComprReg);                if AnalysisView.FindFirst() then                    if LowestEntryNo < 2147483647 then                        UpdateAnalysisView.SetLastBudgetEntryNo(LowestEntryNo - 1);                if UseDataArchive then                    DataArchive.Save();            end;            trigger OnPreDataItem()            var                GLSetup: Record "General Ledger Setup";            begin                if EntrdDateComprReg."Ending Date" = 0D then                    Error(                      Text002,                      EntrdDateComprReg.FieldCaption("Ending Date"));                DateComprReg.Init();                DateComprReg."Starting Date" := EntrdDateComprReg."Starting Date";                DateComprReg."Ending Date" := EntrdDateComprReg."Ending Date";                DateComprReg."Period Length" := EntrdDateComprReg."Period Length";                if AnalysisView.FindFirst() then begin                    AnalysisView.CheckDimensionsAreRetained(3, REPORT::"Date Comp. Item Budget Entries", true);                    if not SkipAnalysisViewUpdateCheck then                        AnalysisView.CheckViewsAreUpdated();                    Commit();                end;                SelectedDim.GetSelectedDim(                  UserId, 3, REPORT::"Date Comp. Item Budget Entries", '', TempSelectedDim);                GLSetup.Get();                Retain[1] :=                  TempSelectedDim.Get(                    UserId, 3, REPORT::"Date Comp. Item Budget Entries", '', GLSetup."Global Dimension 1 Code");                Retain[2] :=                  TempSelectedDim.Get(                    UserId, 3, REPORT::"Date Comp. Item Budget Entries", '', GLSetup."Global Dimension 2 Code");                SourceCodeSetup.Get();                SourceCodeSetup.TestField("Compress Item Budget");                ItemBudgetEntry2.LockTable();                LastEntryNo := ItemBudgetEntry2.GetLastEntryNo();                LowestEntryNo := 2147483647;                Window.Open(                  Text003 +                  Text004 +                  Text005 +                  Text006 +                  Text007 +                  Text008);                SetRange("Entry No.", 0, LastEntryNo);                SetRange(Date, EntrdDateComprReg."Starting Date", EntrdDateComprReg."Ending Date");                SetRange("Analysis Area", AnalysisAreaSelection);                InitRegisters();                if UseDataArchive then                    DataArchive.Create(DateComprMgt.GetReportName(Report::"Date Comp. Item Budget Entries"));            end;        }    }    requestpage    {        SaveValues = true;        layout        {            area(content)            {                group(Options)                {                    Caption = 'Options';                    field(AnalysisArea; AnalysisAreaSelection)                    {                        ApplicationArea = ItemBudget;                        Caption = 'Analysis Area';                        ToolTip = 'Specifies the analysis area of the date component item budget entry.';                    }                    field(StartingDate; EntrdDateComprReg."Starting Date")                    {                        ApplicationArea = ItemBudget;                        Caption = 'Starting Date';                        ClosingDates = true;                        ToolTip = 'Specifies the first date to be included in the date compression.';                    }                    field(EndingDate; EntrdDateComprReg."Ending Date")                    {                        ApplicationArea = ItemBudget;                        Caption = 'Ending Date';                        ClosingDates = true;                        ToolTip = 'Specifies the end date.';                        trigger OnValidate()                        var                            DateCompression: Codeunit "Date Compression";                        begin                            DateCompression.VerifyDateCompressionDates(EntrdDateComprReg."Starting Date", EntrdDateComprReg."Ending Date");                        end;                    }                    field(PeriodLength; EntrdDateComprReg."Period Length")                    {                        ApplicationArea = ItemBudget;                        Caption = 'Period Length';                        OptionCaption = 'Day,Week,Month,Quarter,Year,Period';                        ToolTip = 'Specifies the length of the period whose entries will be combined. Choose the field to see the options.';                    }                    field(PostingDescription; EntrdItemBudgetEntry.Description)                    {                        ApplicationArea = ItemBudget;                        Caption = 'Posting Description';                        ToolTip = 'Specifies a text that will accompany the entries resulting from the compression. The default description is "Date Compressed."';                    }                    field(RetainDimensions; RetainDimText)                    {                        ApplicationArea = Dimensions;                        Caption = 'Retain Dimensions';                        Editable = false;                        ToolTip = 'Specifies the fields you want to retain the contents of even though the entries will be compressed. The more fields you select, the more detailed the compressed entries will be.';                        trigger OnAssistEdit()                        begin                            DimSelectionBuf.SetDimSelectionMultiple(3, REPORT::"Date Comp. Item Budget Entries", RetainDimText);                        end;                    }                    field(UseDataArchiveCtrl; UseDataArchive)                    {                        ApplicationArea = Suite;                        Caption = 'Archive Deleted Entries';                        ToolTip = 'Specifies whether the deleted (compressed) entries will be stored in the data archive for later inspection or export.';                        Visible = DataArchiveProviderExists;                    }                }            }        }        actions        {        }        trigger OnQueryClosePage(CloseAction: Action): Boolean        var            ConfirmManagement: Codeunit "Confirm Management";        begin            if CloseAction = Action::Cancel then                exit;            if not ConfirmManagement.GetResponseOrDefault(CompressEntriesQst, true) then                CurrReport.Break();        end;        trigger OnOpenPage()        begin            InitializeVariables();        end;        trigger OnInit()        begin            DataArchiveProviderExists := DataArchive.DataArchiveProviderExists();        end;    }    labels    {    }    trigger OnPreReport()    var        DateCompression: Codeunit "Date Compression";    begin        DimSelectionBuf.CompareDimText(          3, REPORT::"Date Comp. Item Budget Entries", '', RetainDimText, Text009);        ItemBudgetEntryFilter := "Item Budget Entry".GetFilters();        DateCompression.VerifyDateCompressionDates(EntrdDateComprReg."Starting Date", EntrdDateComprReg."Ending Date");        LogStartTelemetryMessage();    end;    trigger OnPostReport()    begin        LogEndTelemetryMessage();    end;    var        SourceCodeSetup: Record "Source Code Setup";        DateComprReg: Record "Date Compr. Register";        EntrdDateComprReg: Record "Date Compr. Register";        EntrdItemBudgetEntry: Record "Item Budget Entry";        NewItemBudgetEntry: Record "Item Budget Entry";        ItemBudgetEntry2: Record "Item Budget Entry";        SelectedDim: Record "Selected Dimension";        TempSelectedDim: Record "Selected Dimension" temporary;        DimSelectionBuf: Record "Dimension Selection Buffer";        AnalysisView: Record "Item Analysis View";        DateComprMgt: Codeunit DateComprMgt;        DimBufMgt: Codeunit "Dimension Buffer Management";        DimMgt: Codeunit DimensionManagement;        DataArchive: Codeunit "Data Archive";        UseDataArchive: Boolean;        DataArchiveProviderExists: Boolean;        Window: Dialog;        NoOfFields: Integer;        Retain: array[10] of Boolean;        FieldNumber: array[10] of Integer;        FieldNameArray: array[10] of Text[100];        LastEntryNo: Integer;        LowestEntryNo: Integer;        NoOfDeleted: Integer;        i: Integer;        ComprDimEntryNo: Integer;        DimEntryNo: Integer;        RetainDimText: Text[250];        AnalysisAreaSelection: Enum "Analysis Area Type";        ItemBudgetEntryFilter: Text;        SkipAnalysisViewUpdateCheck: Boolean;        CompressEntriesQst: Label 'This batch job deletes entries. We recommend that you create a backup of the database before you run the batch job.\\Do you want to continue?';#pragma warning disable AA0074#pragma warning disable AA0470        Text002: Label '%1 must be specified.';#pragma warning restore AA0470        Text003: Label 'Date compressing Item budget entries...\\';#pragma warning disable AA0470        Text004: Label 'Budget Name          #1##########\';        Text005: Label 'Item No.             #2##########\';        Text006: Label 'Date                 #3######\\';        Text007: Label 'No. of new entries   #4######\';        Text008: Label 'No. of entries del.  #5######';#pragma warning restore AA0470        Text009: Label 'Retain Dimensions';#pragma warning restore AA0074        StartDateCompressionTelemetryMsg: Label 'Running date compression report %1 %2.', Locked = true;        EndDateCompressionTelemetryMsg: Label 'Completed date compression report %1 %2.', Locked = true;    local procedure InitRegisters()    begin        DateComprReg.Init();        DateComprReg."No." := DateComprReg.GetLastEntryNo() + 1;        DateComprReg."Table ID" := DATABASE::"Item Budget Entry";        DateComprReg."Creation Date" := Today;        DateComprReg."Starting Date" := EntrdDateComprReg."Starting Date";        DateComprReg."Ending Date" := EntrdDateComprReg."Ending Date";        DateComprReg."Period Length" := EntrdDateComprReg."Period Length";        for i := 1 to NoOfFields do            if Retain[i] then                DateComprReg."Retain Field Contents" :=                  CopyStr(                    DateComprReg."Retain Field Contents" + ',' + FieldNameArray[i], 1,                    MaxStrLen(DateComprReg."Retain Field Contents"));        DateComprReg."Retain Field Contents" := CopyStr(DateComprReg."Retain Field Contents", 2);        DateComprReg.Filter := CopyStr(ItemBudgetEntryFilter, 1, MaxStrLen(DateComprReg.Filter));        DateComprReg."Register No." := "Item Budget Entry"."Entry No.";        DateComprReg."Source Code" := SourceCodeSetup."Compress Item Budget";        DateComprReg."User ID" := CopyStr(UserId(), 1, MaxStrLen(DateComprReg."User ID"));        NoOfDeleted := 0;    end;    local procedure InsertRegisters(var DateComprReg: Record "Date Compr. Register")    var        CurrLastEntryNo: Integer;    begin        DateComprReg.Insert();        NewItemBudgetEntry.LockTable();        DateComprReg.LockTable();        ItemBudgetEntry2.Reset();        CurrLastEntryNo := ItemBudgetEntry2.GetLastEntryNo();        if LastEntryNo <> CurrLastEntryNo then begin            LastEntryNo := CurrLastEntryNo;            InitRegisters();        end;    end;    local procedure InsertField(Number: Integer; Name: Text[100])    begin        NoOfFields := NoOfFields + 1;        FieldNumber[NoOfFields] := Number;        FieldNameArray[NoOfFields] := Name;    end;    local procedure RetainNo(Number: Integer): Boolean    begin        exit(Retain[Index(Number)]);    end;    local procedure Index(Number: Integer): Integer    begin        for i := 1 to NoOfFields do            if Number = FieldNumber[i] then                exit(i);    end;    local procedure SummarizeEntry(var NewItemBudgetEntry: Record "Item Budget Entry"; ItemBudgetEntry: Record "Item Budget Entry")    begin        NewItemBudgetEntry.Quantity := NewItemBudgetEntry.Quantity + ItemBudgetEntry.Quantity;        NewItemBudgetEntry."Cost Amount" := NewItemBudgetEntry."Cost Amount" + ItemBudgetEntry."Cost Amount";        NewItemBudgetEntry."Sales Amount" := NewItemBudgetEntry."Sales Amount" + ItemBudgetEntry."Sales Amount";        ItemBudgetEntry.Delete();        if ItemBudgetEntry."Entry No." < LowestEntryNo then            LowestEntryNo := ItemBudgetEntry."Entry No.";        DateComprReg."No. Records Deleted" := DateComprReg."No. Records Deleted" + 1;        Window.Update(5, DateComprReg."No. Records Deleted");        if UseDataArchive then            DataArchive.SaveRecord(ItemBudgetEntry);    end;    local procedure ComprCollectedEntries()    var        ItemBudgetEntry: Record "Item Budget Entry";        OldDimEntryNo: Integer;        Found: Boolean;        ItemBudgetEntryNo: Integer;    begin        OldDimEntryNo := 0;        if DimBufMgt.FindFirstDimEntryNo(DimEntryNo, ItemBudgetEntryNo) then begin            InitNewEntry(NewItemBudgetEntry);            repeat                ItemBudgetEntry.Get(ItemBudgetEntryNo);                SummarizeEntry(ItemBudgetEntry, ItemBudgetEntry);                OldDimEntryNo := DimEntryNo;                Found := DimBufMgt.NextDimEntryNo(DimEntryNo, ItemBudgetEntryNo);                if (OldDimEntryNo <> DimEntryNo) or not Found then begin                    InsertNewEntry(NewItemBudgetEntry, OldDimEntryNo);                    if Found then                        InitNewEntry(NewItemBudgetEntry);                end;                OldDimEntryNo := DimEntryNo;            until not Found;        end;        DimBufMgt.DeleteAllDimEntryNo();    end;    procedure InitNewEntry(var NewItemBudgetEntry: Record "Item Budget Entry")    begin        LastEntryNo := LastEntryNo + 1;        NewItemBudgetEntry.Init();        NewItemBudgetEntry."Entry No." := LastEntryNo;        NewItemBudgetEntry."Analysis Area" := AnalysisAreaSelection;        NewItemBudgetEntry."Budget Name" := ItemBudgetEntry2."Budget Name";        NewItemBudgetEntry."Item No." := ItemBudgetEntry2."Item No.";        NewItemBudgetEntry.Date := ItemBudgetEntry2.GetRangeMin(ItemBudgetEntry2.Date);        NewItemBudgetEntry.Description := EntrdItemBudgetEntry.Description;        NewItemBudgetEntry."User ID" := CopyStr(UserId(), 1, MaxStrLen(ItemBudgetEntry2."User ID"));        if RetainNo(ItemBudgetEntry2.FieldNo("Global Dimension 1 Code")) then            NewItemBudgetEntry."Global Dimension 1 Code" := ItemBudgetEntry2."Global Dimension 1 Code";        if RetainNo(ItemBudgetEntry2.FieldNo("Global Dimension 2 Code")) then            NewItemBudgetEntry."Global Dimension 2 Code" := ItemBudgetEntry2."Global Dimension 2 Code";        if RetainNo(ItemBudgetEntry2.FieldNo("Budget Dimension 1 Code")) then            NewItemBudgetEntry."Budget Dimension 1 Code" := ItemBudgetEntry2."Budget Dimension 1 Code";        if RetainNo(ItemBudgetEntry2.FieldNo("Budget Dimension 2 Code")) then            NewItemBudgetEntry."Budget Dimension 2 Code" := ItemBudgetEntry2."Budget Dimension 2 Code";        if RetainNo(ItemBudgetEntry2.FieldNo("Budget Dimension 3 Code")) then            NewItemBudgetEntry."Budget Dimension 3 Code" := ItemBudgetEntry2."Budget Dimension 3 Code";        Window.Update(1, NewItemBudgetEntry."Budget Name");        Window.Update(2, NewItemBudgetEntry."Item No.");        Window.Update(3, NewItemBudgetEntry.Date);        DateComprReg."No. of New Records" := DateComprReg."No. of New Records" + 1;        Window.Update(4, DateComprReg."No. of New Records");    end;    local procedure InsertNewEntry(var NewItemBudgetEntry: Record "Item Budget Entry"; DimEntryNo: Integer)    var        TempDimBuf: Record "Dimension Buffer" temporary;        TempDimSetEntry: Record "Dimension Set Entry" temporary;    begin        TempDimBuf.DeleteAll();        DimBufMgt.GetDimensions(DimEntryNo, TempDimBuf);        DimMgt.CopyDimBufToDimSetEntry(TempDimBuf, TempDimSetEntry);        NewItemBudgetEntry."Dimension Set ID" := DimMgt.GetDimensionSetID(TempDimSetEntry);        NewItemBudgetEntry.Insert();    end;    procedure InitializeRequest(AnalAreaSelection: Option; StartDate: Date; EndDate: Date; PeriodLength: Option; Desc: Text[100]; RetainDimensions: Text[250])    begin        InitializeRequest(AnalAreaSelection, StartDate, EndDate, PeriodLength, Desc, RetainDimensions, true);    end;    procedure InitializeRequest(AnalAreaSelection: Option; StartDate: Date; EndDate: Date; PeriodLength: Option; Desc: Text[100]; RetainDimensions: Text[250]; DoUseDataArchive: Boolean)    begin        InitializeVariables();        AnalysisAreaSelection := "Analysis Area Type".FromInteger(AnalAreaSelection);        EntrdDateComprReg."Starting Date" := StartDate;        EntrdDateComprReg."Ending Date" := EndDate;        EntrdDateComprReg."Period Length" := PeriodLength;        EntrdItemBudgetEntry.Description := Desc;        RetainDimText := RetainDimensions;        DataArchiveProviderExists := DataArchive.DataArchiveProviderExists();        UseDataArchive := DataArchiveProviderExists and DoUseDataArchive;    end;    local procedure InitializeVariables()    var        DateCompression: Codeunit "Date Compression";    begin        if EntrdDateComprReg."Ending Date" = 0D then            EntrdDateComprReg."Ending Date" := DateCompression.CalcMaxEndDate();        InsertField("Item Budget Entry".FieldNo("Global Dimension 1 Code"), "Item Budget Entry".FieldCaption("Global Dimension 1 Code"));        InsertField("Item Budget Entry".FieldNo("Global Dimension 2 Code"), "Item Budget Entry".FieldCaption("Global Dimension 2 Code"));        InsertField("Item Budget Entry".FieldNo("Budget Dimension 1 Code"), "Item Budget Entry".FieldCaption("Budget Dimension 1 Code"));        InsertField("Item Budget Entry".FieldNo("Budget Dimension 2 Code"), "Item Budget Entry".FieldCaption("Budget Dimension 2 Code"));        InsertField("Item Budget Entry".FieldNo("Budget Dimension 3 Code"), "Item Budget Entry".FieldCaption("Budget Dimension 3 Code"));        RetainDimText := DimSelectionBuf.GetDimSelectionText(3, REPORT::"Date Comp. Item Budget Entries", '');        DataArchiveProviderExists := DataArchive.DataArchiveProviderExists();        UseDataArchive := DataArchiveProviderExists;    end;    procedure SetSkipAnalysisViewUpdateCheck();    begin        SkipAnalysisViewUpdateCheck := true;    end;    local procedure LogStartTelemetryMessage()    var        TelemetryDimensions: Dictionary of [Text, Text];    begin        TelemetryDimensions.Add('ReportId', Format(CurrReport.ObjectId(false), 0, 9));        TelemetryDimensions.Add('ReportName', CurrReport.ObjectId(true));        TelemetryDimensions.Add('UseRequestPage', Format(CurrReport.UseRequestPage()));        TelemetryDimensions.Add('StartDate', Format(EntrdDateComprReg."Starting Date", 0, 9));        TelemetryDimensions.Add('PeriodLength', Format(EntrdDateComprReg."Period Length", 0, 9));        TelemetryDimensions.Add('EndDate', Format(EntrdDateComprReg."Ending Date", 0, 9));        TelemetryDimensions.Add('AnalysisAreaSelection', Format(AnalysisAreaSelection, 0, 9));        TelemetryDimensions.Add('RetainDimensions', RetainDimText);        TelemetryDimensions.Add('UseDataArchive', Format(UseDataArchive));        Session.LogMessage('0000F4E', StrSubstNo(StartDateCompressionTelemetryMsg, CurrReport.ObjectId(false), CurrReport.ObjectId(true)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::All, TelemetryDimensions);    end;    local procedure LogEndTelemetryMessage()    var        TelemetryDimensions: Dictionary of [Text, Text];    begin        TelemetryDimensions.Add('ReportId', Format(CurrReport.ObjectId(false), 0, 9));        TelemetryDimensions.Add('ReportName', CurrReport.ObjectId(true));        TelemetryDimensions.Add('RegisterNo', Format(DateComprReg."Register No.", 0, 9));        TelemetryDimensions.Add('TableID', Format(DateComprReg."Table ID", 0, 9));        TelemetryDimensions.Add('NoRecordsDeleted', Format(DateComprReg."No. Records Deleted", 0, 9));        TelemetryDimensions.Add('NoofNewRecords', Format(DateComprReg."No. of New Records", 0, 9));        Session.LogMessage('0000F4F', StrSubstNo(EndDateCompressionTelemetryMsg, CurrReport.ObjectId(false), CurrReport.ObjectId(true)), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::All, TelemetryDimensions);    end;}