OBIEE 10g Server Architecture
Oracle Business Intelligence components
The Oracle Business Intelligence components consist of:
Oracle Business Intelligence Presentation
Services
The Oracle
Business Intelligence Presentation Services provides the framework and
interface for presentation of Business Intelligence data to web clients. It
maintains a Presentation Catalog service on the file system for the
customization of this presentation framework. It is a standalone process and
integrates with the Oracle Business Intelligence Presentation Services Plug-in
from which it receives web client requests. It communicates with the Oracle
Business Intelligence Server using ODBC over TCP/IP.
Oracle Business Intelligence Server
The Oracle Business Intelligence Server is
a stand-alone process that maintains the logical data model which it provides
to BI Presentation Services via ODBC. Metadata is maintained for the data model
in a local proprietary file called the repository file (rpd). On the back-end,
the BI Server connects to customer data stores via data source adaptors.
Oracle Business Intelligence Scheduler
The Oracle Business Intelligence Scheduler
is an extensible scheduling application for scheduling reports to be delivered
to users at specified times. It is the engine behind the Oracle Business
Intelligence Delivers feature.
Oracle Business Intelligence Publisher
The Oracle Business Intelligence Publisher
generates highly-formatted, pixel-perfect enterprise reports.
Oracle Business Intelligence Java Host
The Oracle Business Intelligence Javahost
provides services to BI Presentation Services for Charts, Gauges and PDFs. The
services are provided based on request-response model.
Oracle Business Intelligence Presentation Services Plug-in
The Oracle Business Intelligence
Presentation Services Plug-in is the entry point for web client requests to BI
Presentation Services.
Oracle Business Intelligence for Microsoft Office
The Oracle BI Presentation Services, Oracle
BI Client, and Oracle BI Server components can be installed to run on separate
machines.
Oracle BI Disconnected Analytics
Full analytical functionality for the
mobile professionals.
Oracle BI Briefing Books
Snapshots of dashboard pages to view and
share in offline mode.
Oracle Business Intelligence Architecture
Overview
Architecture Oracle BI Web
Key
Components
Ø Oracle
Interactive Dashboards
Ø Oracle
Answers
Ø User
Profiling, Security and Session Management
Ø Cache
Services & Connection Management
Ø SOAP
Web Services, XML and URL Interface
Ø Web
Catalog Service
Ø XML
Framework
Oracle Interactive BI Dashboards
Ø Oracle
BI Intelligence Dashboards provides any knowledge worker with intuitive, interactive
access to information that is actionable and dynamically personalized based on
the individual's role and identity.
Ø In
the Oracle BI Intelligence Dashboards environment, the end user is working with
live reports, prompts, charts, tables, pivot tables, graphics, and tickers in a
pure Web architecture.
Ø The
user has full capability for drilling, navigating, modifying, and interacting
with these results.
Ø Content
can combine multiple subject areas in a single Dashboard Supply Chain, Human
Resources, Financials
Ø Oracle
BI Intelligence Dashboards can also aggregate content from a wide variety of other
sources, including the Internet, shared file servers, and document
repositories.
Oracle Answers
Ø Oracle
BI Answers provides true end user ad hoc capabilities in a pure Web
architecture.
Ø Users
interact with a logical view of the information
- completely
hidden from data structure complexity while simultaneously preventing runaway
queries
Ø Can
easily create charts, pivot tables, reports, and visually appealing dashboards.
- Fully
interactive and drillable
- Can
be saved, shared, modified, formatted, or embedded in Dashboards
Ø Feature
rich formatting options for columns
- Style
- Color
- Sorting
- Totaling
- Conditional
formatting
- Custom
labeling
Ø Infrastructure
that controls the security aspects when a user is logged into Oracle BI Web
Ø Oracle
BI Web allocates the reports, dashboards, prompts, iBots etc. accessible to a logged
in User.
Ø It
also ensures the metadata is read for accessible Subject Areas for ad-hoc
analysis and constrains the user to only refer to that content
Ø Any
report/dashboard created through Oracle BI Web can be secured to specific Web Groups,
Users etc.
Ø Administrator
is a special user which has access to all the content.
Ø Session
Management involves ensuring that the session context is maintained when navigating
between OBIEE Dashboard pages (with few setups). It also involves managing and
maintaining sessions when interacting with external applications like EBS.
Cache Services & Connection Management
Ø Oracle
BIEE is built-in with high performance cache services feature. It is not
memory-based, it is file-based cache
Ø Cache
Service is turned on or off based on an NQSConfig.INI setting
Ø Cache
Services are user-specific. If a same query is executed over and over again
within a "valid" period of Cache, Oracle BI Server picks up data from
Cache instead of executing it against the Database.
Ø Not
all SQLs are cached. Some queries which use current timestamp etc. are skipped
from cached. Connection Management involves verifying and validating a user
logged into the Oracle BI Web. Several authentication methods are supported by
Oracle BI Web including LDAP Authentication, External Table Authentication, OBIEE
User Authentication, EBS Authentication and so on.
Miscellaneous Services
Ø OBI Web Services is an application programming interface (API) that implements SOAP (Simplified Object Access Protocol). It helps in achieving
- Extract Results from OBI Presentation Services and deliver them to external application
- Perform OBI Presentation Catalog Functions
- Execute OBI Alerts (also called iBots)!
Ø OBI Web is compatible JSR 168 specification and can be integrated to plug into Portal Applications.
Ø OBI Web Catalog Service involves maintaining and managing the metadata involving the reports and dashboards. The Catalog Manager helps in maintaining BI Content without complicating the task.
Ø Oracle BI is fully compatible to XML Framework and logical queries are communicated between the Oracle BI components in XML.
Architecture BI
Server
Key Components of BI Server
Ø Simplified
logical model
Ø Load
Balancer
Ø Session
Management
Ø Intelligence
Request Generation
Ø Query
Governance
Ø Security
Services
Ø System /
Performance Monitoring
Ø Metadata
Interchange
Simplified Logical Model
Ø Oracle
BI Server deploys a Common Enterprise Information (CEI) Model on top of a
variety of data sources irrespective of data shape, data size or technology
Ø Logical
Business Model ensures that Oracle BI Server looks like a database to a 3rd
party tool. It shows a simplified "business view" of information
available to all BI tools.
Ø This
provides powerful calculation, computation capabilities via the CEI Model to
other tools and all of them are consistently available from a single layer,
"define once, deploy everywhere" concept.
Ø Complex
Calculations and Time Series Analysis can be as easy as pulling a column to the
request. End User need not perform these calculations.
Ø Data
is SEPARATE from Model. Same model can source from Database A today and
Database B tomorrow.
Ø High
degree of flexibility allows additions/modifications performed at a single
place without breaking thousands of reports.
System Services
Ø Load
Balancer, Session Management, Query Governance and Security Services are
together coined as "System Services"
Ø Native
Load Balancing ensures the performance of the BI Application is never
compromised. Clustering helps in adding stacks as needed in a share nothing
clustered environment
Ø Session
Management and Query Governance ensures query throttling (restricting users
from sending certain queries) and is done via connection pools and
authorization
Ø Security
Services involves integrating with OID (Oracle Internet Directory), LDAP, ADSI
(Active Directory) etc. and allows sophisticated data driven personalization
mechanisms
Ø All
existing security models (say EBS Security) can be leveraged for authorizing
the content available to the end-user.
Intelligence Request Generation
 |
