Skip to main content

OBIEE Products and Components


Oracle Business Intelligence Enterprise Edition (OBIEE) is one of the oracle product which is the intelligence platform for decision support management system. It supports and delivers wide range of analytics and reporting capabilities.

OBIEE components are
·         Oracle BI Interactive Dashboard
·         Oracle BI Answers
·         Oracle BI Publisher
·         Oracle BI Delivers
·         Oracle BI Server
·         Oracle BI Office
·         Oracle BI Mobile
·         Ad Hoc Queries
 
Oracle BI Interactive Dashboard
BI Interactive dashboard is a component and part of BI presentation layer , which is used to show or to display the combination of compound layouts like pivot table, charts, prompts, links, alerts, gauges, funnels, narrative contents in a different view and column selector.
A combination of all these are represent as a dashboard with more sections and columns.

Oracle BI Answers
Bi Answers Provides the information about the sales or revenue by querying large amount of data into consolidated one by using the logical columns, measure columns from rpd admin tool.

It use to display the drill down of the values and data’s to know more consolidated detail level of information’s.  In BI answers we can have the combination of pivot table, charts, view and column selector, selection steps for calculations.

It named as “Analysis” or “Request” from the various data source and grouped in to one to view more detailed level of the management system process.

Oracle BI Publisher
BI Publisher separates the creation of data from the process of formatting it for different uses. The engine can format any well-formed XML data, allowing integration with any system that can generate XML, including Web Services or any data source available through JDBC. BI Publisher can merge multiple data sources into a single output document.
Oracle BI Publisher is the reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools. Use your web browser to create everything from pixel-perfect customer facing documents to interactive management reports against practically any data source. View reports online or schedule them and deliver tens of thousands of documents per hour with minimal impact to transactional systems.

Oracle BI Delivers
Oracle BI Delivers is an alert of answer side like Dashboards, reports to the particular or group of users. It delivers the report or dashboard to the email, pager, mobile, fax by the particular tile of alerts to the email of the users through wireless, web, mobile and other voice communications’. In 10 G they named as IBOTS and in 11 G named as AGENTS which are configured and submitted for execution using delivers. Scheduler is an extensible function and server to manage and schedules the jobs using job manager. Bots can execute based on a specified schedule. You can classify a starting date and time for the iBots, a repetition plan or schedule of reports and an ending date and time.

Oracle BI Server
Oracle BI Server is the core application server behind Oracle Business Intelligence. It is a requesting, query and reporting, analysis for the oracle business intelligence services and for all its other components such as dashboard, Answers, RPD, analysis, request and analytic applications. Intelligently accesses multiple physical data sources, generates SQL to query data in the data sources, and then structures the results to satisfy the requests. Oracle Bi server allows multiple data sources to query the information from the data sources for access to group of members in dashboards, web applications.

 Oracle BI Office
Oracle BI Office integrates with Oracle Business Intelligence reports by using bi office add-ins  through web browser to analyze the bi reports in excel and as well as power point. It can easily deploy, analyze, and insert the bi reports in ms office objects to ensure the bi data and its all views. Bi reports in excel and power point access the obiee objects such as views like table view, chart views, pivot table view. Upgraded Oracle Bi office resembles the new view like gauge and funnel view also. Inserting BI Charts, tables, pivot tables and all objectives and also the column properties in a secure and refreshable format.

Oracle BI Mobile
Business intelligence components can access in the mobile device without changing the required designs. New or existing Bi contents to make the business intelligence as easy to access and use by any customers. Organization can make the increase in use of business intelligence with sensitive and easy to use mobile BI application. Oracle Business Intelligence Mobile for Apple iPod & I phone is a mobile analytics app that allows you to view, analyze and act on Oracle Business Intelligence 11g content

Comments

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