9 Oracle Business Intelligence

This chapter covers licensing for Oracle Business Intelligence products. It contains the following sections:

9.1 Oracle Business Intelligence Enterprise Edition

Oracle Business Intelligence Enterprise Edition licensed programs are described in the following sections:

9.1.1 Oracle Business Intelligence Suite Enterprise Edition Plus

Oracle Business Intelligence Suite Enterprise Edition Plus is a comprehensive suite of enterprise BI products, delivering the full range of BI capabilities including:

  • Interactive dashboards and visualizations

  • Proactive intelligence and alerts

  • Enterprise reporting and publishing

  • Ad hoc analysis and dashboard construction

  • Action Framework, to initiate business processes in context of insights

In addition to providing the full range of BI functionality, Oracle Business Intelligence Suite Enterprise Edition Plus is based on a proven, modern service-oriented architecture that delivers true next-generation BI capabilities.

9.1.1.1 Included Products and Components

Table 9-1 lists and summarizes the products and components included in the license for Oracle Business Intelligence Suite Enterprise Edition Plus.

Table 9-1 Oracle Business Intelligence Suite Enterprise Edition Plus Products and Components

Product Description

Oracle Business Intelligence Server Enterprise Edition

Common enterprise business model and abstraction layer.

Oracle Business Intelligence Answers

Ad-hoc query and reporting.

Oracle Business Intelligence Interactive Dashboards

Highly interactive dashboards for accessing business intelligence and applications content.

Oracle Business Intelligence Reporting and Publishing

High quality, high volume, production reporting. (See Section 9.2, "Oracle Business Intelligence Publisher.")

Oracle Business Intelligence Delivers

Proactive business activity monitoring and alerting.

Oracle Business Intelligence for Microsoft Office (Office Plug-in)

Integrate and leverage Oracle Business Intelligence content in Excel and PowerPoint.

Oracle Business Intelligence Publisher

Enterprise reporting and distribution of highly formatted reports.

Oracle Business Intelligence Server Administrator

Powerful data modeling interface for administrators.

Restriction: Only one Named User Plus license is included with Oracle Business Intelligence Suite Enterprise Edition Plus. The single Named User Plus license is intended to provide the minimum functionality to install, configure and administer an Oracle BI installation. There is not one Named User Plus license of Oracle Business Intelligence Administrator per Named User Plus license of Oracle Business Intelligence Suite Enterprise Edition, nor is there one Named User Plus license of Oracle Business Intelligence Administrator per Processor license of Oracle Business Intelligence Suite Enterprise Edition. Additional licenses of Oracle Business Intelligence Administrator may be procured separately to enable additional administrators to manage Oracle BI Suite EE.

Oracle Hyperion Interactive Reporting

Intuitive and highly interactive ad-hoc reporting.

Includes the following:

  • Hyperion Foundation Services (including SmartView for Office Toolkit)

  • Hyperion Impact Management Services

Oracle Hyperion SQR Production Reporting

High volume, presentation-quality formatted report generation.

Includes the following:

  • Hyperion Foundation Services (including SmartView for Office Toolkit)

  • SAP & SAP BW Adapter for Production Reporting

Oracle Hyperion Financial Reporting

Formatted, book-quality financial and management reporting.

Includes the following:

  • Hyperion Foundation Services (including SmartView for Office Toolkit)

  • SAP & SAP BW Adapter for Financial Reporting

Oracle Hyperion Web Analysis

Web-based online analytical processing (OLAP) analysis, presentation, and reporting.

Includes the following:

  • Hyperion Foundation Services (including SmartView for Office Toolkit)

  • SAP & SAP BW Adapter for Web Analysis

Oracle Containers for Java EE (OC4J)

Provides a Java Enterprise Edition (Java EE) container for running the Java components of Oracle Business Intelligence.

Restrictions: Restricted use license

WebLogic Server Standard Edition (for use with OBIEE)

Provides a Java Enterprise Edition (Java EE) container for running Java components of Oracle Business Intelligence.

Restrictions: Restricted use license to use for Oracle Business Intelligence Server Enterprise Edition and the components that run on it.

Note: If clustering is desired, the customer must purchase or supply WebLogic Server Enterprise Edition (or alternative Java EE server when certified for Oracle BI 11g)

WebLogic Server Standard Edition (for use with Hyperion Reporting Products)

Provides a Java Enterprise Edition (Java EE) container for running Java components of Oracle Hyperion reporting applications.

Restrictions: Restricted use license to host Java EE or Java application logic that is distributed as part of Oracle Hyperion Interactive Reporting, Oracle Hyperion SQR Production Reporting, Oracle Hyperion Financial Reporting, and Oracle Hyperion Web Analysis.

Oracle Internet Directory

Restrictions: Restricted use of Oracle Internet Directory (restricted to storing Oracle Hyperion Interactive Reporting, Oracle Hyperion SQR Production Reporting, Oracle Hyperion Financial Reporting, and Oracle Hyperion Web Analysis user information only).