Intelligence Request Generation
Ø Logical Request Generation involves creating a Logical SQL with the selected columns of a report
Ø For example, A User has selected Supplier, Purchase Amount, Receipt Amount columns from Purchasing Subject Area
Ø A Logical SQL is formed by Oracle BI Web and passed on to Oracle BI Server.
It looks as:
SELECT "Dim_Supplier"."Supplier_Name",
"Fact-Purchases"."Purchase_Amount","Fact-
Purchases"."Receipt Amount" FROM
Procurement
|
 |
Intelligence Request Generation
Ø Cache
Services will check if this request fired by the user can be fulfilled via a
prior request using Server Cache
Ø A
huge benefit of this is the run-time performance for many users as the cache is
an on-demand, intelligent shareable and secure cache that can support
aggregates, subsets and derivations.
Ø Cache
is a run-time concept. However, it can also be seeded such that the reports
turn out much faster in the morning
Ø Cache
can then be purged on a time basis
|
 |
Intelligence Request Generation
Ø If
the cache cannot satisfy the request,
the request is "intelligently
process" the
request.
Ø Navigator
optimizes the query execution,
using several techniques inbuilt into the
Oracle
BI Server, like Fragmentation
Optimization, Multi-Pass/Sub-Request
Logic etc.
Ø Aggregate
Navigator ensures the aggregations (either persisted within BI)
or in the
Database are identified
Ø A
Physical Query is formed by the Oracle BI Server to hit the Database.
|
 |
Intelligence Request Generation
Ø Navigator
identified the key sources to utilize which can satisfy the query fired by the
user in a most optimal way and includes security credentials along the way.
Ø In
all, it compares
- How
Complex is the Request?
- What
Data Sources Need to be put into play?
- What
is the best way to satisfy the request and if aggregates can be used? |
 |
Intelligence Request Generation
Ø Multi-Pass/Sub-Request
Logic is used in case the analysis requires a sophisticated analysis such as an
OLAP calculation.
Ø OBIEE
with it's latest integration to OLAP technologies including Hyperion Essbase, Analytical Workspaces etc. the multi-pass helps in ensuring the optimal way of extracting a cube output or a OLAP column value
have to be executed first before executing the main one, all of these are taken care of, in this step. |
 |
