Question Re: SAP DWC - SQL View type SQLScript - INTERSECT is working - MINUS not in Technology Q&A

SAP DWC - SQL View type SQLScript - INTERSECT is working - MINUS not

DirkO — Sat, 24 Sep 2022 18:18:01 GMT

Dear DWC enthusiasts,

in DWC I want to process in a Calculation View - SQL (type SQL Script) the MINUS operation.

This is the outcome of the validation:

Doing the same with INTERSECT:

When applying the MINUS operation in a Calculation View - SQL (type SQL) the result is as expected.

If MINUS is not supported within a Calculation View - SQL (type SQL Script) why is the keyword available?

Feature or bug?

What would be a professional workaround to achiv the MINUS result?

Many thanks for help.

Br.,

Dirk

Re: SAP DWC - SQL View type SQLScript - INTERSECT is working - MINUS not

Sven_Knpfler — Sat, 24 Sep 2022 18:42:45 GMT

Dear Dirk,

as per my knowledge, minus and except should serve exactly the same functionality, so you could replace the "minus" operator with "except" and get the same result. "Except" is working in sql script views.

Hope that helps.

Kind regards

Sven

Re: SAP DWC - SQL View type SQLScript - INTERSECT is working - MINUS not

DirkO — Sat, 24 Sep 2022 19:18:43 GMT

Hello Sven,

thanks "EXCEPT" does the trick.

Thank you very much.

Br.,

Dirk