9.1.2 Oracle Business Intelligence Server Enterprise Edition

Oracle Business Intelligence Server Enterprise Edition is a true BI server that is designed to be highly scalable, optimizing concurrency and parallelism to make the value of BI applications available to the largest possible audience. It provides centralized data access and calculation, essentially creating a large pipe through which anyone can consume any information in any form anywhere in the enterprise. The Oracle Business Intelligence Server is central to all of the business processes that consume information, including dashboards, ad hoc queries, intelligent interaction capabilities, enterprise and production reporting, financial reporting, OLAP analysis, data mining, and other Web service-based applications (Java EE and .NET). All of these applications require rich access to broad sets of data across the enterprise, and they all require a sophisticated calculation and aggregation infrastructure that the platform provides to deliver value.

9.1.2.1 Included Products and Components

Table 9-2 summarizes the products and components included in the license for Oracle Business Intelligence Server Enterprise Edition.

Table 9-2 Oracle Business Intelligence Server Enterprise Edition Products and Components

Product Description

Oracle Business Intelligence Server Enterprise Edition

Common enterprise business model and abstraction layer.

Oracle Containers for Java EE (OC4J)

Provides a Java Enterprise Edition (Java EE) container for running the Java components of Oracle Business Intelligence.

Restrictions: Restricted use license

WebLogic Server Standard Edition

Provides a Java Enterprise Edition (Java EE) container for running Java components of Oracle Business Intelligence.

Restrictions: Restricted use license to use for Oracle Business Intelligence Server Enterprise Edition only.

Note: If clustering is desired, customer must purchase or supply WebLogic Server Enterprise Edition (or alternative Java EE server when certified for Oracle BI 11g)

Oracle Entitlements Server Basic

Provides role based access control based on authorization policies.


9.1.2.2 Options

Table 9-3 summarizes the options available for the Oracle Business Intelligence Server Enterprise Edition license.

Table 9-3 Oracle Business Intelligence Server Enterprise Edition Options

Option Description

Oracle Business Intelligence Interactive Dashboards

Highly interactive dashboards for accessing business intelligence and applications content.Foot 1 

Oracle Business Intelligence Delivers

Proactive business activity monitoring and alerting.Footref 1

Oracle Business Intelligence Answers

Ad-hoc query and reporting.Footref 1

Oracle Business Intelligence for Microsoft Office (Office Plug-in)

Integrate and leverage BI content in Excel and PowerPoint.Footref 1

Oracle Reporting and Publishing (Oracle BI Publisher)

High quality production reporting.Footref 1

Include the following:

  • Oracle Business Intelligence Publisher

  • Oracle Hyperion SQR Production Reporting


Footnote 1 The number of options licenses must match the number of licenses of the associated Oracle Business Intelligence Server Enterprise Edition.

9.1.2.3 Additional Usage Notes and Restrictions

Business Intelligence Server and its options restricted to testing and debugging the deployment of applications developed with Oracle Business Intelligence Server Administrator.

9.1.3 Oracle Business Intelligence Suite Enterprise Edition Plus Upgrade Only

This license upgrades each Oracle Business Intelligence Suite Enterprise Edition license to Oracle Business Intelligence Suite Enterprise Edition Plus.

9.1.3.1 Included Products and Components

Table 9-4 summarizes the additional products added when the license for Oracle Business Intelligence Suite Enterprise Edition is upgraded to Oracle Business Intelligence Suite Enterprise Edition Plus.

Table 9-4 Oracle Business Intelligence Suite Enterprise Edition Plus Upgrade Only Products and Components

Product Description Included Products and Components

Hyperion Interactive Reporting

Intuitive and highly interactive ad-hoc reporting.

  • Hyperion Foundation Services (including SmartView for Office Toolkit)

  • Hyperion Impact Management Services

Hyperion SQR Production Reporting

High volume, presentation-quality formatted report generation.

  • Hyperion Foundation Services (including SmartView for Office Toolkit)

  • SAP & SAP BW Adapter for Production Reporting

Hyperion Financial Reporting

Formatted, book-quality financial and management reporting.

  • Hyperion Foundation Services (including SmartView for Office Toolkit)

  • SAP & SAP BW Adapter for Financial Reporting

Hyperion Web Analysis

Web-based online analytical processing (OLAP) analysis, presentation, and reporting.

  • Hyperion Foundation Services (including SmartView for Office Toolkit)

  • SAP & SAP BW Adapter for Web Analysis

WebLogic Server Standard Edition

Provides a Java Enterprise Edition (Java EE) container for running Java components of Oracle Hyperion reporting applications.

Restrictions: Restricted use license to host Java EE or Java application logic that is distributed as part of Oracle Hyperion Interactive Reporting, Oracle Hyperion SQR Production Reporting, Oracle Hyperion Financial Reporting, and Oracle Hyperion Web Analysis.

 

