Codeunit 6302 Power BI Label Mgt.
src/Layers/W1/BaseApp/Integration/PowerBI/ReportingData/PowerBILabelMgt.Codeunit.al201 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.Integration.PowerBI;using System.Environment.Configuration;using System.Integration.PowerBI;codeunit 6302 "Power BI Label Mgt."{ // // Codeunit for generating the static values that Power BI reports use for titles or other // // text labels. These values are exposed through a web service for page 6318. This approach // // lets reports get values translated for the user's locale rather than hardcoding English. trigger OnRun() begin end; var CRM_SalesOpportuntiesByCompany_KeyTxt: Label 'CRM_SalesOpportuntiesByCompany', Locked = true; CRM_SalesOpportuntiesByCompany_ValueTxt: Label 'Estimated Value by Customer Name'; CRM_CompletedByStatus_KeyTxt: Label 'CRM_CompletedByStatus', Locked = true; CRM_CompletedByStatus_ValueTxt: Label 'Completed by Status & Company Name'; CRM_OpportunityDashboard_KeyTxt: Label 'CRM_OpportunityDashboard', Locked = true; CRM_OpportunityDashboard_ValueTxt: Label 'Opportunity Dashboard'; CRM_Details1_KeyTxt: Label 'CRM_Details1', Locked = true; CRM_Details1_ValueTxt: Label 'Back to Report'; CRM_Details2_KeyTxt: Label 'CRM_Details2', Locked = true; CRM_Details2_ValueTxt: Label 'CRM Details'; CRM_SnapShot_KeyTxt: Label 'CRM_SnapShot', Locked = true; CRM_SnapShot_ValueTxt: Label 'Opportunity Snapshot'; CRM_OpportunitiesValue_KeyTxt: Label 'CRM_OpportunitiesValue', Locked = true; CRM_OpportunitiesValue_ValueTxt: Label 'Opportunities - Calculated Current Value'; CRM_EstimValueByCompanyName_KeyTxt: Label 'CRM_EstimValueByCompanyName', Locked = true; CRM_EstimValueByCompanyName_ValueTxt: Label 'Estimated Value by Company Name'; CRM_CountByStatus_KeyTxt: Label 'CRM_CountByStatus', Locked = true; CRM_CountByStatus_ValueTxt: Label 'Count by Status'; CRM_CountBySalesPerson_KeyTxt: Label 'CRM_CountBySalesperson', Locked = true; CRM_CountBySalesPerson_ValueTxt: Label 'Count by Salesperson Name'; CRM_OpportunitiesEstim_KeyTxt: Label 'CRM_OpportunitiesEstim', Locked = true; CRM_OpportunitiesEstim_ValueTxt: Label 'Opportunities - Estimated Value'; CRM_DateClosed_KeyTxt: Label 'CRM_DateClosed', Locked = true; CRM_DateClosed_ValueTxt: Label 'Date Closed'; CRM_EstCloseDate_KeyTxt: Label 'CRM_EstCloseDate', Locked = true; CRM_EstCloseDate_ValueTxt: Label 'Estimated Close Date'; Finance_NetChangeMargin_KeyTxt: Label 'Finance_NetChangeMargin', Locked = true; Finance_NetChangeMargin_ValueTxt: Label 'Actual Net Change by Date & KPI Name'; Finance_FinancialDashboard_KeyTxt: Label 'Finance_FinancialDashboard', Locked = true; Finance_FinancialDashboard_ValueTxt: Label 'Financial Dashboard'; Finance_NetChangebyDays_KeyTxt: Label 'Finance_NetChangebyDays', Locked = true; Finance_NetChangebyDays_ValueTxt: Label 'Net Change by Date & KPI Name'; Finance_NetChangeRevenueExpInterest_KeyTxt: Label 'Finance_NetChangeRevenueExpendituresInterest', Locked = true; Finance_NetChangeRevenueExpInterest_ValueTxt: Label 'Net Change by Date & KPI Name'; Finance_MiniTrialBalance_KeyTxt: Label 'Finance_MiniTrialBalance', Locked = true; Finance_MiniTrialBalance_ValueTxt: Label 'Mini Trial Balance'; Finance_KPIDetails1_KeyTxt: Label 'Finance_KPI Details1', Locked = true; Finance_KPIDetails1_ValueTxt: Label 'Net Change Details'; Finance_KPIDetails2_KeyTxt: Label 'Finance_KPI Details2', Locked = true; Finance_KPIDetails2_ValueTxt: Label 'Back to Report'; Sales_ItemSales_KeyTxt: Label 'Sales_ItemSales', Locked = true; Sales_ItemSales_ValueTxt: Label 'Top 5 Items Sold by Quantity'; Sales_ItemSalesDashboard_KeyTxt: Label 'Sales_ItemSalesDashboard', Locked = true; Sales_ItemSalesDashboard_ValueTxt: Label 'Item Sales Dashboard'; Sales_CustomerSales_KeyTxt: Label 'Sales_CustomerSales', Locked = true; Sales_CustomerSales_ValueTxt: Label 'Top 5 Customers by Sales Amount'; Sales_CustomerSalesDashboard_KeyTxt: Label 'Sales_CustomerSalesDashboard', Locked = true; Sales_CustomerSalesDashboard_ValueTxt: Label 'Customer Sales Dashboard'; Sales_CustomerSalesTimeline_KeyTxt: Label 'Sales_CustomerSalesTimeline', Locked = true; Sales_CustomerSalesTimeline_ValueTxt: Label 'Sales Timeline'; Sales_Details_SalesDetails1_KeyTxt: Label 'Sales_Details_SalesDetails1', Locked = true; Sales_Details_SalesDetails1_ValueTxt: Label 'Back to Report'; Sales_Details_SalesDetails2_KeyTxt: Label 'Sales_Details_SalesDetails2', Locked = true; Sales_Details_SalesDetails2_ValueTxt: Label 'Sales Details'; Sales_Top10ItemsByQuantity_KeyTxt: Label 'Sales_Top10ItemSales', Locked = true; Sales_Top10ItemsByQuantity_ValueTxt: Label 'Top 10 Items Sold by Quantity'; Sales_Top5Customers_KeyTxt: Label 'Sales_Top5CustSales', Locked = true; Sales_Top5Customers_ValueTxt: Label 'Top 5 Customers by Quantity Sold'; Sales_QuantityByGeneralPostingGroup_KeyTxt: Label 'Sales_QtyByPostingGroup', Locked = true; Sales_QuantityByGeneralPostingGroup_ValueTxt: Label 'Quantity Sold by General Product Posting Group'; Sales_QuantityBySalesPerson_KeyTxt: Label 'Sales_QtyBySalesPerson', Locked = true; Sales_QuantityBySalesPerson_ValueTxt: Label 'Quantity Sold by Salesperson Name'; Sales_CustomerBalances_KeyTxt: Label 'Sales_CustomerBalances', Locked = true; Sales_CustomerBalances_ValueTxt: Label 'Customer Balances'; Sales_BalanceDue_KeyTxt: Label 'Sales_BalanceDue', Locked = true; Sales_BalanceDue_ValueTxt: Label 'Balance Due'; Sales_AvailableCredit_KeyTxt: Label 'Sales_AvailableCredit', Locked = true; Sales_AvailableCredit_ValueTxt: Label 'Available Credit'; Sales_CreditLimit_KeyTxt: Label 'Sales_CreditLimit', Locked = true; Sales_CreditLimit_ValueTxt: Label 'Credit Limit'; ChartOfAccountAnalysis_KeyTxt: Label 'ChartOfAccountAnalysis', Locked = true; ChartOfAccountAnalysis_ValueTxt: Label 'Chart of Account Analysis'; IncomeStatement_KeyTxt: Label 'IncomeStatement', Locked = true; IncomeStatement_ValueTxt: Label 'Income Statement'; BalanceSheet_KeyTxt: Label 'BalanceSheet', Locked = true; BalanceSheet_ValueTxt: Label 'Balance Sheet'; JobsProfit_KeyTxt: Label 'JobsProfit', Locked = true; JobsProfit_ValueTxt: Label 'Cost vs. Invoiced Amount with Profit'; JobsDashboard_KeyTxt: Label 'JobsDashboard', Locked = true; JobsDashboard_ValueTxt: Label 'Jobs Dashboard'; VendorList_VendorPurchases_KeyTxt: Label 'VendorList_VendorPurchases', Locked = true; VendorList_VendorPurchases_ValueTxt: Label 'Vendor Purchases'; VendorList_PurchaseInvoiceList_KeyTxt: Label 'VendorList_PurchaseInvoiceList', Locked = true; VendorList_PurchaseInvoiceList_ValueTxt: Label 'Document Number'; // Telemetry labels LabelsGeneratedTelemetryTxt: Label 'Retrieving Power BI labels for language "%1" (system language is "%2").', Locked = true; procedure GetReportLabelsForUserLanguage(var TempPowerBIReportLabels: Record "Power BI Report Labels" temporary; UserSID: Guid) var UserPersonalization: Record "User Personalization"; PowerBIServiceMgt: Codeunit "Power BI Service Mgt."; LanguageChanged: Boolean; PreviousLanguage: Integer; begin // Web Service sessions run on the language specified in the Accept-Language HTTP header, or en-us if none is specified. // Power BI reports using these labels have no mean to specify an Accept-Language header, so we should instead use the user language. if UserPersonalization.Get(UserSID) and (UserPersonalization."Language ID" <> 0) then begin PreviousLanguage := GlobalLanguage(); GlobalLanguage(UserPersonalization."Language ID"); LanguageChanged := true; end; Session.LogMessage('0000EKF', StrSubstNo(LabelsGeneratedTelemetryTxt, UserPersonalization."Language ID", PreviousLanguage), Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', PowerBiServiceMgt.GetPowerBiTelemetryCategory()); GetReportLabels(TempPowerBIReportLabels); OnAfterGeneratePowerBILabels(TempPowerBIReportLabels); if LanguageChanged then GlobalLanguage(PreviousLanguage); end; procedure GetReportLabels(var TempPowerBIReportLabels: Record "Power BI Report Labels" temporary) begin // Fills the given temp table with all the default key-value pairs hardcoded into this codeunit. // Key text should always be locked, and Value text should always be translated. InsertLabel(TempPowerBIReportLabels, CRM_SalesOpportuntiesByCompany_KeyTxt, CRM_SalesOpportuntiesByCompany_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_CompletedByStatus_KeyTxt, CRM_CompletedByStatus_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_OpportunityDashboard_KeyTxt, CRM_OpportunityDashboard_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_Details1_KeyTxt, CRM_Details1_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_Details2_KeyTxt, CRM_Details2_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_SnapShot_KeyTxt, CRM_SnapShot_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_OpportunitiesValue_KeyTxt, CRM_OpportunitiesValue_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_EstimValueByCompanyName_KeyTxt, CRM_EstimValueByCompanyName_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_CountByStatus_KeyTxt, CRM_CountByStatus_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_CountBySalesPerson_KeyTxt, CRM_CountBySalesPerson_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_OpportunitiesEstim_KeyTxt, CRM_OpportunitiesEstim_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_DateClosed_KeyTxt, CRM_DateClosed_ValueTxt); InsertLabel(TempPowerBIReportLabels, CRM_EstCloseDate_KeyTxt, CRM_EstCloseDate_ValueTxt); InsertLabel(TempPowerBIReportLabels, Finance_NetChangeMargin_KeyTxt, Finance_NetChangeMargin_ValueTxt); InsertLabel(TempPowerBIReportLabels, Finance_FinancialDashboard_KeyTxt, Finance_FinancialDashboard_ValueTxt); InsertLabel(TempPowerBIReportLabels, Finance_NetChangebyDays_KeyTxt, Finance_NetChangebyDays_ValueTxt); InsertLabel(TempPowerBIReportLabels, Finance_NetChangeRevenueExpInterest_KeyTxt, Finance_NetChangeRevenueExpInterest_ValueTxt); InsertLabel(TempPowerBIReportLabels, Finance_MiniTrialBalance_KeyTxt, Finance_MiniTrialBalance_ValueTxt); InsertLabel(TempPowerBIReportLabels, Finance_KPIDetails1_KeyTxt, Finance_KPIDetails1_ValueTxt); InsertLabel(TempPowerBIReportLabels, Finance_KPIDetails2_KeyTxt, Finance_KPIDetails2_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_ItemSales_KeyTxt, Sales_ItemSales_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_ItemSalesDashboard_KeyTxt, Sales_ItemSalesDashboard_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_CustomerSales_KeyTxt, Sales_CustomerSales_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_CustomerSalesDashboard_KeyTxt, Sales_CustomerSalesDashboard_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_CustomerSalesTimeline_KeyTxt, Sales_CustomerSalesTimeline_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_Details_SalesDetails1_KeyTxt, Sales_Details_SalesDetails1_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_Details_SalesDetails2_KeyTxt, Sales_Details_SalesDetails2_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_Top10ItemsByQuantity_KeyTxt, Sales_Top10ItemsByQuantity_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_Top5Customers_KeyTxt, Sales_Top5Customers_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_QuantityByGeneralPostingGroup_KeyTxt, Sales_QuantityByGeneralPostingGroup_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_QuantityBySalesPerson_KeyTxt, Sales_QuantityBySalesPerson_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_CustomerBalances_KeyTxt, Sales_CustomerBalances_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_BalanceDue_KeyTxt, Sales_BalanceDue_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_AvailableCredit_KeyTxt, Sales_AvailableCredit_ValueTxt); InsertLabel(TempPowerBIReportLabels, Sales_CreditLimit_KeyTxt, Sales_CreditLimit_ValueTxt); InsertLabel(TempPowerBIReportLabels, ChartOfAccountAnalysis_KeyTxt, ChartOfAccountAnalysis_ValueTxt); InsertLabel(TempPowerBIReportLabels, IncomeStatement_KeyTxt, IncomeStatement_ValueTxt); InsertLabel(TempPowerBIReportLabels, BalanceSheet_KeyTxt, BalanceSheet_ValueTxt); InsertLabel(TempPowerBIReportLabels, JobsProfit_KeyTxt, JobsProfit_ValueTxt); InsertLabel(TempPowerBIReportLabels, JobsDashboard_KeyTxt, JobsDashboard_ValueTxt); InsertLabel(TempPowerBIReportLabels, VendorList_VendorPurchases_KeyTxt, VendorList_VendorPurchases_ValueTxt); InsertLabel(TempPowerBIReportLabels, VendorList_PurchaseInvoiceList_KeyTxt, VendorList_PurchaseInvoiceList_ValueTxt); end; local procedure InsertLabel(var TempPowerBIReportLabels: Record "Power BI Report Labels" temporary; LabelName: Text[100]; LabelText: Text[250]) begin // Inserts the given key-value pair into the temp table. TempPowerBIReportLabels."Label ID" := LabelName; TempPowerBIReportLabels."Text Value" := LabelText; TempPowerBIReportLabels.Insert(); end; [IntegrationEvent(false, false)] procedure OnAfterGeneratePowerBILabels(var PowerBIReportLabels: Record "Power BI Report Labels" temporary) begin end;}