Query 252 Analysis View Entry Dimensions

Base Application, Microsoft.Finance.Analysis

src/Layers/W1/BaseApp/Finance/Analysis/AnalysisViewEntryDimensions.Query.al66 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.Analysis;/// <summary>/// Query for aggregating analysis view entry amounts by dimension combinations./// Provides dimension-based grouping and amount summation for analysis reporting and matrix displays./// </summary>query 252 "Analysis View Entry Dimensions"{    Caption = 'Analysis View Entry Dimensions';    elements    {        dataitem(Analysis_View_Entry; "Analysis View Entry")        {            SqlJoinType = CrossJoin;            filter(Analysis_View_Code; "Analysis View Code")            {            }            filter(Business_Unit_Code; "Business Unit Code")            {            }            filter(Account_No; "Account No.")            {            }            filter(Posting_Date; "Posting Date")            {            }            filter(Account_Source; "Account Source")            {            }            filter(Cash_Flow_Forecast_No; "Cash Flow Forecast No.")            {            }            column(Dimension_1_Value_Code; "Dimension 1 Value Code")            {            }            column(Dimension_2_Value_Code; "Dimension 2 Value Code")            {            }            column(Dimension_3_Value_Code; "Dimension 3 Value Code")            {            }            column(Dimension_4_Value_Code; "Dimension 4 Value Code")            {            }            column(Sum_Amount; Amount)            {                Method = Sum;            }            column(Sum_Debit_Amount; "Debit Amount")            {                Method = Sum;            }            column(Sum_Credit_Amount; "Credit Amount")            {                Method = Sum;            }        }    }}