Oracle Internet Directory

Restrictions: Restricted use of Oracle Internet Directory (restricted to storing Oracle Hyperion Interactive Reporting, Oracle Hyperion SQR Production Reporting, Oracle Hyperion Financial Reporting, and Oracle Hyperion Web Analysis user information only).

 

9.1.3.2 Additional Usage Notes and Restrictions

Existing Oracle Business Intelligence Suite Enterprise Edition customers may not license incremental users or processors of Oracle Business Intelligence Suite, but rather must purchase Oracle Business Intelligence Suite Enterprise Edition Plus users or processors.

9.2 Oracle Business Intelligence Publisher

Oracle Business Intelligence Publisher licensed programs are described in the following topics:

9.2.1 Oracle Business Intelligence Publisher (Standalone)

Oracle BI Publisher is a reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools. Use your web browser or familiar desktop tools 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.

9.2.1.1 Included Products and Components

Table 9-5 summarizes the products and components included in the license for Oracle Business Intelligence Publisher.

Table 9-5 Oracle Business Intelligence Publisher Products and Components

Product Description

Oracle Business Intelligence Publisher

Oracle Business Intelligence Publisher provides a single reporting environment to author, manage, and deliver all of your reports and business documents. Data models can be built against practically any data source from database to web service to file and more. Utilizing a set of familiar desktop tools, users can create and maintain their own report layouts based on data from these diverse sources. Reports can then be viewed on line or scheduled for delivery to a wide range of destinations.

Oracle Containers for Java EE (OC4J)

Provides a Java Enterprise Edition container for running the Java components of Oracle Business Intelligence.

Restrictions:

  • Restricted Use license

WebLogic Server Standard Edition

Java EE Web Application Server

Restricted to use for Business Intelligence Publisher only.

Note: If clustering is desired, customer must purchase or supply WebLogic Server Enterprise Edition

Oracle Entitlements Server Basic

Provides role based access control based on authorization policies.


9.2.2 Oracle Business Intelligence Publisher within Oracle Business Intelligence Enterprise Edition and Oracle Business Intelligence Standard Edition One

Oracle Business Intelligence Publisher is included as the following:

When included with Oracle Business Intelligence Suite Enterprise Edition, Oracle Business Intelligence Standard Edition One, or as an option to Oracle Business Intelligence Server Enterprise Edition, the Oracle Business Intelligence Publisher license is a full use license. The license has no additional restrictions beyond those that are already in place for each of those products or options. For more information, see:

9.2.3 Oracle Business Intelligence Publisher within Oracle E-Business Suite and other Applications

For all Oracle E-Business Suite Applications:

  • Restricted Use: Business Intelligence Publisher to publish and/or view either or both the following:

    • Shipped Oracle Business Intelligence Publisher reports. Layout changes are allowed.

    • Shipped or newly created Oracle Business Intelligence Publisher reports that are modified to access data from the existing Oracle Applications schema that has not been customized.

  • A full use Business Intelligence Publisher license is required if any shipped, modified or newly created Business Intelligence Publisher report accesses data from one of the following:

    • A non-Oracle Applications data source

    • A new schema within the Oracle Applications that is not shipped by Oracle

    • A modified Oracle Applications schema (for example, by adding columns to an existing table)

For all other Oracle Applications that include Business Intelligence Publisher, see that product's documentation for Business Intelligence Publisher license restrictions. In general, if any of the following conditions exist, a full use Business Intelligence Publisher license is required:

  • BI Publisher accesses any data outside the Oracle Application for which the restricted BI Publisher license is supplied.

  • Any modification is made to the Oracle Applications (for example, by adding columns to an existing table).

Many Applications have tighter restrictions on their restricted use license of Business Intelligence Publisher. Please consult the Price List or Price List Supplement for the associated Application to understand the restricted use license terms.

9.3 Oracle Business Intelligence Standard Edition One

Oracle Business Intelligence Standard Edition One is a comprehensive business intelligence BI offering designed for midsize enterprises or departments in larger organizations. It includes interactive dashboards, highly formatted reporting, ad hoc query and analysis, Extract-Transform-Load (ETL), data modeling, server administration, and Oracle Database Standard Edition One—all in a single package.

Oracle Business Intelligence Standard Edition One has all the components that you need to build your mid-size or departmental BI solution. The BI components of Oracle Business Intelligence Standard Edition One are the same powerful components that are in Oracle Business Intelligence Enterprise Edition, protecting your investment as your usage requirements grow.

Oracle Business Intelligence Standard Edition One licensed programs are described in the following topics:

9.3.1 Included Products and Components

Table 9-6 summarizes the products and components included in the license for Oracle Business Intelligence Standard Edition One.

Table 9-6 Oracle Business Intelligence Standard Edition One Products and Components

Product Description

Oracle Database Standard Edition One

