OBIEE - Opaque View
Table of Contents
1 - About
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.
2 - Articles Related
3 - How to deploy an opaque view?
You deploy an opaque view in the physical database using the Deploy View(s) utility.
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.