Query 36951 PowerBI Dimension Sets
src/Apps/W1/PowerBIReports/App/Core/APIs/PowerBIDimensionSets.Query.al115 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.PowerBIReports;using Microsoft.Finance.GeneralLedger.Setup;query 36951 "PowerBI Dimension Sets"{ Access = Internal; Caption = 'Power BI Dimension Sets'; DataAccessIntent = ReadOnly; elements { dataitem(General_Ledger_Setup; "General Ledger Setup") { dataitem(Dimension_Set_Entry; Microsoft.Finance.Dimension."Dimension Set Entry") { SqlJoinType = CrossJoin; column(Dimension_Set_ID; "Dimension Set ID") { } column(Value_Count) { Method = Count; } column(SystemModifiedAt; SystemModifiedAt) { } dataitem(Dimension_1; Microsoft.Finance.Dimension."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; Microsoft.Finance.Dimension."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; Microsoft.Finance.Dimension."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; Microsoft.Finance.Dimension."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; Microsoft.Finance.Dimension."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; Microsoft.Finance.Dimension."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; Microsoft.Finance.Dimension."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; Microsoft.Finance.Dimension."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") { } } } } } } } } } } } }}