Leading relational database for business intelligence and data warehousing.

Oracle Warehouse Builder (core ETL)

Oracle Warehouse Builder is an ETL tool that provides an integrated solution for designing and deploying enterprise data warehouses, data marts, and business intelligence applications.

Oracle Business Intelligence Server Enterprise Edition

Common enterprise business model and abstraction layer.

Oracle Business Intelligence Answers

Ad-hoc query and reporting.

Oracle Business Intelligence Interactive Dashboards

Highly interactive dashboards for accessing business intelligence and applications content.

Oracle Business Intelligence Server Administrator

Powerful data modeling interface for administrators.

Restrictions:

  • One Named User Plus license

Oracle Business Intelligence Publisher

Enterprise reporting and distribution of highly formatted reports.


9.3.2 Additional Usage Notes and Restrictions

The following usage notes and restrictions apply:

  • You can install Oracle Business Intelligence Standard Edition One on a single machine with up to two sockets.

  • You can license Oracle Business Intelligence Standard Edition One for a minimum of 5 Named User Plus licenses and a maximum of 50 Named User Plus licenses.

  • You can use Oracle Warehouse Builder Core ETL to pull data from any number of data sources. However, you must use only the included Oracle Database Standard Edition One as the target database.

  • The data sources for Oracle Business Intelligence Server and Business Intelligence Publisher are limited to:

    • The included Oracle Database Standard Edition One

    • One other database

    • Any number of flat file sources (for example, CSV, XLS)

  • Table 9-6 shows the Oracle Business Intelligence Enterprise Edition components covered by the Oracle Business Intelligence Standard Edition One license, namely:

    • Oracle Business Intelligence Server Enterprise Edition

    • Oracle Business Intelligence Answers

    • Oracle Business Intelligence Interactive Dashboards

    • Oracle Business Intelligence Server Administrator

    • Oracle Business Intelligence Publisher

    Note the Oracle Business Intelligence Standard Edition One installation installs all of the Oracle Business Intelligence Enterprise Edition components, not just those listed above. To use the additional Oracle Business Intelligence Enterprise Edition components (for example, Oracle Business Intelligence Delivers, and Office Plug-in), you must upgrade to an Oracle Business Intelligence Enterprise Edition license.

  • Oracle Business Intelligence Standard Edition One is not supported to run Oracle Business Intelligence Applications.

9.4 Oracle Real-Time Decisions

Oracle Real-Time Decisions (Oracle RTD) enables you to develop adaptive enterprise software solutions. These adaptive solutions continuously learn from business process transactions while they execute and optimize each transaction, in real time, by way of rules and predictive models.

Table 9-7 summarizes the products and components included in the license for Oracle RTD.

Table 9-7 Oracle Real-Time Decisions Products and Components

Product Description

Real-Time Decision Server

The Real-Time Decision Server is a Java EE application that executes Inline Services. Inline Services describe the necessary business logic for the purpose of business process optimization.

Includes the following:

  • Decision Connector for Call Center

  • Decision Connector for IVR

  • Decision Connector for Web

Decision Center

Decision Center is a Web-based application that allows the business analyst to monitor and optimize deployed Inline Services. From Decision Center, you can view statistics gathered from the models and fine-tune campaigns such as cross-selling, as well as adjust how decisions are made.

Decision Studio

Decision Studio is an Eclipse-based graphical development tool for application developers to define RTD application logic and to configure Inline Services.

Load Generator

The Load Generator is used in three situations:

  • To characterize the performance of the system under load, measuring response time and making sure the whole system, including back-end data feeds, can cope with the expected load.

  • To initialize the learnings and statistics with some significant data for demonstration purposes.

  • To process off-line batch sources—for example, when exploring previously collected data at the initial stages of a project.

Oracle Entitlements Server Basic

Provides role based access control based on authorization policies.


9.5 Oracle's Hyperion Business Intelligence Technology

Table 9-8 lists the products, components, and restrictions included in the Oracle's Hyperion Business Intelligence Technology licensed programs.

Table 9-8 Hyperion Business Intelligence Technology: Included Products and Components

Product Description Included Products and Components

Oracle Essbase Plus

Essbase Plus is the leading online analytical processing (OLAP) server available today. Essbase Plus provides an environment for rapidly developing custom analytic and enterprise performance management (EPM) applications that is managed by business users. Engineered for scalability, security, and rapid-response, Essbase Plus brings analytics to the business user and enables the business to quickly model complex business scenarios. Through an intuitive interface, business users can manipulate large data sets to model complex scenarios, forecast outcomes, and perform what-if analyses to identify trends and optimize business results. Together with other modules, Essbase Plus offers broad support for demanding business intelligence analytics requirements.Foot 1 ,Foot 2 

  • Hyperion Foundation Services (including Smart View for Office Toolkit)

  • Essbase Analytics

  • Enterprise Analytics

  • High Availability Services

  • Application Builder.NET

  • Application Builder Java EE

  • Spreadsheet Toolkit

  • Data Integration Management Adapters for Essbase Plus

