Logical SQL > WITH clause (Subquery Factoring)
Summaryhow to use the WITH..AS clause (subquery factoring) in OBIEE logical sql
I like to implement subqueries (WITH..AS) using logical sql in OBI analysis (OBI v126.96.36.199)
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: