Skip to main content

OBIEE 11G ARCHITECTURE WITH EXPLANATION





Below diagram describes the standard logical architecture of Oracle business intelligence 11g system



The entire system architecture is called BI Domain, this BI Domain divided into Java components and non-Java components. Java components are weblogic server Domain components and non-java components are Oracle BI system components.






Weblogic Server Domain

This domain consists of Managed server and Admin Server. These services comprises mainly with all the java modules to trigger the java services.


Admin Server: A JEE container that runs in a dedicated Java virtual machine that contains Java components for administering the system .It typically trigger the start, stop kind of admin activity for his peer Manager server processes.

Managed Server:A JEE container that runs in a dedicated Java virtual machine that provides the run-time environment for the Java-based services and applications within the system. The services comprises of BI plug-in, Security, publisher, SOA, BI Office services etc



Node Manager: Node Manager is a separate java utility runs to trigger the auto start, stop, restart activities and it provides process management services for the Admin server and Managed Server.



Oracle Process Manager and Notification Server (OPMN):By using this OPMN services we can stop and start all system components of BI. It is monitored, managed and controlled by Fusion Middleware Controller.


Oracle Weblogic Server (Console):

It is a Java EE application server that supports the deployment of Oracle Business Intelligence Java components. Oracle WebLogic Server Administration Console access has been provided by Fusion Middleware Control. Oracle WebLogic Server Administration Console enables to monitor and manage a WebLogic Server domain. Its capabilities include the following:

· Monitoring health and performance of JEE servers· Configuring WebLogic domains· Stopping and starting JEE servers· Viewing JEE server logs



Fusion Middleware Control:


Fusion Middleware Control is a browser-based tool and the recommended method for monitoring, managing, and configuring Oracle Business Intelligence components.



Starting, stopping, and restarting all system components (BI Server, BI Presentation Server) and Managed Servers

· Configuring preferences and defaults


· Starting, stopping, and restarting all system components (BI Server,BI Presentation Server) and Managed Servers


· Managing performance and monitoring system metrics(DMS-Dynamic Monitoring System)


· Performing diagnostics and logging (ODL-Oracle Diagnostic Logging)Fusion Middleware Control also provides access to Oracle WebLogic Server Administration Console, where you monitor and manage Oracle Business Intelligence Java components.


Java components:
Deployed as one or more Java EE applications:



Administrative Components — Enterprise Management applications and JMX MBeans for managing all configuration and run-time settings for Oracle Business Intelligence.



Oracle BI Publisher — This component provides an enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents to employees, customers, and suppliers.


Oracle BI Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products.



Oracle BI Action Services — This component provides the dedicated Web services that are required by the Action Framework and that enable an administrator to manually configure which Web service directories can be browsed by users when they create actions.



Oracle Real-Time Decisions (Oracle RTD) — This component provides enterprise analytics software solutions that enable companies to make better decisions in real-time at key, high-value points in operational business processes.



Oracle BI Security Services — This component provides dedicated Web services that enable the integration of the Oracle BI Server with the Oracle Fusion Middleware security platform i.e JPS (Java Platform Security) , CSF (Credential Store Framework) and users and groups managed by BI LDAP security.


Oracle BI SOA Services — This component provides dedicated Web services for objects in the Oracle BI Presentation Catalog, to invoke analyses, agents, and conditions. They make it easy to invoke Oracle Business Intelligence functionality from Business Process Execution Language (BPEL) processes.


Oracle BI Plug-in — A JEE application that routes HTTP and SOAP requests to Oracle BI Presentation Services.


System components:
Deployed as non-JEE components, such as processes and services written in C++ and J2SE:


Oracle BI Server — This component provides the query and data access capabilities at the heart of Oracle Business Intelligence and provides services for accessing and managing the enterprise semantic model (stored in a file with a .RPD extension).



Oracle BI Presentation Services — This component 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.


Oracle BI Scheduler — This component provides extensible scheduling for analyses to be delivered to users at specified times. (Oracle BI Publisher has its own scheduler)



Oracle BI JavaHost — This component provides component services that enable Oracle BI Presentation Services to support various components such as Java tasks for Oracle BI Scheduler, Oracle BI Publisher, and graph generation.