Hyperion Interactive Reporting

Hyperion Interactive Reporting provides executives, business users, and analysts with intuitive user-directed relational query capabilities. From interactive dashboards in a readily available context, to complex data modeling for fully ad hoc access to source data, Hyperion Interactive Reporting can pull together data from disparate sources to produce easy to use charts, pivot tables, highly formatted reports, and more.Footref 1,Footref 2

  • Hyperion Foundation Services (including Smart View for Office Toolkit)

  • Hyperion Impact Management Services

Oracle Hyperion SQR Production Reporting

Hyperion SQR Production Reporting generates high volume, presentation-quality and pixel-perfect formatted reports with unparalleled performance regardless of the type and number of disparate sources. Hyperion SQR Production Reporting delivers its comprehensive enterprise reporting capabilities through a graphical report creation environment and a powerful 4GL reporting language (called SQR) for advanced reporting and data processing.Footref 1,Footref 2

  • Hyperion Foundation Services (including Smart View for Office Toolkit)

  • SAP & SAP BW Adapter for Production Reporting

Oracle Hyperion Financial Reporting

Hyperion Financial Reporting enables book-quality financial management and reporting targeted at meeting the unique requirements of the Finance department or any functional area that requires very highly formatted multidimensional reporting.Footref 1,Footref 2

  • Hyperion Foundation Services.Footref 1 (including Smart View for Office Toolkit)

  • SAP BW Adapter for Financial Reporting

Hyperion Web Analysis

Hyperion Web Analysis delivers powerful, intuitive, Web-based interactive analytics to all corners of the enterprise. A highly graphical and easy-to-use interactive interface, it enables users to view their data in a way that makes sense to them. Hyperion Web Analysis facilitates access to packaged application and multidimensional data sources. It supports drill-through to a wide variety of relational data sources, including drill-through to URL.Footref 1,Footref 2

  • Hyperion Foundation Services (including Smart View for Office Toolkit)

  • SAP BW Adapter for Web Analysis

WebLogic Server Standard Edition

Provides a Java Enterprise Edition (Java EE) container for running Java components of Oracle Hyperion reporting applications.

Restrictions: Restricted use license to host Java EE or Java application logic that is distributed as part of Oracle Essbase, Oracle Hyperion Interactive Reporting, Oracle Hyperion SQR Production Reporting, Oracle Hyperion Financial Reporting, and Oracle Hyperion Web Analysis.

 

Oracle Internet Directory

Restrictions: Restricted use of Oracle Internet Directory (restricted to storing Oracle Essbase, Oracle Hyperion Interactive Reporting, Oracle Hyperion SQR Production Reporting, Oracle Hyperion Financial Reporting, and Oracle Hyperion Web Analysis user information only).

 

Footnote 1 Customers with legacy Hyperion pre-System 9 product licenses must pay a Foundation Enablement migration fee to migrate to the corresponding Oracle Hyperion licenses, which include Hyperion Foundation Services.

Footnote 2 The minimums for all products are 25 Named User Plus licenses or 4 Processor licenses.

9.6 Oracle Scorecard and Strategy Management

Oracle Scorecard and Strategy Management enables you to map organization strategy to goals and monitor via Key Performance Indicators. When separately licensed, it works as an integrated component of Oracle BI Server and the presentation services of Oracle BI Enterprise Edition.

The restricted use license of WebLogic Server Standard Edition that comes with Oracle BI Server Enterprise Edition may be used with Oracle Scorecard and Strategy Management.

9.7 Oracle Business Intelligence Mobile

Oracle Business Intelligence Mobile extends Oracle BI Enterprise Edition capabilities to mobile clients such as Apple iPhone and iPad.

9.8 Oracle Disconnected Analytics

Oracle Disconnected Analytics enables the Oracle BI Enterprise Edition capabilities and user experience on a disconnected laptop. It includes data synchronization capabilities that can be integrated with Siebel CRM.

Disconnected Analytics is only available with Oracle BI 10g and is not available with Oracle BI 11g.

9.9 Oracle Business Intelligence Administrator

Oracle Business Intelligence Administrator provides a powerful data modeling interface for administrators and developers.

One Named User Plus license is included with Oracle Business Intelligence Server Enterprise Edition, Oracle Business Intelligence Suite Enterprise Edition Plus and Oracle BI Foundation Suite. The single Named User Plus license is intended to provide the minimum functionality to configure and administer metadata for an Oracle BI installation. There is not one Named User Plus license of Oracle Business Intelligence Administrator per Named User Plus license of Oracle Business Intelligence Suite Enterprise Edition, nor is there one Named User Plus license of Oracle Business Intelligence Administrator per Processor license of Oracle Business Intelligence Suite Enterprise Edition.

