Query 260 Dimension Set Entries
- App
- Base Application
- Namespace
- Microsoft.Finance.Dimension
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/Finance/Dimension/DimensionSetEntries.Query.al46 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;
/// <summary>
/// Query providing direct access to dimension set entry data for reporting and analysis.
/// Retrieves all dimension set entries with associated dimension and dimension value information.
/// </summary>
/// <remarks>
/// Optimized for scenarios requiring full dimension set entry details including codes, names, and identifiers.
/// Provides structured access to dimension set data without complex joins or filtering logic.
/// Suitable for data export, reporting, and integration scenarios requiring complete dimension information.
/// </remarks>
query 260 "Dimension Set Entries"
{
Caption = 'Dimension Set Entries';
elements
{
dataitem(Dimension_Set_Entry; "Dimension Set Entry")
{
column(Dimension_Set_ID; "Dimension Set ID")
{
}
column(Dimension_Code; "Dimension Code")
{
}
column(Dimension_Value_Code; "Dimension Value Code")
{
}
column(Dimension_Value_ID; "Dimension Value ID")
{
}
column(Dimension_Name; "Dimension Name")
{
}
column(Dimension_Value_Name; "Dimension Value Name")
{
}
}
}
}