Search This Blog

Monday, 26 November 2012

obia 7.9.6.3


In this article we will briefly explain the new OBIEE 11g architecture and its components. At first glance it seems complex to understand all the new pieces in OBIEE 11g, but let us take a look at the following picture:

http://1.bp.blogspot.com/_hmeCB9PAKkw/TLi6NYs56hI/AAAAAAAAAFM/1zeMA8jc7g8/s400/BIEE11gArchitecture.jpgWe can identify two main component types the OBIEE 11g: The A) Java Components and the B) System Components.

A) Java Components: These are basically J2EE applications running in Weblogic Server. There are two subcomponents here: 1. Admin Server and 2. Managed Server. Each of them running in a dedicatedJava virtual machine (JVM).
  1. Admin Server: This is nothing more than a set of J2EE applications that will help us Administering the system:
  • Admin Console (WLS) — An adminstrative user interface that provides advanced management for Weblogic, JEE components, and security
  • Fusion Middleware Control — An administrative user interface that is used to manage the BI domain.
  • JMX MBeans — Java components that provide programmatic access for managing a BI domain.
  1. Managed Server: These are J2EE applications which will help the functioning of the BIEE System (highlighted in RED):
  • BI Plugin — It routes HTTP and SOAP requests to BI Presentation Services.
  • BI Security — It enables the integration of BIEE Server and Fusion Middleware security platform through webservices calls.
  • BI Action Services — It provides the dedicated Web services that are required by the Action Framework (a nice introduction can be found here, another example of use is here and here) and that enable an administrator to manually configure which Web service directories can be browsed by users when they create actions.
  • Webservices SOA — This component provides Web services for objects in the BIEE Presentation Catalog, to invoke analysis, agents, and conditions.
  • BI Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products.
and finally

  • Two particular applications: BI Publisher (Reporting System) and RTD (technology platform which enable the analysis of data and provides insight by using data mining algorithms and techniques in real time).
B) System Components: These are non-J2EE components, such as processes and services written in C++ and java.

  • BI Server — It provides capabilities to query and access data as well as services for accessing and managing the RPD file (BIEE Metadata).
  • BI Presentation Services — It provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.
  • BI Scheduler — Provides extensible scheduling for analyses to be delivered to users at specified times. (BI Publisher has its own scheduler.)
  • BI JavaHost — It enables BI Presentation Services to support various components: Java tasks for BI Scheduler, BI Publisher, and Graph generation.
  • BI Cluster Controller — It distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.
In addition, the BI Domain requires a set of configuration files, the repository (RPD) file, the Presentation Catalog files, etc. Likewise, BIEE System uses a set of metadata tables stored in a relational database like Oracle.

How to Start BIEE System:
 There are multiple ways to start the BIEE System, but it must follow certain order. Based on the description given above we need to :

1.
 Start NodeManager : By default in Windows it runs when the OS starts (Reference about NodeManager can be found here)
2.
 Start Admin Server : Initiate Weblogic Server.
3.
 Start Managed Server : Initiate the main applications. Based on the picture above, these are highlighted in Red : BI Plugin, BI Security, BI Action Service, BI Webservices SOA. If you are planning to use BI Publisher or RTD then it must also be started.
4.
 Start BIEE Services : These are the main BIEE processes which are controlled by OPMN: BI Server, BI Presentation Server, BI JavaHost. If you are planning to use BI Scheduler then also start it. Or if your instance is a clustered environment then also start the BI Cluster Controller.



STEP BY STEP REPOSITORY CREATION UTILITY(RCU11G) ON WINDOWS64BIT
Before starting the installation you need to change all Prerequisites

DB Parameter Changes initorcl.ora
 

# Processes and Sessions
###########################################
processes=500
sessions=500

# Cursors and Library Cache
###########################################
open_cursors=500

Run setup.exe
Select Create   ---> Click next
 
http://1.bp.blogspot.com/-4eb6vSVi0gA/TvMd4WfDUaI/AAAAAAAAAuc/0CFYeRchw3Q/s400/1.png

You need to Eneter your Database Detail :-
Database type :-  Oracle Database
Hostnmae  :- Muthu-PC  or localhost
Port :- 1521
Servicename : orcl
Username : sys  
 
Password  : syspassword
 