Oracle Business Intelligence Administrator allows organizations to purchase additional licenses of Oracle Business Intelligence Administrator to enable additional administrators to manage Oracle BI Suite EE.

9.10 Oracle Business Intelligence Data Integration Products

Oracle Business Intelligence Data Integration products are licensed together with Oracle BI technology for the exclusive use of Oracle BI technology and Oracle BI Applications.

Table 9-9 Oracle Business Intelligence Data Integration Products

Product Description

Oracle Data Integrator

A comprehensive data integration platform that covers all data integration requirements.Foot 1 

Restriction: This option may only be used for loading and transforming data that will be used within the Business Intelligence Suite Enterprise Edition Plus product.

Includes the following:

  • Data Integrator Enterprise Edition

  • Application Adapter for Data Integrator Enterprise Edition of customers' choosing (Quantity = 1).

Informatica OEM PowerCenter ETL Server and PowerConnect Adapters

An enterprise data integration platform for accessing, discovering, and integrating data from different business systems.Footref 1, Foot 2 

Restriction: See Footref 2.

Includes the following:

  • Informatica OEM PowerCenter ETL Server with Team-Based Development

  • Data Warehouse Business Adapter for PeopleSoft (Informatica OEM PowerConnect for PeopleSoft)

  • Data Warehouse Business Adapter for SAP (Informatica OEM PowerConnect for SAP R/3)


Footnote 1 The number of options licenses must match the number of licenses of the associated Oracle Business Intelligence Suite Enterprise Edition Plus or Oracle Business Intelligence Foundation Suite.

Footnote 2 The Informatica license is subject to the following terms and conditions: Informatica OEM PowerCenter ETL Server and PowerConnect Adapters may not be used on a standalone basis or as a standalone ETL tool. The Informatica OEM Power Center ETL Server and PowerConnect Adapters may be used with any data source provided the target(s) are: (i) the Oracle Business Intelligence applications programs (excluding Hyperion Financial Performance Management Applications), (ii) the underlying platforms on which the Oracle Business Intelligence Suite Enterprise Edition Plus program, Oracle Business Intelligence Standard Edition One or associated components run, or (iii) a staging database for any of the foregoing. Informatica OEM Power Center ETL Server and PowerConnect Adapters may also be used where the Oracle Business Intelligence applications (excluding Hyperion Financial Performance Management Applications) programs are the source and non-Oracle Business Intelligence application programs are the target, provided that users do not use Informatica OEM PowerCenter ETL Server and PowerConnect Adapters to transform the data.

9.11 Oracle Business Intelligence Foundation Suite

Oracle Business Intelligence Foundation Suite is Oracle's strategic Business Intelligence product, which combines all the necessary components to implement an Intelligent Decision Cycle to Detect, Analyze, Model and Act. Combining principally Oracle BI Enterprise Edition and Oracle Essbase, BI Foundation Suite provides best-in-class capabilities for Relational OLAP and Multi-dimensional OLAP, with an integrated suite of BI tools. Additionally, it includes legacy Hyperion reporting products to enable a smooth transition to Oracle's most strategic BI solutions.

Table 9-10 summarizes the products and components included in the license for Oracle BI Foundation Suite.

Table 9-10 Oracle Business Intelligence Foundation Suite Products and Components

Product Description

Oracle Business Intelligence Suite Enterprise Edition Plus

Oracle Business Intelligence Suite Enterprise Edition Plus is a comprehensive suite of enterprise BI products, delivering the full range of BI capabilities including:

  • Interactive dashboards and visualizations

  • Proactive intelligence and alerts

  • Enterprise reporting

  • Ad hoc analysis and dashboard construction

  • Action Framework, to initiate business processes in context of insights

Also included are Hyperion Reporting products:

  • Oracle Hyperion Interactive Reporting

  • Oracle Hyperion SQR Production Reporting

  • Oracle Hyperion Financial Reporting

  • Oracle Hyperion Web Analysis

  • Oracle Hyperion Smart View

Oracle Essbase Plus

Essbase Plus is the leading online analytical processing (OLAP) server available today. Essbase Plus provides an environment for rapidly developing custom analytic and enterprise performance management (EPM) applications that is managed by business users. Engineered for scalability, security, and rapid-response, Essbase Plus brings analytics to the business user and enables the business to quickly model complex business scenarios. Through an intuitive interface, business users can manipulate large data sets to model complex scenarios, forecast outcomes, and perform what-if analyses to identify trends and optimize business results. Together with other modules, Essbase Plus offers broad support for demanding business intelligence analytics requirements.

Oracle Scorecard and Strategy Management

Oracle Scorecard and Strategy Management enables you to map organization strategy to goals and monitor via Key Performance Indicators.

Oracle Business Intelligence Mobile

Oracle Business Intelligence Mobile extends Oracle BI Enterprise Edition capabilities to mobile clients such as Apple iPhone and iPad.