Oracle BI Cluster Controller — This components distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.

Comments

  1. Hi Kashif,
    Thanks for your post it's helpful to me i am the beginner if you have any document regarding to OBIEE11g can u please share with me my ID is khaleel.orcle@gmail.com.

    ReplyDelete
    Replies
    1. Hi Shaik,

      Let me know if you need any sort of help in OBIEE

      Delete
  2. Hi Kashif

    Thank you for this post, I'm also a beginner and would appreciate more OBIEE 11g resources. My email is snyandebv@gmail.com. Thank you.

    ReplyDelete
    Replies

    1. Ms Mary,

      I will try to send you some resource, very soon I will update some resource for beginners

      Delete
  3. Hi Sir Kashif!

    I'm a beginner in OBIEE. Our DBA was able to install Oracle BIEE. But I accidentally created another master repository. We were able to remake it with the RCUs.

    But know we are having problems in the Load Plan Executions showing this warning:

    "Unable to access Oracle Data Integrator repository. You will not be able generate or execute load plans."

    All the connection are good. Just don't know what to do with that warning.

    ReplyDelete
    Replies
    1. Matthew,

      Just ignore this warning, It is not a problem, Continue with your OBIEE development

      Delete
  4. Hello Kashif,

    how OBIEE is doing in ETL space currently,,, how do you see its future ???
    Mahender

    ReplyDelete
    Replies

    1. Mahender,

      OBIEE is doing good with ETL space, I call it has Data warehousing space.

      Delete
  5. HI KASHIF,
    This is Shaik yes It's very helpful to me your support on OBIEE.I am the beginner on OBIEE I have questions At what scenario we can implement the presentation variable, Request variable, Session variables and how to implement. Its helpful to me if you reply.

    ReplyDelete
  6. Hello Kashif Sir,
    Will you please tell me the Ultimate Aim of OBIEE? means need/purpose of using it.
    please let me know..

    ReplyDelete
  7. Hi Kashif,

    This is Prasanna working as SE in Hyd since 2 years on CRM and EBS platform. I am interested to learn reporting tool i.e., OBIEE 11g. Please suggest me if i can build my carrier in OBIEE.

    ReplyDelete
  8. What are the key role and responsibilities of an obia administrator?..

    ReplyDelete
  9. Hi,
    I am very new to the obiee,could you please share me the document/Case studies/ References for starter level : mohitgarg15aug@gmail.com
    Thank you,

    -Mohit

    ReplyDelete
  10. Hi...this is shasha from Hyderabad. Looking to make career in obiee side.
    I am.the beginner for this obiee space, kindly guide me how to start learning obiee ...what are the prerequisites for learning obiee. Share the documents n real time scenarios which are important to learn obiee. My email id : shasha_knl@yahoo.co.in.

    ReplyDelete
  11. Reema
    Hi
    Please share more documents to rfsreems1992@gmail.com

    ReplyDelete
  12. Hello,

    Thanks for the excellent post.
    I am Santhosh, currently working in obiee project, where the DEV phase about to complete and , ready to move to prod.
    Can you please suggest me the precautionary steps to be taken while moving into PRODUCTION. This is my first project
    Thanks in advance,
    Santhosh

    ReplyDelete
  13. If possible please drop me the doc to santhoshsreshta@gmail.com

    ReplyDelete
  14. keep sharing your information regularly for my future reference. This content creates a new hope and inspiration with in me

    Best Dot Net institutes in chennai

    ReplyDelete
  15. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing. Know more about OBIEE Tutorials For Beginners

    ReplyDelete
  16. These information really worth saying, i think you are master of the content and thank you so much sharing that valuable information.
    Best Dot Net Training Institutes in Chennai

    ReplyDelete
  17. Hi All, i am beginner in OBIEE please assist me. ai anuone having documents related to OBIEE,Informatica, and ODI please send me on my mail id.
    sanjeev.singhai27@gmail.com

    Many thanks in advance.

    ReplyDelete
  18. Hello Kashif,

    Thanks for the post. I am interested in learning OBIIE. Would you please share documents related to OBIEE on my id garimabkapoor@gmail.com

    ReplyDelete

Post a Comment

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope