Monday, 20 November 2023

Get Financial Dimension values for Financial Dimension X++ in SQL

select DimensionFinancialTag.Value, DimensionFinancialTag.Description from DimensionFinancialTag
join DimensionAttributeDirCategory on DimensionAttributeDirCategory.DirCategory = DimensionFinancialTag.FinancialTagCategory
join DimensionAttribute on  DimensionAttribute.RecId = DimensionAttributeDirCategory.DimensionAttribute
and DimensionAttribute.Name = 'InBound'

No comments:

Post a Comment

Display Method Data Not Showing in Query-Based SSRS Reports in D365 FO

 While working on a Query-Based SSRS Report in Dynamics 365 Finance & Operations, I faced an issue where a display method added through ...