You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Logical SQL > WITH clause (Subquery Factoring)

edited Aug 10, 2020 8:14PM in Sales 13 comments

Summary

how to use the WITH..AS clause (subquery factoring) in OBIEE logical sql

Content

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. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!