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
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.
what @rmoff said as diagram..
https://www.rittmanmead.com/blog/2010/03/inside-the-oracle-bi-server-part-2-how-is-a-query-processed/
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.
My miss.. You are totally right the diagram doesn't show who generate the "SQL Request", which is PresentationServices..
BI Server is the component converts the Query from presentation layer SQL format to Physical Layer SQl Format
Regards,
Ahmed Elhossiny
A bit more detailled than just a diagram:
Back2 basics - A Day In The Life Of An Oracle Analytics Query
This clears my thoughts. Thanks rmoff as usual..
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
What am I doing wrong here? There is only one selection in the Target Canvas??
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