Role : sysdba  
Click Next
http://4.bp.blogspot.com/-o0EiIFV3T3U/TvMd5uF2PVI/AAAAAAAAAuk/qKKreRQ2ack/s400/2.png

Checking all Prerequisites
 
http://2.bp.blogspot.com/-ylYrC9GvH4U/TvMd7FEtkAI/AAAAAAAAAus/30JWDnljPbQ/s400/3.png
 Enter new Prefix name i used Dev
Component What are all the component you want you can select ? I selected all Components .

Click Next
http://1.bp.blogspot.com/-hEbQi2L-ZFk/TvMd8iEnqHI/AAAAAAAAAu0/ze_6SNEgm-E/s400/4.png

Checking all Prerequisites
http://3.bp.blogspot.com/-7ZQjL37pKeU/TvMd9lJmz6I/AAAAAAAAAu8/StDczpdt_qE/s400/5.png
 Enter Password   click Next

 Enter all Variables then Click next
http://1.bp.blogspot.com/-dMOAiidDNyA/TvMeAD9c1JI/AAAAAAAAAvM/3V5-KCENdUc/s400/7.png

http://4.bp.blogspot.com/-qmnIebRmek8/TvMeBa98XHI/AAAAAAAAAvU/7FT2HDp1OiE/s400/8.png

http://3.bp.blogspot.com/-8rVveu4uivM/TvMeClqVMlI/AAAAAAAAAvc/M9whXeZMTPI/s400/9.png

http://1.bp.blogspot.com/--CiRfIpgimE/TvMeENVB7BI/AAAAAAAAAvk/8DYnXA2WI_c/s400/10.png

http://4.bp.blogspot.com/-PpKw-Cn_7gM/TvMeFSvgphI/AAAAAAAAAvs/u9J7H_3wzn8/s400/11.png

Repository Creation Sucessfully Completed .
 Install Oracle Business intelligence enterprise edition11g Installation below Steps

http://1.bp.blogspot.com/-mqkXlHCmrNU/TvMl3oNo4KI/AAAAAAAAAyU/uOwUEkBrs1w/s400/1.png


http://2.bp.blogspot.com/-EPnEWx9AYDM/TvMl5AGX8zI/AAAAAAAAAyc/vjgnGmzxBbc/s400/2.png

http://3.bp.blogspot.com/-0DVZ7LUe9MM/TvMl6O-15_I/AAAAAAAAAyk/NRaUsSrjzPg/s400/3.png

http://2.bp.blogspot.com/-YPVqQqeI-6E/TvMmF1PTHeI/AAAAAAAAAyw/HIDXZayDX-4/s400/4.png



http://1.bp.blogspot.com/-DKYtRwf8nMs/TvMmQzrCSII/AAAAAAAAAzE/EFNLbMA88U8/s400/6.png


Click Yes

http://4.bp.blogspot.com/-lb09oW4CFLA/TvMs4b1stcI/AAAAAAAAAzQ/SPgqKCMTsF8/s400/7.png

http://2.bp.blogspot.com/-wmg44gcdWUM/TvMtPJsqOdI/AAAAAAAAAzc/3nocka21q68/s400/8.png

http://3.bp.blogspot.com/-jbTV-2NcIl0/TvMtQiUp_VI/AAAAAAAAAzk/37v8jycOLHE/s400/9.png

http://3.bp.blogspot.com/-ABE_HzJmbUQ/TvMtST8GL6I/AAAAAAAAAzo/cuVOmETCMZ4/s400/10.png

http://4.bp.blogspot.com/-zS6Mwf2JQr0/TvMtUPzNpFI/AAAAAAAAAz0/Wik05rUk5ok/s400/11.png

http://2.bp.blogspot.com/-wSRZgDN57AM/TvMtWKAQZbI/AAAAAAAAAz8/svQsi6SY_zA/s400/13.png

http://3.bp.blogspot.com/-WwleXj7XZ9Y/TvMtXyjVIsI/AAAAAAAAA0E/HAlO6FPyslA/s400/14.png

http://4.bp.blogspot.com/-BjZYCIS4vQc/TvMwGjP0TaI/AAAAAAAAA08/BHtDyjrCVAU/s400/15.png

http://3.bp.blogspot.com/-947wbP1x0mE/TvMwH3WwXWI/AAAAAAAAA1E/2SgDa1mWP78/s400/16.png

