Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Who writes a query?
Hi Team,
Please help me to understand the OBIEE functionality. When we run any report/dashboard, who writes a actual query? Is it a bi_server1 in OPMN components or it is a Managed Server?
Many thanks in advance.
Sagar Tippe
Answers
-
Presentation Services (sawserver) generates the Logical SQL (one query), and the BI Server (nqsserver) takes the Logical SQL and compiles it through the RPD to generate one, or more, Physical SQL queries to run on the database. bi_server1 *is* the WebLogic *Managed Server*, and nothing to do with query generation.
0 -
-
To be precise, that shows the BI Server (nqsserver) part of the flow. The "SQL Request" shown in that diagram is the Logical SQL that Presentation Services generates - not shown in that diagram.
0 -
My miss.. You are totally right the diagram doesn't show who generate the "SQL Request", which is PresentationServices..
0 -
BI Server is the component converts the Query from presentation layer SQL format to Physical Layer SQl Format
Regards,
Ahmed Elhossiny
0 -
A bit more detailled than just a diagram:
Back2 basics - A Day In The Life Of An Oracle Analytics Query
0 -
This clears my thoughts. Thanks rmoff as usual..
0
