Query 251 G/L Budget Entry Dimensions

Base Application, Microsoft.Finance.GeneralLedger.Budget

src/Layers/W1/BaseApp/Finance/GeneralLedger/Budget/GLBudgetEntryDimensions.Query.al54 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.GeneralLedger.Budget;/// <summary>/// Specialized query for dimensional analysis of G/L budget entries with aggregated amounts by dimension sets./// Optimizes multi-dimensional budget analysis through efficient grouping and filtering capabilities./// </summary>/// <remarks>/// Key features: Dimension-based aggregation, pre-filtered dimensional analysis, and optimized sum calculations./// Use cases: Budget analysis by dimensions, dashboard reporting, and performance management scenarios./// Performance: Leverages database aggregation functions for efficient sum calculations across large datasets./// Integration: Works with Analysis Views and dimensional reporting frameworks for comprehensive budget analysis./// </remarks>query 251 "G/L Budget Entry Dimensions"{    Caption = 'G/L Budget Entry Dimensions';    elements    {        dataitem(G_L_Budget_Entry; "G/L Budget Entry")        {            filter(Budget_Name; "Budget Name")            {            }            filter(G_L_Account_No; "G/L Account No.")            {            }            filter(Date; Date)            {            }            filter(Business_Unit_Code; "Business Unit Code")            {            }            filter(Global_Dimension_1_Code; "Global Dimension 1 Code")            {            }            filter(Global_Dimension_2_Code; "Global Dimension 2 Code")            {            }            column(Dimension_Set_ID; "Dimension Set ID")            {            }            column(Sum_Amount; Amount)            {                Method = Sum;            }        }    }}