Query 251 G/L Budget Entry Dimensions, source in 29

// ------------------------------------------------------------------------------------------------
// 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;
            }
        }
    }
}