Query 257 Dimension Sets

Base Application, Microsoft.Finance.Dimension

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")                                                {                                                }                                            }                                        }                                    }                                }                            }                        }                    }                }            }        }    }}