http://4.bp.blogspot.com/-m9zvFQH9img/TvMwJYrM-2I/AAAAAAAAA1M/avgSPI3v18Q/s400/17.png

http://4.bp.blogspot.com/-cWTDsRcc-ZY/TvMwK1YhRHI/AAAAAAAAA1U/LuSLwWRTK1U/s400/18.png
Username = weblogic
Password  = welcome1

http://1.bp.blogspot.com/-XusIhXRslkY/TvMwMLEHb0I/AAAAAAAAA1c/8q2bQvuWTcA/s400/20.png


http://4.bp.blogspot.com/-Xq4yiv4R3jc/TvNlz9VugnI/AAAAAAAAA_o/3A-QnY6yfKA/s400/1.png

http://3.bp.blogspot.com/-6vmXIdfvcww/TvNl1gH8QKI/AAAAAAAAA_w/RUioNpDfMsc/s400/2.png

http://3.bp.blogspot.com/-3nMKXN-8kiA/TvNl3-O-PNI/AAAAAAAAA_4/lAnR53EuwFA/s400/3.png

http://1.bp.blogspot.com/-3kRPN0nFDJo/TvNl663uqkI/AAAAAAAABAA/hPZkI5lU4d4/s400/4.png

http://1.bp.blogspot.com/-EP5-Yi4_rvo/TvNmr19jyGI/AAAAAAAABAI/MtBagbdBmq4/s400/5.png

http://1.bp.blogspot.com/-FDZjIBTJkyA/TvNmwPjTgiI/AAAAAAAABAQ/jNRZO2Y5K8w/s400/6.png

http://2.bp.blogspot.com/-XBXfaw8Bcpk/TvNmzOPkndI/AAAAAAAABAY/f8v271q2bmE/s400/7.png

http://3.bp.blogspot.com/-4a_tWdf4U6A/TvNm1b3n6GI/AAAAAAAABAg/S4XQ954dX58/s400/8.png

http://4.bp.blogspot.com/-xNnpIzkY_TU/TvNm3LhDljI/AAAAAAAABAo/9LGVbwMDIjc/s400/9.png
  In this article we will briefly explain the new OBIEE 11g architecture and its components. At first glance it seems complex to understand all the new pieces in OBIEE 11g, but let us take a look at the following picture:

http://1.bp.blogspot.com/_hmeCB9PAKkw/TLi6NYs56hI/AAAAAAAAAFM/1zeMA8jc7g8/s400/BIEE11gArchitecture.jpgWe can identify two main component types the OBIEE 11g: The A) Java Components and the B) System Components.

A) Java Components: These are basically J2EE applications running in Weblogic Server. There are two subcomponents here: 1. Admin Server and 2. Managed Server. Each of them running in a dedicatedJava virtual machine (JVM).
  1. Admin Server: This is nothing more than a set of J2EE applications that will help us Administering the system:
  • Admin Console (WLS) — An adminstrative user interface that provides advanced management for Weblogic, JEE components, and security
  • Fusion Middleware Control — An administrative user interface that is used to manage the BI domain.
  • JMX MBeans — Java components that provide programmatic access for managing a BI domain.
  1. Managed Server: These are J2EE applications which will help the functioning of the BIEE System (highlighted in RED):
  • BI Plugin — It routes HTTP and SOAP requests to BI Presentation Services.
  • BI Security — It enables the integration of BIEE Server and Fusion Middleware security platform through webservices calls.
  • BI Action Services — It provides the dedicated Web services that are required by the Action Framework (a nice introduction can be found here, another example of use is here and here) and that enable an administrator to manually configure which Web service directories can be browsed by users when they create actions.
  • Webservices SOA — This component provides Web services for objects in the BIEE Presentation Catalog, to invoke analysis, agents, and conditions.
  • BI Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products.
and finally

  • Two particular applications: BI Publisher (Reporting System) and RTD (technology platform which enable the analysis of data and provides insight by using data mining algorithms and techniques in real time).
