When you import the schema or specify a database type in the General tab of the Database dialog box, the Feature table is automatically populated with default values appropriate for the database type. These are the SQL features that the Oracle BI Server uses with this data source.
You can tailor the default query features for a database. For example, if a data source supports left outer join queries but you want to prohibit the Oracle BI Server from sending such queries to a particular database, you can change this default setting in the Feature table.
CAUTION: Be very careful when modifying the Feature table. 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.
- In the Physical layer of the Administration Tool, double-click the database.
- In the Database dialog box, click the Features tab.
- In the Features tab, use the information in Table 6 to help you specify properties for each SQL features.
A button that is used only if you are installing and querying a database that has no Features table. It allows you to query this database for Feature table entries. For more information, refer to Changing Feature Table Entries Using Ask DBMS.
You should use the Ask DBMS button only if installing and querying a database that has no Features table.
NOTE: The Ask DBMS button is not available if you are using an XML or a multidimensional data source.
The Ask DBMS button on the Features tab of the Database dialog box allows you to query a database for the SQL features it supports. You can change the entries that appear in the Feature table based on your query results.