MOTIVATION

OBIEE RPD consists of three layers - Physical, Business Model & Mapping (BMM), and Presentation. Physical layer is where information about physical data sources are stored. BMM layer is where measurements and terms used in business are mapped to physical sources. Presentation layer is where business model is customized for end users. As per Oracle standards/recommendation we use Import Wizard for creating a new repository file and import metadata. Connection Type used in Import Wizards: Connection type is nothing but drivers/native Application Programming Interface (API) used for accessing different databases. Some databases may be accessed using native APIs, some using ODBC. Database Object - Connection Pool Connection pool regulate access to data source. Every data source must have at least one connection pool. Connection pool provide connections to multiple concurrent queries (data source requests) immediately because of enable connection pooling. This featu...

The initialization files for OBIEE are the backbone of it's functioning. There are three important initialization files present in OBIEE server location: 1. NQSConfig.ini 2. DBfeatures.ini 3. NQClusterConfig.ini (not present in OBIEE 11g replaced by xml file) NQSConfig file contains few important parameters. Understanding those parameters help in resolving few issues instantly. For example: PROJECT_INACCESSIBLE_COLUMN_AS_NULL Security enabled columns can be displayed to unauthorized users. There are two users. One having access to all the columns of a presentation table and other user has access to few columns only (unauthorized user). When a report is built on this presentation table with all the columns included, unauthorized user trying to access this report will error out due to insufficient privileges. Once this parameter is enabled (YES), unauthorized user can see this report. A NULL expression replaces the inaccessible column in the query and secured column...