- 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 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.
8.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:
- Section 8.3.1, "Included Products and Components"
- Section 8.3.2, "Additional Usage Notes and Restrictions"
8.3.1 Included Products and Components
Table 8-6 summarizes the products and components included in the license for Oracle Business Intelligence Standard Edition One.
Table 8-6 Oracle Business Intelligence Standard Edition One Products and Components
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.
- One Named User Plus license
Oracle Business Intelligence Publisher
Enterprise reporting and distribution of highly formatted reports.
8.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)
- 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.
8.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 8-7 summarizes the products and components included in the license for Oracle RTD.
Table 8-7 Oracle Real-Time Decisions Products and Components
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 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 is an Eclipse-based graphical development tool for application developers to define RTD application logic and to configure Inline Services.
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.
Provides role based access control based on authorization policies.
8.5 Oracle's Hyperion Business Intelligence Technology
Table 8-8 lists the products, components, and restrictions included in the Oracle's Hyperion Business Intelligence Technology licensed programs.
Table 8-8 Hyperion Business Intelligence Technology: 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. (UNKNOWN STEP NUMBER) , (UNKNOWN STEP NUMBER)
- 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. (UNKNOWN STEP NUMBER) , (UNKNOWN STEP NUMBER)
- 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. (UNKNOWN STEP NUMBER) , (UNKNOWN STEP NUMBER)
- Hyperion Foundation Services (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. (UNKNOWN STEP NUMBER) , (UNKNOWN STEP NUMBER)
- 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.
8.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.
8.7 Oracle Business Intelligence Mobile
Oracle Business Intelligence Mobile extends Oracle BI Enterprise Edition capabilities to mobile clients such as Apple iPhone and iPad.
8.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 10 g and is not available with Oracle BI 11 g .
8.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.
8.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 8-9 Oracle Business Intelligence Data Integration Products
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
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.
8.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 8-10 summarizes the products and components included in the license for Oracle BI Foundation Suite.
Table 8-10 Oracle Business Intelligence Foundation Suite Products and Components
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.
8.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) 10 g . 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 10 g . Oracle Business Intelligence 11 g 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.
8.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.
8.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.
8.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 J2EE 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.
8.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.
8.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 8-11 summarizes the products and components included in Oracle Endeca Business Intelligence.
Table 8-11 Oracle Endeca Business Intelligence Products and Components
Oracle Endeca Information Discovery
Oracle Endeca Information Discovery contains two main components:
- 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.
- Integration Suite. This suite of tools enables the rapid unification and augmentation of diverse sources of information. It includes (1) the Content Acquisition System for gathering content from file systems, content management systems, and websites, and (2) the 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.
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.
8.16 Oracle Exalytics In-Memory Machine
Oracle Exalytics In-Memory machine is an in-memory analytics machine, engineered for Oracle Business Intelligence Foundation Suite.
Oracle Exalytics runs Oracle TimesTen In-Memory Database for Exalytics. Oracle TimesTen In-Memory Database for Exalytics has a pre-requisite of Oracle Business Intelligence Foundation Suite. The number of licenses of Oracle Business Intelligence Foundation Suite shall equal the number of Oracle TimesTen In-Memory Database for Exalytics.
When licensed using the processor metric, Oracle TimesTen In-Memory Database must be licensed for all processors in Oracle Exalytics.
When licensed using the NUP metric, a minimum of 100 Named User Plus licenses are required for Oracle TimesTen In-Memory Database. As a consequence, Business Intelligence Foundation Suite shall also have a minimum of 100 Named User Plus licenses when deployed on Oracle Exalytics.
The following software features are licensed with the Oracle Business Intelligence Foundation Suite only when deployed on the Oracle Exalytics In-Memory Machine.
Table 8-12 Oracle Exalytics In-Memory Machine Features
Oracle Business Intelligence Administrator
Summary advisor monitors Business Intelligence usage patterns, analyzes them and recommends the optimal data mart for best overall performance improvement.
Oracle Business Intelligence Server
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
Optimizations to match system architecture resulting in higher query throughput, lower latencies in query processing. Enhanced memory usage for cache.
Oracle Business Intelligence Presentation Server
Exalytics-specific optimizations enabled by "Oracle Hardware acceleration" flags
Optimized default configuration to use large footprint memory to speed up page rendering and caching.
Exalytics-specific optimizations enabled by "Oracle Hardware acceleration" flags
Memory usage optimizations for loading entire data into memory, concurrency improvements to match Exalytics architecture enabling efficient distribution of processing.