B) System Components: These are non-J2EE components, such as processes and services written in C++ and java.

  • BI Server — It provides capabilities to query and access data as well as services for accessing and managing the RPD file (BIEE Metadata).
  • BI Presentation Services — It provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.
  • BI Scheduler — Provides extensible scheduling for analyses to be delivered to users at specified times. (BI Publisher has its own scheduler.)
  • BI JavaHost — It enables BI Presentation Services to support various components: Java tasks for BI Scheduler, BI Publisher, and Graph generation.
  • BI Cluster Controller — It distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.
In addition, the BI Domain requires a set of configuration files, the repository (RPD) file, the Presentation Catalog files, etc. Likewise, BIEE System uses a set of metadata tables stored in a relational database like Oracle.

How to Start BIEE System:
 There are multiple ways to start the BIEE System, but it must follow certain order. Based on the description given above we need to :

1.
 Start NodeManager : By default in Windows it runs when the OS starts (Reference about NodeManager can be found here)
2.
 Start Admin Server : Initiate Weblogic Server.
3.
 Start Managed Server : Initiate the main applications. Based on the picture above, these are highlighted in Red : BI Plugin, BI Security, BI Action Service, BI Webservices SOA. If you are planning to use BI Publisher or RTD then it must also be started.
4.
 Start BIEE Services : These are the main BIEE processes which are controlled by OPMN: BI Server, BI Presentation Server, BI JavaHost. If you are planning to use BI Scheduler then also start it. Or if your instance is a clustered environment then also start the BI Cluster Controller.



STEP BY STEP REPOSITORY CREATION UTILITY(RCU11G) ON WINDOWS64BIT
Before starting the installation you need to change all Prerequisites

DB Parameter Changes initorcl.ora
 

# Processes and Sessions
###########################################
processes=500
sessions=500

# Cursors and Library Cache
###########################################
open_cursors=500

Run setup.exe
Select Create   ---> Click next
 
http://1.bp.blogspot.com/-4eb6vSVi0gA/TvMd4WfDUaI/AAAAAAAAAuc/0CFYeRchw3Q/s400/1.png

You need to Eneter your Database Detail :-
Database type :-  Oracle Database
Hostnmae  :- Muthu-PC  or localhost
Port :- 1521
Servicename : orcl
Username : sys  
 
Password  : syspassword
 
Role : sysdba  
Click Next
http://4.bp.blogspot.com/-o0EiIFV3T3U/TvMd5uF2PVI/AAAAAAAAAuk/qKKreRQ2ack/s400/2.png

Checking all Prerequisites
 
http://2.bp.blogspot.com/-ylYrC9GvH4U/TvMd7FEtkAI/AAAAAAAAAus/30JWDnljPbQ/s400/3.png
 Enter new Prefix name i used Dev
Component What are all the component you want you can select ? I selected all Components .

Click Next
http://1.bp.blogspot.com/-hEbQi2L-ZFk/TvMd8iEnqHI/AAAAAAAAAu0/ze_6SNEgm-E/s400/4.png

Checking all Prerequisites
http://3.bp.blogspot.com/-7ZQjL37pKeU/TvMd9lJmz6I/AAAAAAAAAu8/StDczpdt_qE/s400/5.png
 Enter Password   click Next

 Enter all Variables then Click next
http://1.bp.blogspot.com/-dMOAiidDNyA/TvMeAD9c1JI/AAAAAAAAAvM/3V5-KCENdUc/s400/7.png

http://4.bp.blogspot.com/-qmnIebRmek8/TvMeBa98XHI/AAAAAAAAAvU/7FT2HDp1OiE/s400/8.png

http://3.bp.blogspot.com/-8rVveu4uivM/TvMeClqVMlI/AAAAAAAAAvc/M9whXeZMTPI/s400/9.png

http://1.bp.blogspot.com/--CiRfIpgimE/TvMeENVB7BI/AAAAAAAAAvk/8DYnXA2WI_c/s400/10.png

http://4.bp.blogspot.com/-PpKw-Cn_7gM/TvMeFSvgphI/AAAAAAAAAvs/u9J7H_3wzn8/s400/11.png

Repository Creation Sucessfully Completed .
 Install Oracle Business intelligence enterprise edition11g Installation below Steps

http://1.bp.blogspot.com/-mqkXlHCmrNU/TvMl3oNo4KI/AAAAAAAAAyU/uOwUEkBrs1w/s400/1.png


http://2.bp.blogspot.com/-EPnEWx9AYDM/TvMl5AGX8zI/AAAAAAAAAyc/vjgnGmzxBbc/s400/2.png

