Query 257 Dimension Sets
src/Layers/W1/BaseApp/Finance/Dimension/DimensionSets.Query.al121 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.Dimension;using Microsoft.Finance.GeneralLedger.Setup;/// <summary>/// Query providing structured access to dimension sets with expanded shortcut dimension values./// Retrieves dimension set data with dimension codes and names for all eight shortcut dimensions configured in General Ledger Setup./// </summary>/// <remarks>/// Optimized for reporting and analysis scenarios requiring flattened dimension set data./// Uses cross joins with General Ledger Setup to provide complete dimension value information./// Returns dimension set ID, value count, and expanded dimension values for dimensions 1-8./// </remarks>query 257 "Dimension Sets"{ Caption = 'Dimension Sets'; elements { dataitem(General_Ledger_Setup; "General Ledger Setup") { dataitem(Dimension_Set_Entry; "Dimension Set Entry") { SqlJoinType = CrossJoin; column(Dimension_Set_ID; "Dimension Set ID") { } column(Value_Count) { Method = Count; } dataitem(Dimension_1; "Dimension Set Entry") { DataItemLink = "Dimension Set ID" = Dimension_Set_Entry."Dimension Set ID", "Dimension Code" = General_Ledger_Setup."Shortcut Dimension 1 Code"; column(Dimension_1_Value_Code; "Dimension Value Code") { } column(Dimension_1_Value_Name; "Dimension Value Name") { } dataitem(Dimension_2; "Dimension Set Entry") { DataItemLink = "Dimension Set ID" = Dimension_Set_Entry."Dimension Set ID", "Dimension Code" = General_Ledger_Setup."Shortcut Dimension 2 Code"; column(Dimension_2_Value_Code; "Dimension Value Code") { } column(Dimension_2_Value_Name; "Dimension Value Name") { } dataitem(Dimension_3; "Dimension Set Entry") { DataItemLink = "Dimension Set ID" = Dimension_Set_Entry."Dimension Set ID", "Dimension Code" = General_Ledger_Setup."Shortcut Dimension 3 Code"; column(Dimension_3_Value_Code; "Dimension Value Code") { } column(Dimension_3_Value_Name; "Dimension Value Name") { } dataitem(Dimension_4; "Dimension Set Entry") { DataItemLink = "Dimension Set ID" = Dimension_Set_Entry."Dimension Set ID", "Dimension Code" = General_Ledger_Setup."Shortcut Dimension 4 Code"; column(Dimension_4_Value_Code; "Dimension Value Code") { } column(Dimension_4_Value_Name; "Dimension Value Name") { } dataitem(Dimension_5; "Dimension Set Entry") { DataItemLink = "Dimension Set ID" = Dimension_Set_Entry."Dimension Set ID", "Dimension Code" = General_Ledger_Setup."Shortcut Dimension 5 Code"; column(Dimension_5_Value_Code; "Dimension Value Code") { } column(Dimension_5_Value_Name; "Dimension Value Name") { } dataitem(Dimension_6; "Dimension Set Entry") { DataItemLink = "Dimension Set ID" = Dimension_Set_Entry."Dimension Set ID", "Dimension Code" = General_Ledger_Setup."Shortcut Dimension 6 Code"; column(Dimension_6_Value_Code; "Dimension Value Code") { } column(Dimension_6_Value_Name; "Dimension Value Name") { } dataitem(Dimension_7; "Dimension Set Entry") { DataItemLink = "Dimension Set ID" = Dimension_Set_Entry."Dimension Set ID", "Dimension Code" = General_Ledger_Setup."Shortcut Dimension 7 Code"; column(Dimension_7_Value_Code; "Dimension Value Code") { } column(Dimension_7_Value_Name; "Dimension Value Name") { } dataitem(Dimension_8; "Dimension Set Entry") { DataItemLink = "Dimension Set ID" = Dimension_Set_Entry."Dimension Set ID", "Dimension Code" = General_Ledger_Setup."Shortcut Dimension 8 Code"; column(Dimension_8_Value_Code; "Dimension Value Code") { } column(Dimension_8_Value_Name; "Dimension Value Name") { } } } } } } } } } } } }}