Manual Query Input Outer Apply
Hi All,
This is Raj, newbie to Sisense. I am trying to write a manual query input as below but getting the following error
Here is my code
SELECT
ARI.Invoice_No,
ARD.Invoice_Link,
ARD.Shipper_Line_Key,
ARD.Account_No,
ARD.Quantity,
ARD.Unit_Price
FROM Accounting_v_AR_Invoice AS ARI
JOIN Accounting_v_AR_Invoice_Dist AS ARD
ON ARD.Plexus_Customer_No = ARI.Plexus_Customer_No
AND ARD.Invoice_Link = ARI.Invoice_Link
JOIN Common_v_Customer AS Customer
ON Customer.Plexus_Customer_No = ARI.Plexus_Customer_No
AND Customer.Customer_No = ARI.Customer_No
OUTER APPLY
(
SELECT
SUM(D1.xxx) AS MyVoid
FROM
(
SELECT
CAST(CASE WHEN ISNULL(AIA2.Void,0) <> 1 THEN 0 ELSE 1 END AS INT) AS xxx
FROM Accounting_v_AR_Invoice AS ARI2
LEFT OUTER JOIN Accounting_v_AR_Invoice_Applied AS Applied
ON Applied.Plexus_Customer_No = ARI2.Plexus_Customer_No
AND Applied.Invoice_Link = ARI2.invoice_Link
LEFT OUTER JOIN Accounting_v_AR_Invoice_Applied_Dist AS AIAD
ON AIAD.Plexus_Customer_No = ARI.Plexus_Customer_No
AND AIAD.Invoice_Link = ARI.Invoice_Link
LEFT OUTER JOIN Accounting_v_AR_Invoice_Applied AS AIA2
ON AIA2.Plexus_Customer_No = ARI.Plexus_Customer_No
AND AIA2.Applied_Link = AIAD.Applied_Link
WHERE ARI2.Plexus_Customer_No = ARI.Plexus_Customer_No
AND ARI2.Invoice_Link = ARI.Invoice_Link
) AS D1
WHERE d1.xxx = 1
) AS D
WHERE (ARI.Invoice_Date >= '5/1/19' AND ARI.Invoice_Date < '6/1/19')
AND (ARD.Account_No LIKE '41010%' AND ARD.Account_No <>'65010-0000-0000')
AND ARI.Void = 0
AND ARI.Credit_Memo <> 1
AND (D.MyVoid IS NULL OR D.MyVoid <> 1)
It works within my SQL environment but not in Sisense, do i need to change anything in my code to be able to match Sisense formatting.
Any help is much appreciated...
Thanks
Raj
Please sign in to leave a comment.
Comments
0 comments