OBIEE - Query Processing (What happens when you issue an Logical SQL Request (through Answers for instance) ?

About

Query processing in OBIEE

• Logical SQL Request
• Logical Request Generation (Logical SQL Request with security)

• Query compilation
  • Cache service. The server will check to see if this request can be fulfilled via a prior request using the query cache. This is an on-demand, shareable and secure cache that can supports subsets, aggregations and derivations.
  • Logical Request (before navigation)
  • Logical Execution Plan
• OBIEE - Oracle BI Server Execution Engine
  • Send Physical SQL
  • Sort and join results set

Articles Related

Diagram

Documentation / Reference

• Inside the Oracle BI Server Part 2 : How Is A Query Processed?