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

ODI 11G Expression Interface

Step 1 : Creating Interface

1. Expend project ==>>Right Click on Interface ==>>Click on new ==> Name it as m_ODS_EMPLOYEE
2. 
3. 
4. Click on mapping tab
5. Drag drop employee table from source model
6. Drag drop ods_employee table into target area ==>> click on automatic mapping
7. 
8. Select name column of ODS_EMPLOYEE table
9. in properties window==>> under the implementation
10. type the formula

EMPLOYEE.FIRST_NAME ||' '||EMPLOYEE.LAST_NAME

11. Click on ok
12. Click on flow tab
13. select the target ==>> select IKM as IKM SQL Control APPEND

Note : if IKM drop down is empty then we need to import IKM by right cliking on IKM folder of project ==>>click on import knowledge modules ==>>provide the path as C:\OBIEE_HOME\Oracle_ODI1\oracledi\xml-reference ==>> select IKM SQL CONTROL APPEND ==>>click on ok ==>>click on Close

14. under the IKM selector options ==> select flow_control =False
15. 
16. Click on save
17. Click on run
18. go to operator navigator ==> observe the interface run log
19. 
20. Right click on target table ODS_EMPLOYEE in mapping tab of interface ==>> clcik on view data ==>> notice that all 26 records loaded into target table
21. 

CONNECTION FAILED IN BI ADMIN TOOL

Problem :  the connection failed

Solution : 1. Goto database installation folder and copy listener and tnsnames

                  2.  you can go obiee installation folder and paste here

3. finally check  username and password in database with service name

ORA-12514: TNS: Listner does not currently know of service requested in connect descripator

Problem : ORA-12514: TNS: Listner does not currently know of service requested in connect descripator

Solution : 

ODI USER FUNCTIONS

Exercise 2: Converting given Phone Number in to smart phone format

Step1: Creating Flat File and reverse engineer into Source Flat File Model

1. Develop a flat file as shown and save as PHONE.txt

2. Reverse engineer into source flat file model

2. Change Phone column data type number to string
3. 
   Step2: Creating Target table and reverse engineer into Target Model

1. Develop a target  table as shown below

2. Reverse engineer into target model

Step3: Creating project level user function

1. Under RRITEC_PROJECT right click user functions à new user function
2. Provide name ,group and syntax as shown below

 

3. Click on implementations tab àClick on  
   
    àprovide below formula and select technology

'(' || SUBSTR($(PHONE),1,3)||') - ' ||SUBSTR($(PHONE),4,3) || '-' ||

SUBSTR($(PHONE),7,6)

4. Click on save and close

Step4: using user function in interface

1. Create a mapping with the name of m_ PHONE_FORMAT
2. Drag and drop phone  source table from RRITEC_FILE_MODEL
3. Drag and drop  RR_PHONE_FORMAT target table from RRITEC_TARGET_MODEL
4. Connect Ename of source  to ENAME of target
5. Select target phone column and call user function PHONEFORMAT
6. Select proper LKM and IKM
7. Save >>> run 
8.