Essbase Analytic Link for Hyperion Financial Management

Provides an integration between Hyperion Financial Management and Essbase to perform a data synchronization between HFM and Essbase to facilitate time-sensitive what-if analysis during financial close cycles.


9.12 Oracle Business Intelligence Management Pack

Oracle Business Intelligence Management Pack is a comprehensive, integrated management solution in Oracle Enterprise Manager that helps you achieve high levels of performance and availability, and reduce the costs of managing your Oracle Business Intelligence Enterprise Edition applications.

The Oracle Enterprise Manager Business Intelligence Management Pack provides an integrated solution for ensuring the performance and availability of Oracle Business Intelligence Enterprise Edition (Oracle BI EE) 10g. Using the pack, you can receive proactive alerts on impending problems for the application, examine run-time statistics to troubleshoot and tune performance, compare configurations across different environments, and keep track of configuration changes to avoid configuration-related problems.

You can use the pack with other Oracle Enterprise Manager management packs and plug-ins to achieve end-to-end management of the entire application environment, including both Oracle and non-Oracle databases, operating systems, storage, and network devices.

Oracle Business Intelligence Management Pack is only supported with Oracle Business Intelligence Enterprise Edition 10g. Oracle Business Intelligence 11g includes certain Oracle Enterprise Manager functionality in the base Oracle BI product.

The minimums for this product are 25 Named User Plus licenses. The number of options licenses must match the number of licenses of the associated Business Intelligence Server Enterprise Edition. If licensing as an option to Business Intelligence Suite Enterprise Edition Plus, the number of options licenses must match the number of licenses of the associated Business Intelligence Suite Enterprise Edition Plus. If licensing by Processor, the number of licenses may not match due to variance in core factors between the time the respective programs were licensed.

9.12.1 Installation and Licensed Links

The Oracle Enterprise Manager Business Intelligence Management Pack is available from the Oracle Enterprise Manager Cloud Control installer.

For complete license details about Business Intelligence Management Pack, see "Business Intelligence Management" in Oracle Enterprise Manager Licensing Information.

9.13 Oracle Business Intelligence Standard Edition

Oracle Business Intelligence Standard Edition is a complete integrated BI solution designed to work especially well within Oracle environments. It is integrated with other key components of Oracle Database and Oracle Fusion Middleware to deliver comprehensive BI functionality. Oracle Business Intelligence Standard Edition is also included in the Oracle Internet Application Server Enterprise Edition offering.

Included product components:

  • Discoverer Plus

  • Discoverer Viewer

  • Discoverer Portlet Provider

  • Oracle Reports Services,

  • Oracle Enterprise Manager Application Server Control

  • 2 iDS Named User Plus licenses per Processor restricted to Reports Builder

  • Warehouse Builder

  • BI Beans

  • Oracle Spreadsheet Add-in

  • Discoverer Administration Edition

In order to use the Oracle Business Intelligence Standard Edition offering, you must separately license Oracle Database Standard Edition (for use with Oracle Business Intelligence Discoverer Relational) or Oracle Database Enterprise Edition and the Oracle OLAP option (for use with Oracle Business Intelligence Discoverer OLAP).In order to use the Oracle Spreadsheet Add-in, you only need to license Oracle Database Enterprise Edition with the Oracle OLAP option. You do not need to license the Oracle Business Intelligence Standard Edition offering.

9.13.1 Restricted-Use Licenses

The following restricted-use licenses are included when Oracle Business Intelligence Standard Edition is separately licensed (i.e. not as part of Oracle Application Server Enterprise Edition license).

  • Oracle Internet Developer Suite is provided for use with Oracle Reports Builder and Discoverer Administration Edition only. Two Named User Plus licenses per Processor are provided. Oracle HTTP Server and its modules are provided for running Oracle Business Intelligence applications only.

  • Oracle Advanced Security Option is included, with use limited strictly to the Oracle Java SSL Library.

  • WebLogic Server Basic is provided as the Java EE container for deployment of Oracle Business Intelligence Applications only.

  • The Oracle Database is provided for use with the Oracle Repository Creation Utility database schema for storing Discoverer metadata. Storing any other data in the Oracle Repository Creation Utility database schema requires a full use license of the Oracle Database.

9.14 Oracle Business Intelligence Discoverer Desktop

Oracle Business Intelligence Discoverer Desktop is a windows-based data access tool. It is used to view the information in company's databases. The purpose of Discoverer Desktop is to help the business professional—view the data they want from a database, analyze it to support their business decisions, and create reports to keep track of business metrics.

Discoverer Desktop can be separately licensed. It is also included with Internet Developer Suite offering.

9.15 Oracle Endeca Business Intelligence

