https://community.oracle.com/products/oracleanalytics/discussion/comment/61129#Comment_61129 Yes, it works without the EXISTS clause, but the problem is that I need to create CTEs, which are not supported on OAS Desktop. Also what's the alternatives forEXISTS clause in OAS?

https://community.oracle.com/products/oracleanalytics/discussion/comment/61115#Comment_61115 also exists clause is not supported in OAS, and need to run query that uses exists clause so what's the alternative on Oracle analytics server?

https://community.oracle.com/products/oracleanalytics/discussion/comment/61104#Comment_61104 Actually have this sample query where there is no database needed b/c here create some dummy data and it causes this error " Unsupported SQL statements." The query is: : -- Step 1: Create CTEs with Dummy Data WITH Products AS (…