Codeunit 36952 Update Dim. Set Entries

PowerBI Reports, Microsoft.PowerBIReports

src/Apps/W1/PowerBIReports/App/Core/Codeunits/UpdateDimSetEntries.Codeunit.al62 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.PowerBIReports;codeunit 36952 "Update Dim. Set Entries"{    Access = Internal;    var        PBIDimensionSetEntry: Record "PowerBI Flat Dim. Set Entry";        PBISetup: Record "PowerBI Reports Setup";        PBIDimensionSets: Query "PowerBI Dimension Sets";    trigger OnRun()    var        LastModifiedDateTime: DateTime;    begin        PBISetup.Get();        LastModifiedDateTime := PBISetup."Last Dim. Set Entry Date-Time";        PBIDimensionSetEntry.Reset();        if not PBIDimensionSetEntry.IsEmpty() then  // skip setting Last Updated on the first run when the app is installed from scatch.             PBIDimensionSets.SetFilter(SystemModifiedAt, '>=%1', LastModifiedDateTime);        if PBIDimensionSets.Open() then begin            while PBIDimensionSets.Read() do begin                if PBIDimensionSets.SystemModifiedAt > LastModifiedDateTime then                    LastModifiedDateTime := PBIDimensionSets.SystemModifiedAt;                PBIDimensionSetEntry.Init();                PBIDimensionSetEntry."Dimension Set ID" := PBIDimensionSets.Dimension_Set_ID;                PBIDimensionSetEntry."Value Count" := PBIDimensionSets.Value_Count;                PBIDimensionSetEntry."Dimension 1 Value Code" := PBIDimensionSets.Dimension_1_Value_Code;                PBIDimensionSetEntry."Dimension 1 Value Name" := PBIDimensionSets.Dimension_1_Value_Name;                PBIDimensionSetEntry."Dimension 2 Value Code" := PBIDimensionSets.Dimension_2_Value_Code;                PBIDimensionSetEntry."Dimension 2 Value Name" := PBIDimensionSets.Dimension_2_Value_Name;                PBIDimensionSetEntry."Dimension 3 Value Code" := PBIDimensionSets.Dimension_3_Value_Code;                PBIDimensionSetEntry."Dimension 3 Value Name" := PBIDimensionSets.Dimension_3_Value_Name;                PBIDimensionSetEntry."Dimension 4 Value Code" := PBIDimensionSets.Dimension_4_Value_Code;                PBIDimensionSetEntry."Dimension 4 Value Name" := PBIDimensionSets.Dimension_4_Value_Name;                PBIDimensionSetEntry."Dimension 5 Value Code" := PBIDimensionSets.Dimension_5_Value_Code;                PBIDimensionSetEntry."Dimension 5 Value Name" := PBIDimensionSets.Dimension_5_Value_Name;                PBIDimensionSetEntry."Dimension 6 Value Code" := PBIDimensionSets.Dimension_6_Value_Code;                PBIDimensionSetEntry."Dimension 6 Value Name" := PBIDimensionSets.Dimension_6_Value_Name;                PBIDimensionSetEntry."Dimension 7 Value Code" := PBIDimensionSets.Dimension_7_Value_Code;                PBIDimensionSetEntry."Dimension 7 Value Name" := PBIDimensionSets.Dimension_7_Value_Name;                PBIDimensionSetEntry."Dimension 8 Value Code" := PBIDimensionSets.Dimension_8_Value_Code;                PBIDimensionSetEntry."Dimension 8 Value Name" := PBIDimensionSets.Dimension_8_Value_Name;                if not PBIDimensionSetEntry.Insert() then                    PBIDimensionSetEntry.Modify();            end;            PBISetup."Last Dim. Set Entry Date-Time" := LastModifiedDateTime;            PBISetup.Modify();        end;    end;}