OBIEE 10G Vs 11G

Architecture

1. In 10 G by default web server OC4J . however it is not recommended for production deployment .Hence we used to use training and development box purpose
2. In 11G by default web server is web logic server
3. In 10G for production box we used to use IIS web server
4. In 11G(11.1.1.7) all six servers(OBIS,OBIPS,OBIJH,OBISCH,OBICC,OBIEssBaseAgnt) are integrated as OPMN .In 10g there is no OPMN
5. In 10g EM/Console are not available .
6. In 11G predefined schemas DEV_BIPLATFORM ,DEV_MDS are available with the installation of RCU

Physical Layer

1. In 10G there is no repository level password
2. 1n 10G back end we have mainly two folders
1. ORACLEBI (stores RPD relevant info)
2. ORACLEBIDATA (stores web catalog relevant info)
3. For physical join purpose we have two buttons
1. Foreign key (Equi Join)
2. Complex Join (non Equi Join)
4. Join condition we need drag and drop from PK (DIM) to FK(Fact) or less number of records to many number of records

BMM Layer

1. fact table denoted with yellow color
2. Dim table denoted with gray color
3. measure columns are associated with sigma symbol
4. To create logical join we will use only Complex join

Presentation Layer

1. Subject area in 11g was called as presentation catalog in 10g
2. Hierarchy objects are not available in 10G presentation layer

Testing and validating

1. Best practices are displaying in consistency check manager window
2. With new new repository by default a user (administrator) and group (Administrators) will be created
3. We can not delete administrator user or administrators group
4. Administrator is a member of administrators group
5. RPD authentication is possible in 10g .hence we can create new users and groups directly in RPD
6. Roles are not available in 10G

           Loading repository

1. Close the RPD it is mandatory in 10g
2. Configuring NQSCONFIG.ini file
1. Navigate to D:\OracleBI\server\Config
2. open NQSCONFIG.INI file
3. change configuration of repository section as shown below | save | close

[ REPOSITORY ]

Star    =    B206_EBA.rpd, DEFAULT;

3. restart Oracle BI Server
1. go to run
2. type services.msc
3. right click on Oracle BI Server
4. Click on restart
4. verify the log file of OBIS
1. Navigate to D:\OracleBI\server\Log
2. open nqserver.log file
3. press ctrl+end
4. observe the rpd name loaded in OBIS
5. Develop sample report using our rpd
1. make sure start oc4j and OBIPS server started
2. go to start → oracle business intelligence → Click on presentation services
3. provide username as Administrator password as RRitec123
4. click on answers link → click on B206_SupplierSalesRep → Click on year ,region,dollars columns  → click on results
5. observe output

Adding Multiple sources

N/A

Calculations

N/A

Hierarchies

1. Parent and unbalanced(Skipped and Ragged)hierarchies are not available

Learn level

Creating Web Catalog

1. configuring instanceconfig.xml file
1. Navigate to D:\OracleBIData\web\config
2. open instanceconfig.xml
3. change catalog path as shown below

<CatalogPath>D:/OracleBIData/web/catalog/B206</CatalogPath>

4. Save
5. Close
4. Restart oracle Bi Presentation Server
1. start→ run → type services.msc → right click on oracle Bi presentation server
2. click on restart
5. Conform catalog in catalog folder
1. navigate to D:\OracleBIData\web\catalog
2. observe B206 catalog created

Working with column properties formulas

1. interaction and write back options are available in 10G under column format tab

Working with filters

1. variable prompt not available
2. slider option for numeric data type not available

Working with Combining with similar request and DDR

N/A

Working with Views

1. some new views are introduced like Map ,selection Steps , Recommended Visualization ..etc

Working with Dashboards

1. Creating shared dashboard
1. Login to analytics as administrator
2. Click on settings
3. Click on Administration → Click on Manage Interactive Dashboards
4. Click on Create Dashboard
5. Provide dashboard name as B206
6. Finished  → Finished → Close window
2. dashboard level image and variable prompts are not available
3. Alert ,action link and action link menu dashboard objects are not available
4. Guided navigation removed in 11g and introduced Condition in place of it
5. IBOT (intelligence bursting output tool ) renamed as Agent