Share
Report
3,808Please give me example of AL Code to create Query Object that will give similar results as following simplified SQL Query. Basically need to lookup [Dimension Set Entry]Table to get Dimension values.
Select [No.], [Sell-to Customer No.],
(Select [Dimension Value Code] from [Dimension Set Entry] where [Dimension Set ID] = [Sales Invoice Header].[Dimension Set ID] and [Dimension Code] = 'CUSTOMERGROUP') as [Customer Group],
(Select [Dimension Value Code] from [Dimension Set Entry] where [Dimension Set ID] = [Sales Invoice Header].[Dimension Set ID] and [Dimension Code] = 'DEPARTMENT') as [Department]
From [Sales Invoice Header]
(Select [Dimension Value Code] from [Dimension Set Entry] where [Dimension Set ID] = [Sales Invoice Header].[Dimension Set ID] and [Dimension Code] = 'CUSTOMERGROUP') as [Customer Group],
(Select [Dimension Value Code] from [Dimension Set Entry] where [Dimension Set ID] = [Sales Invoice Header].[Dimension Set ID] and [Dimension Code] = 'DEPARTMENT') as [Department]
From [Sales Invoice Header]
The expected results is like this:
Thank you
Categories:
I have the same question (0)
All responses (
Answers (