Intelligence Request Generation
Ø Multi-Pass/Sub-Request
Logic is used in case the analysis requires a sophisticated analysis such as an
OLAP calculation.
Ø OBIEE
with it's latest integration to OLAP technologies including Hyperion Essbase,
Analytical Workspaces etc. the multi-pass helps in ensuring the optimal way of
extracting a cube output or a OLAP column value
Ø It
could be possible that sub-requests have to be executed first before executing the main one, all of these are taken care of, in this step. |
 |
Intelligence Request Generation
Ø When
a source is spread across sources/partitions/silos of data, they are
Fragmented. For eg: Purchase Amount could be in one silos and Receipt Amount
could be in another.
Ø Fragmentation
Optimization Engine is a middleware that sits between Requesting Client and the
Database. It transforms base SQL into Fragment Aware SQL.
Ø Generally
large data is fragmented across dimension like Time. There would be sources
like Y2002_Purchases, Y2003_Purchases etc.
|
 |
Intelligence Request Generation
Ø Aggregate
Navigator ensures that if the measure can be sourced from an aggregated column
instead of adding up the metric from detail level values, it ensures the
aggregation is used.
Ø Aggregate
include Relational Aggregate sources like Materialized Views, OLAP Aggregates
like Hyperion Essbase Cubes, Analytical Workspaces or an XMLA Cube etc.
|
  |
Intelligence Request Generation
Ø Optimized
Query Rewrites ensures that the logical sql is written into an efficient and
highly scalable Physical SQL that can be executed against the Database.
Ø Server
provides a consistent functionality irrespective of the underlying data source.
It could be derived from Oracle, SQL Server or any other data source.
Ø It
also ensures it puts the supporting query, like RANK, AVG etc. in appropriate
syntax and sends the query to be executed.
Intelligence Request Generation
Ø Performance
Monitoring using efficient Query Logs and Log Level ensures that Oracle BI
Server tracks the query executed against the database.
Ø Execution
Plans, Time taken by the DB
to execute the query are all recorded
by the BI
Server for performance tuning exercises
Ø Metadata
Interchange involves exposing the metadata to be accessible through API
(Application Program Interface) to be able to read from different sources like
BI Publisher etc.
|
Oracle BI Administration
Ø MS
Windows application for managing BI Server
Ø Creates
and Manages the Common Enterprise Information Model (Physical, Logical and
Presentation Layer)!
Ø Manage
several other aspects including
- Security
- Scheduler
- Jobs
- Marketing
- Sessions
- Cache
Ø Utilities
and Tools
Ø Connect
to BI Server via ODBC DSN
Oracle Delivers Server
Ø Scheduling
and Distribution of Requests
- Uses
iBots ("Intelligent Bots")!
- Integration
through JAVA with BPEL (Business Process Execution Language)!
Ø iBot
Chaining (Calling iBots from another iBot)!
Ø Permits
Alerts, through execution of Answers reports
- If
Report returns rows, Alert is Triggered
- Alert
can appear on a Dashboard, sent via Email, SMS, Cellphone etc
- Can
trigger narrative and conditionally appearing reports
Oracle BI Publisher
Ø Multiple
Output Document Formats
Ø Report
Layouts developed and maintained using desktop applications
Ø Reduced
Cost by Eliminating 3rd party tools
Ø Based
on Oracle XML Publisher
Ø Separate
application, integrated with Oracle BI Presentation Server
Ø Initially
usernames and passwords integrated
Ø Separately
Administered
Ø Provides
high fidelity layout, positioning of data, charts etc.
Ø Multiple
Data Sources
Ø OBIEE
Metadata Layer
Ø Oracle
BI Answers Report
Ø Any
Source accessible via SQL
Ø XML
Over HTTP
Ø Separates
Data from Layout and integrates exporting the data to Microsoft Office
Products, Adobe PDF, XSL etc
Oracle BI Publisher
One Solution for
all Document Needs
- Purchase
Orders
- Labels/Bar
Codes
- Collateral
- Employee
Forms
- Government
Forms
- Order
Forms
- Invoices
- Operational
Resources
- Correspondence
- Financial
Statements
- Checks
Oracle BI Disconnected
Analytics
Ø Full
featured Disconnected Client. Download Oracle BI Disconnected Analytics
Application, and be able to view the dashboards and queries outside the network
which hosts the BI Server
Ø Oracle
BI Disconnected Analytics Manager is a utility program to synchronize, start
and delete a disconnected application on a disconnected machine
Ø SQL
Script files store the commands to create and populate tables and indexes in
the SQL Anywhere database on a disconnected machine
Ø Local
Databases store the data to be shown in Browser
Oracle BI Briefing Books
Ø Content
of BI Dashboard can be saved as a Briefing Book readable by anyone having
Oracle BI Briefing Book Reader
Ø An
electronic Briefing Book which is a collection of most important dashboards
Ø Extremely
Small
Ø Can
be delivered daily for enterprise collaboration
Ø Bottom
of every dashboard page has a link to add to the "Briefing Book".
Ø It
builds an electronic briefing book that can be carried along
Ø Share
them online and read with others
Ø Can
be saved locally and refreshed by the click of a button
No comments:
Post a Comment