OBIEE initialization file

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 columns are hidden from unauthorized users.

CASE_SENSITIVE_CHARACTER_COMPARISON
This parameter specifies whether the Oracle BI Server differentiates b/w Uppercase and Lowercase characters while comparison.
This applies to internal comparisons of Oracle BI Server for caching and aggregation purpose.
Case sensitivity is a function of database operations and is set at database level. This parameter allows to match the functions of the back-end database. The following operators are affected:
1. Order By
2. Group By
3. Distinct
4. Join
5. comparison (<,>,=,<=,>=)

This parameter should be set in accordance with the back-end database. If case sensitivity is enabled at back-end database then it must be enabled in OBIEE as well and vice versa.

DB_GATEWAY_THREAD_RANGE
When Use Multithreaded Connections is selected Oracle BI Server terminates idle physical queries (thread). When not selected, one thread is tied to one database connection and even if thread is idle it consumes memory.
This parameter defines a range. The lower limit in the range is the number of threads that are kept open before Oracle BI Server takes action for terminating an idle thread.


DBFeatures.ini
This file contains the default settings for database features. Oracle recommends that you do not modify this file without consulting customer support. If you must modify the DBFeatures.ini file, use extreme caution because setting features that the underlying databases do not support can cause errors and unexpected results to be returned.

Comments

Post a Comment

Popular posts from this blog

OBIEE RPD - Physical Layer design standards

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...
Read more

Oracle and Metadata Management

Gartner defines Metadata Management is all about the organization's management of its data and information assets. Metadata describes various facets of an information asset to improve its usability throughout its life cycle. Enterprise metadata management (EMM) encompasses the roles, responsibilities, processes, organization and technology necessary to ensure that the metadata across the enterprise adds value to an enterprise's data and information. Reducing Risk and Increasing Trust in Data Enterprise Metadata Management reduces the risk inherent in making any changes to the data in the organization, be it from the source to the final report. Where many business applications and decision systems rely on the same set of data, it is important to be able to authoritatively determine the impact that a change can affect to upstream and downstream applications. By providing in depth, easy to read and interpret lineage reports, Enterprise Metadata Management reduces these risks by...
Read more
Information on Oracle Business Intelligence Cloud Services (BICS) After Oracle Open world the buzzword is Oracle BI Cloud Services (BICS). Stoppage of further Informatica version of Oracle BI Applications 7964 (OBIA) and focus on Oracle Data Integrator is talking point. Customers are worried about the direction taken by Oracle as they invested a lot and suddenly Oracle changed its focus. For Service providers it's a challenge as well because on behalf of Oracle we have to convince our Customers how smoothly we can move them to this new world without impacting their business. Oracle BI Cloud Service is bundled with 2 products: 1. Oracle BI 2. Oracle Database Oracle BI Cloud Service is one of the Platform as a Service (PaaS) that is provided by Oracle Cloud. In a nutshell we can define BICS in 4 steps: 1. Load Your Data - In present BICS for all kind of reporting we need to upload data to Cloud Oracle database. Sources can be files, on premise systems (local sy...
Read more