Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘OBIEE 10g Concepts’ Category

Gartner Magic Quadrant for BI – 2012

Posted by Santosh Kumar Gidadmani on April 3, 2012

Gartner research published the 2012 BI Magic Quadrant in Feb and Oracle BI is leading the market as per the survey conducted by Gartner.

– Santosh

Posted in End User Analysis, Gartner BI Survey, OBIEE 10g, OBIEE 10g Concepts, OBIEE 11g, OBIEE 11g Analysis | Leave a Comment »

OBIEE 10g Architecture

Posted by Santosh Kumar Gidadmani on January 15, 2011

Most of the people in the OBIEE community are aware of the OBIEE 10g Architecture, thought to put together a consolidated view of the architecture.

In simple way, it includes the following components;

1. Clients
1.1 Answers – Web Based
Oracle BI Answers is a set of graphical tools used to build, view, and modify Oracle BI requests. The requests are queries against an organization’s data.
1.2 Interactive Dashboard – Web Based
An Oracle BI Dashboard is used to display the results of Answers requests that are embedded in the dashboard.
1.3 Administration Tool – Windows based
The Oracle BI Administration Tool is used to build the Oracle BI repository and is the focus of this

2. Oracle BI Presentation Services
Acts as middle layer in architecture in receiving and sending requests. It receives processing instructions from an Oracle BI client, retrieves the requested information from Oracle BI server, and then renders the information inside the requesting client.

3. Oracle BI Server
Is the core server behind Oracle Business Intelligence. The BI Server communicates with the BI Presentation Server via ODBC, and then connects out to the various supported data sources through ODBC, OCI, XML/A, the Essbase etc.
· Uses metadata to direct processing.
· Generates dynamic SQL to query data in the physical data sources.
· Connects natively or through ODBC to the RDBMS.

Some of the components of Oracle BI server are;
1) Intelligent Request Generator which takes the incoming queries and converts them into physical queries against the connected data source.
2) Navigator which takes the incoming query, compares it against cached requests and decides on the best results. There are some more components within the Navigator like multiple physical queries, aggregations, fragmentation etc.
3) Optimized Query Rewrite engine which handles the aggregate navigation and fragments and converts to the correct physical SQL statements.
4) Execution Engine which fires the queries to the relational, multi-dimensional, file and XML sources to fetch the data.
5) Cache Services which stores the results of previously run queries, matches incoming SQL against that used before and returns data from the cache rather than making the BI server query the underlying databases again.
6) Security Services for setting up users and groups in the RPD, filters, subject area security, links to outside LDAP servers and custom authenticators.
7) Query Governance, for placing limits on numbers of rows returned and length of query execution for users and groups.

4. Data Sources
Data sources are the physical sources where the business data is stored. They can be in any format, including transactional databases, online analytical processing databases, text files, XMLA etc. SQL is generated by Oracle BI Server against the data sources using the data source connection, information from the repository, and database-specific parameters stored in a DBFeatures.INI file.

– Santosh

Posted in 10g Architectu​re, OBIEE 10g, OBIEE 10g Concepts | Leave a Comment »

%d bloggers like this: