OBIEE - Opaque View

Bi Server Architecture With Client


An opaque view is in the physical layer a physical table that consists of a Select statement .

In the repository, opaque views appear as tables in the physical layer but the view does not actually exist.

Obiee Opaque View

How to deploy an opaque view?

You deploy an opaque view in the physical database using the Deploy View(s) utility.

Obiee Deploy View

After deploying an opaque view, it is called a deployed view. Opaque views can be used without deploying them but the Oracle BI Server has to generate a more complex query when an opaque view is encountered.

Databases such as XLS and nonrelational database do not support opaque views and, therefore, cannot run the view deployment utility.

To verify opaque views are supported by a database, make sure that the CREATE_VIEW_SUPPORTED SQL feature is selected in the Database dialog box, in the Features tab.

Documentation / Reference

Discover More
Obiee Session Variable In Connection Pool
OBIEE - Where can I use a BI Server variable (session/repository) ?

When you have create a server variable, you have to reference it. You can use them : in BI Server in BI Presentation Service in Delivers in a logical sql statement through a client connexion....
Obiee Foreign Key Complex Join
OBIEE 10G - Complex (Join|Operator) (Physical and Logical)

In 10g, A complex join is a metadata of sql join statement in the repository. In 11g, they doesn't exist anymore. In the business model, OBI recommends using complex logical joins instead of foreign...

Share this page:
Follow us:
Task Runner