OBIEE 10g vs 11g

1. NQSconfig.INI File Path:
1. OBIEE 10g: OracleBI/server/Config
2. OBIEE 11G: ORACLE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn

2. Repository (.rpd) Encryption:
1. OBIEE 10g - certain sensitive elements within a repository are encrypted.
2. OBIEE 11g - entire repository is encrypted using a key derived from a user supplied password. An 11g repository can ONLY be opened with the password, and there is no mechanism to recover a lost password.

3. Defining Users and Groups –
1. OBIEE 10g - it was possible to define users and groups within a repository file using the Oracle BI Administration tool.
2. OBIEE 11g - users and groups are defined and set from Admin Console
1. You can no longer define users and groups within a repository. The Oracle Business Intelligence Enterprise Edition Upgrade Assistant migrates users and groups from a 10g repository into the embedded LDAP server in an 11g installation.

4. OBIEE 10g Architecture:
1. No WebLogic
2. Security is set via LDAP Tables within RPD
3. No Lookup feature
4. No RollingPeriod - Time Series
5. Stop Services - Copy RPD > Repository folder >
6. NQSConfig.INI - manual

5. OBIEE 11g Components:
1. OBI Server
2. OBI Presentation Server
3. OBI Scheduler
4. OBI Cluster Controller
5. OBI Java Host

6. OBIEE 11g Only Features:
1. Admin Console
2. Enterprise Manager - most server management are done
3. Lookup tables
4. Skipped Hierarchy
5. Time Series > RollingPeriod - Measure Functions
6. Dynamic re-arrangement of pivot tables columns in the dashboard
7. Dynamic grouping and sorting on pivot and other views
8. Instanceconfig.INI - OBI Server
9. Instanceconfig.xml - OBI Presentation

"Live, Learn, Apply & Educate!" DRAZDA