The Physical layer contains information about the physical data sources to which Oracle BI Server submits queries. There can be one or more data sources in the Physical layer. It consists of Connection pool, Schema folder, Tables, Columns keys.
Let us take a closer look the different objects.
Database Object:
Double click the database to open the properties window
Double click the database to open the properties window
CRM Metadata tables: When selected, the import utility will look for the table definition in Oracle’s Siebel CRM specific tables. For Siebel CRM tables, the import reads the Siebel metadata dictionary to define the definition of physical tables and columns.
Virtual Primate Database (VPD): When a VPD is used, returned data results are contingent on the users authorization credentials. VPD provides row-level access control beyond the capabilities of roles and views.
Persist connection pool: It is a database property that is typically used to support Marketing queries.
Allow Direct database requests by default: This allows everyone to execute physical queries directly against the database from the Answers UI.
Virtual Primate Database (VPD): When a VPD is used, returned data results are contingent on the users authorization credentials. VPD provides row-level access control beyond the capabilities of roles and views.
Persist connection pool: It is a database property that is typically used to support Marketing queries.
Allow Direct database requests by default: This allows everyone to execute physical queries directly against the database from the Answers UI.
DB Features
When you import the schema or specify a database type in the General tab, the features table is automatically populated with default values appropriate for the database type. These are the SQL features that Oracle BI Server uses with this data source. If you enable SQL features that the database does not support, your query may return errors and unexpected results. If you disable supported SQL features, the server could issue less efficient SQL to the database
The Default check box identifies the default SQL features for this data source.
The Value check box allows you to enable or disable a query type.
The Ask DBMS button is used only if you are installing and querying a database that has no features table. It allows you to query a database for the SQL features it supports.
When you import the schema or specify a database type in the General tab, the features table is automatically populated with default values appropriate for the database type. These are the SQL features that Oracle BI Server uses with this data source. If you enable SQL features that the database does not support, your query may return errors and unexpected results. If you disable supported SQL features, the server could issue less efficient SQL to the database
The Default check box identifies the default SQL features for this data source.
The Value check box allows you to enable or disable a query type.
The Ask DBMS button is used only if you are installing and querying a database that has no features table. It allows you to query a database for the SQL features it supports.
Posts
