How Does Oracle BI EE Interact with Other Products?

Oracle BI EE can work with a variety of other products.

Oracle BI EE interacts in various ways with other products. This section contains the following topics:

Integration of Oracle BI EE with Oracle BI Publisher

Oracle BI EE and Oracle BI Publisher work together to provide a complete data analysis and presentation tool.

Note:

This guide assumes that Oracle BI EE and BI Publisher have been installed and configured to run as integrated components at your organization. If this is not the case, then some mentions of BI Publisher in this guide might not be applicable to you.

For information on running BI Publisher, see User's Guide for Oracle Business Intelligence Publisher.

BI Publisher enables you to create highly formatted reports that are suitable for printing. BI Publisher reports are built on top of BI Publisher data models. A BI Publisher data model can consist of data sets from a wide range of sources, such as subject areas from the BI Server or analyses, SQL queries against relational databases, MDX queries against Essbase or other Online Analytical Processing (OLAP) sources, Lightweight Directory Access Protocol (LDAP), Web Services, Microsoft Excel, HTTP feeds, or XML files. BI Publisher supports a wide range of layout types, so you can create the full range of documents that your organization might need. Within Oracle BI EE, you can view, create, edit, and schedule BI Publisher reports and can include them in dashboard pages.

Oracle BI EE includes a fully integrated BI Publisher. All the BI Publisher functionality appears within the Oracle BI EE application, and all reports and related objects are created within Oracle BI EE and saved to the Oracle BI Presentation Catalog.

When using the integrated environment, you see that the following areas are affected by the integration:

  • Editors — You can create or edit BI Publisher content. When you work with a BI Publisher object, the appropriate BI Publisher editor is displayed. For example, when you work with a data model, the Data Model editor is displayed.

  • Dashboards — You can embed BI Publisher reports in dashboards. You can also create custom print layouts for high-fidelity printing of dashboard pages and custom export layouts for exporting dashboard content to Excel. See Building and Using Dashboards.

  • Catalog — The Oracle BI Presentation Catalog contains all BI Publisher objects, such as reports and templates. You can work with BI Publisher objects in the catalog just as you work with other catalog objects, such as analyses or filters.

  • Security — Single sign-on capability is provided. The Release 11g security model has been extended to include additional BI Publisher-specific permissions, such as xmlp_template_designer.

See Creating Reports in Report Designer's Guide for Oracle Business Intelligence Publisher and Creating Reports: Process Overview in Report Designer's Guide for Oracle Business Intelligence Publisher.

Integration of Oracle BI EE with Oracle BI Mobile App Designer

You can design analyses and presentations for display on mobile devices.

Note:

This guide assumes that Oracle BI EE and Oracle BI Mobile App Designer have been installed and configured to run as fully integrated components at your organization. If this is not the case, then some mentions of Oracle BI Mobile App Designer in this guide might not be applicable to you.

Oracle Business Intelligence Mobile App Designer is a tool for designing purposeful apps for mobile phones and tablets.

The apps you create with Oracle BI Mobile App Designer are platform and device independent. The generated apps are based on the modern HTML5 standard, which means they can run on any modern browser on your mobile device. No client install is required.

Integration of Oracle BI EEwith Oracle Business Intelligence Mobile

Oracle Business Intelligence Mobile is an application that enables you to view and interact with Oracle BI EE content on smartphones and tablets.

You can easily access Oracle BI Enterprise Edition analyses and dashboards through Oracle Business Intelligence Mobile. You see the same content, and it is optimized for viewing on your mobile device. You can install Oracle Business Intelligence Mobile on your mobile device from Apple's App Store or from the Google Play store.

For information on Oracle Business Intelligence Mobile, see the Oracle Business Intelligence Mobile Products Documentation Library here:

http://docs.oracle.com/cd/E52471_01/index.htm

Integration of Oracle BI EE with Oracle Enterprise Performance Management System

The Oracle Enterprise Performance Management System helps ensure your suite of applications work efficiently.

Oracle BI EE offers the following integration with Oracle Enterprise Performance Management System:

Interaction of Oracle BI EE with Oracle BI Applications

Oracle BI Applications work with Oracle BI EE to provide an entire suite of integrated data analysis tools.

Oracle Business Intelligence Applications are pre-built business intelligence solutions that are available for Oracle applications such as Oracle Fusion, Oracle E-Business Suite, JD Edwards, Peoplesoft, and Siebel. Oracle Business Intelligence Applications are built on Oracle BI EE.

Oracle BI Applications consist of industry-specific dashboards and analyses that are built using industry best practices to address key functional areas within an organization. Dashboards and analyses are tailored for each end user's role in an organization.

Typically, Oracle BI Applications are integrated with and accessible from other operational applications, such as Oracle's Siebel CRM applications, to provide business metrics in analyses in the context of an organization's business function and industry. Oracle BI Applications include Extract Transform Load (ETL) routines to extract, transform, and load data into the Oracle Business Analytics Warehouse. Oracle BI Applications also contain metadata that maps to the Oracle Business Analytics Warehouse and a transactional database, and define key measures and metrics for all levels of the organization. These measures and metrics are available to content designers in Oracle Business Intelligence.

Integration of Oracle BI EE with Microsoft Office

There are add-in components that link Oracle BI EE functions with Microsoft Office.

Oracle BI EE offers a set of add-ins to Microsoft Office that can be downloaded and installed to enable integration between components of Oracle Business Intelligence and Microsoft Office. The Get Started section of the Oracle BI EE Home page provides links to install the following add-in components:

  • Template Builder for Word

  • Oracle Hyperion Smart View for Office

See Downloading BI Desktop Tools.