Logical SQL > WITH clause (Subquery Factoring)
Summary
how to use the WITH..AS clause (subquery factoring) in OBIEE logical sqlContent
Hi community,
I like to implement subqueries (WITH..AS) using logical sql in OBI analysis (OBI v11.1.1.9)
However, firing the sql (see code snippet) returns an error: Nonexistent table: "table1". (HY000)
The code snippet is an example which could be implemented without the 'WITH'. However, the actual query will be more complex and I like to make use of subquery functionality, if possible.
All the web sources I found construct the sql in similar ways:
e.g. https://oracle-base.com/articles/misc/with-clause
e.g.
Tagged:
1