http://3.bp.blogspot.com/-0DVZ7LUe9MM/TvMl6O-15_I/AAAAAAAAAyk/NRaUsSrjzPg/s400/3.png

http://2.bp.blogspot.com/-YPVqQqeI-6E/TvMmF1PTHeI/AAAAAAAAAyw/HIDXZayDX-4/s400/4.png



http://1.bp.blogspot.com/-DKYtRwf8nMs/TvMmQzrCSII/AAAAAAAAAzE/EFNLbMA88U8/s400/6.png


Click Yes

http://4.bp.blogspot.com/-lb09oW4CFLA/TvMs4b1stcI/AAAAAAAAAzQ/SPgqKCMTsF8/s400/7.png

http://2.bp.blogspot.com/-wmg44gcdWUM/TvMtPJsqOdI/AAAAAAAAAzc/3nocka21q68/s400/8.png

http://3.bp.blogspot.com/-jbTV-2NcIl0/TvMtQiUp_VI/AAAAAAAAAzk/37v8jycOLHE/s400/9.png

http://3.bp.blogspot.com/-ABE_HzJmbUQ/TvMtST8GL6I/AAAAAAAAAzo/cuVOmETCMZ4/s400/10.png

http://4.bp.blogspot.com/-zS6Mwf2JQr0/TvMtUPzNpFI/AAAAAAAAAz0/Wik05rUk5ok/s400/11.png

http://2.bp.blogspot.com/-wSRZgDN57AM/TvMtWKAQZbI/AAAAAAAAAz8/svQsi6SY_zA/s400/13.png

http://3.bp.blogspot.com/-WwleXj7XZ9Y/TvMtXyjVIsI/AAAAAAAAA0E/HAlO6FPyslA/s400/14.png

http://4.bp.blogspot.com/-BjZYCIS4vQc/TvMwGjP0TaI/AAAAAAAAA08/BHtDyjrCVAU/s400/15.png

http://3.bp.blogspot.com/-947wbP1x0mE/TvMwH3WwXWI/AAAAAAAAA1E/2SgDa1mWP78/s400/16.png

http://4.bp.blogspot.com/-m9zvFQH9img/TvMwJYrM-2I/AAAAAAAAA1M/avgSPI3v18Q/s400/17.png

http://4.bp.blogspot.com/-cWTDsRcc-ZY/TvMwK1YhRHI/AAAAAAAAA1U/LuSLwWRTK1U/s400/18.png
Username = weblogic
Password  = welcome1

http://1.bp.blogspot.com/-XusIhXRslkY/TvMwMLEHb0I/AAAAAAAAA1c/8q2bQvuWTcA/s400/20.png


http://4.bp.blogspot.com/-Xq4yiv4R3jc/TvNlz9VugnI/AAAAAAAAA_o/3A-QnY6yfKA/s400/1.png

http://3.bp.blogspot.com/-6vmXIdfvcww/TvNl1gH8QKI/AAAAAAAAA_w/RUioNpDfMsc/s400/2.png

http://3.bp.blogspot.com/-3nMKXN-8kiA/TvNl3-O-PNI/AAAAAAAAA_4/lAnR53EuwFA/s400/3.png

http://1.bp.blogspot.com/-3kRPN0nFDJo/TvNl663uqkI/AAAAAAAABAA/hPZkI5lU4d4/s400/4.png

http://1.bp.blogspot.com/-EP5-Yi4_rvo/TvNmr19jyGI/AAAAAAAABAI/MtBagbdBmq4/s400/5.png

http://1.bp.blogspot.com/-FDZjIBTJkyA/TvNmwPjTgiI/AAAAAAAABAQ/jNRZO2Y5K8w/s400/6.png

http://2.bp.blogspot.com/-XBXfaw8Bcpk/TvNmzOPkndI/AAAAAAAABAY/f8v271q2bmE/s400/7.png

http://3.bp.blogspot.com/-4a_tWdf4U6A/TvNm1b3n6GI/AAAAAAAABAg/S4XQ954dX58/s400/8.png

http://4.bp.blogspot.com/-xNnpIzkY_TU/TvNm3LhDljI/AAAAAAAABAo/9LGVbwMDIjc/s400/9.png
  

1 comment: