Logical SQL is the SQL that can understand by OBI Server.When a
user requests data, then the presentation services server prepares a Logica SQL and send
it to OBI Server to retrieve dataset.The Oracle BI Server transforms the
Logical SQL into physical SQL through a process known as query processing that
can be understood by source databases.
In Presentation Service, when you create an answer
or a dashboard prompt, you create in fact a logical SQL that you can see in the
Advanced Tab of the answer
No comments:
Post a Comment
Thanks for your comment.