Oracle Endeca Business Intelligence is an enterprise analytics platform for rapid, intuitive exploration and analysis of information from any combination of structured and unstructured sources. This platform enables organizations to extend their existing business analytics investments to unstructured data - such as social media, websites, content systems, files, email, database text and big data. Oracle Endeca Business Intelligence provides visibility into any source and more importantly, allows their analysis alongside traditional business intelligence source systems.

Table 9-11 summarizes the products and components included in Oracle Endeca Business Intelligence.

Table 9-11 Oracle Endeca Business Intelligence Products and Components

Oracle Endeca Information Discovery Studio

This highly-interactive, component-based environment is used for quickly and iteratively building enterprise-class analytic applications that query and display results from the Oracle Endeca Server.

Oracle Endeca Information Discovery Integrator

This set of tools enables the rapid unification and augmentation of diverse sources of information. It includes (1) Content Acquisition System for gathering content from file systems, content management systems, and websites, and (2) Integrator which provides out-of-the-box ETL tooling for integrating and enriching enterprise data.

Oracle Endeca Server

Oracle Endeca Server is the core search-analytical database that organizes complex and varied data from disparate source systems into a faceted data model that is extremely flexible and reduces the need for up-front data modeling. This highly-scalable server enables users to explore data in an unconstrained and impromptu manner and to rapidly address new questions that inevitably follow every new insight. This product leverages a restricted use of WebLogic Server Standard Edition to run the Endeca Server APIs.

Oracle Endeca Content Management System Connectors

Oracle Endeca Content Management System Connectors are add-on modules that allow for integration of content stored in various enterprise content management systems. Currently supported systems include: EMC Documentum, EMC Documentum eRoom, FileNet P8, FileNet Document & Image Services, Interwoven TeamSite, Lotus Notes/Domino, Microsoft SharePoint, and OpenText LiveLink.

Oracle Endeca Text Enrichment

Oracle Endeca Text Enrichment is an add-on module that includes text analysis capabilities for extraction of people, places, organizations, quotes, and themes as well as core summarization capabilities for automatic creation of abstracts or topical summaries.

Oracle Endeca Text Enrichment with Sentiment Analysis

Oracle Endeca Text Enrichment with Sentiment Analysis is an add-on module that includes all of the Text Enrichment capabilities as well as advanced text analysis for extraction of aggregate sentiment related to each extracted concept. Sentiment is extracted with a score indicating the positive and negative nature of a document or an entity in the document. These scores can be used within the faceted search experience by varying ranges of positivity and negativity.


9.16 Oracle Exalytics In-Memory Software

Oracle Exalytics In-Memory Software is a separately licensed product that is used with the Oracle Exalytics In-Memory Machine and Oracle products listed below.

If licensing by Named User Plus, the minimum is 20 Named User Plus licenses per Customer. Business Intelligence Foundation Suite is a licensing pre-requisite for this product. All TimesTen In-Memory Database for Exalytics users must have license entitlement to Business Intelligence Foundation Suite. The number of licenses of the Business Intelligence Foundation Suite needs to match the number of licenses of this product.

If licensing by Named User Plus, the minimum is 20 Named User Plus licenses per Customer. The licensing prerequisites for this product are Business Intelligence Foundation Suite or Business Intelligence Suite Enterprise Edition Plus or Business Intelligence Foundation Suite for Oracle Applications or Business Intelligence Suite Enterprise Edition Plus for Oracle Applications and/or Essbase Plus and/or Hyperion Planning Plus.

Table 9-12 Oracle Exalytics In-Memory Software Features

Feature Description Product/Component

Summary Advisor for Oracle Business Intelligence Server

Summary Advisor monitors Business Intelligence usage patterns, analyzes them and recommends the optimal data mart for best overall performance improvement.

Oracle Business Intelligence Administrator

Aggregate Persistence (CREATE AGGREGATES, and DELETE AGGREGATES commands) when run against the TimesTen In-Memory Database for Exalytics

The Aggregate Persistence feature enables automated creation of data marts by using Business Intelligence server commands.

Oracle Business Intelligence Server

Exalytics-specific optimizations enabled by "Oracle Hardware acceleration" flags for Oracle Business Intelligence Server

Optimizations to match system architecture resulting in higher query throughput, lower latencies in query processing. Enhanced memory usage for cache.

Oracle Business Intelligence Server

Enhanced Bursting within Oracle Business Intelligence Publisher

Enables piped document generation. Enabled by setting OPTIMIZE_BURST flag in xmlp-server-config.xml file

Oracle Business Intelligence Publisher

Exalytics-specific optimizations enabled by "Oracle Hardware acceleration" flags for Oracle Business Intelligence Presentation Server

Optimized default configuration to use large footprint memory to speed up page rendering and caching.

Oracle Business Intelligence Server

Exalytics-specific optimizations enabled by "Oracle Hardware acceleration" flags for Oracle Essbase Plus

Memory usage optimizations for loading entire data into memory, concurrency improvements to match Exalytics architecture enabling efficient distribution of processing.

Oracle Essbase Plus