Saturday, October 24, 2015

OBIEE 12c (12.2.1) is available

Oracle Business Intelligence 12c is available for download here

It is available for:
  • Windows X86 -64bit
  • Linux X86-64bit
  • Oracle Solaris on SPARC 64-bit
  • Oracle Solaris on x86 64-bit
  • IBM AIX 64-bit
  • HP UX Itanium
System Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.2.1) is here.

The documentation is here .

What is new in 12c?

 Quite a lot.
First of all,everything regarding data visualization is new. See: User's Guide for Oracle Data Visualization 

I gathered here new features chapters from various 12c Books:

New features in Oracle BI EE 12c (12.2.1) include:
Enhancements to Graphs
In this release graphs have been enhanced as follows:
  • Ability to sort graph views by using a context menu (right-click). A new sort dialog is displayed when you right-click in a graph view in the "Analysis editor: Results tab" or on a dashboard page. You can right-click legend, data marker, and group-level (X axis) items to display a menu of interactions that includes options such as Sort and Drill (see "Right-Click Interactions in Views" for additional information).
Enhancements to Views
This release includes enhancements to various view types that can assist a content designer in creating more effective analyses faster, including those in the following list:
  • A new view type named heat matrix. Heat matrices are two-dimensional representations of data in which values are characterized by a gradient of colors. A simple heat matrix view provides an immediate visual summary of information that is well suited for analyzing large amounts of data and identifying outliers. See "Editing Heat Matrix Views" for additional information.
  • Ability to sort graph, heat matrix, pivot table, table, treemap, and trellis views by using a context menu (right-click). A new sort dialog is displayed when you right-click in a data view in the "Analysis editor: Results tab" or on a dashboard page (see "Right-Click Interactions in Views" for additional information).
Enhancements to Analyses
This release provides, for analyses, the ability to:
Enhancement to Scorecards
In this release, you can style and customize KPI Watchlists and every watchlist that appears in a scorecard. You can set custom styles for each watchlist and rename and change the order and visibility of the watchlist columns. See "Customizing Watchlists."
Enhancements to Dashboards
In this release, you can set advanced page properties to specify incoming navigation parameters you want to set on the current dashboard page. This enables you to control how parameters associated with the navigation actions are applied. See "Setting Advanced Page Properties."

New metadata repository features in Oracle BI EE 12c Release (12.2.1) include:
Logical Level Sequence Numbers for Time Dimensions
The Sequence Numbers tab has been added to the Logical Level dialog. The new tab allows you to add absolute or relative sequence numbers to time dimensions. These mappings provides direct column references in the Time dimension table, which creates a query that is easier for Oracle BI Server to execute against the data source. See "Adding Sequence Numbers to a Time Dimension's Logical Level" for more information.
DISPLAY | SORTKEY Syntax Supported in the SQL ORDER BY Expression
The Oracle BI Server now accepts the DISPLAY and SORTKEY keywords in the SQL ORDER BY expression. You can use the DISPLAY keyword to override a logical column's assigned sort order column. For more information, see "ORDER BY Clause Syntax."
Oracle Database Fast Application Notification and Fast Connection Failover Supported by Oracle BI Server
The Oracle BI Server supports the Fast Application Notification (FAN) event and Fast Connection Failover (FCF) Oracle Database configuration. Fast Connection Failover enables quick failover when the data source's Oracle database is not available. See "Oracle Database Fast Application Notification and Fast Connection Failover" for more information.
Generate Fragmented Aggregates in Aggregate Persistence
The aggregate persistence functionality has been enhanced to generate fragmented aggregates from a manually written aggregate specification. You can generate fragmented aggregates by adding a Where clause to the Logical SQL query's Create statement. See "Writing the Create Aggregates Specification" for more information.
New Command Line Utilities
Several command line utilities have been added. See the following topics for more information:

New system administration features and changes in Oracle BI EE 12c (12.2.1) include:
Invoking WLST From a Single Location
In previous releases, you invoked WLST from different locations, depending on whether you were using the commands for Oracle WebLogic Server, system components, or Java components such as Oracle SOA Suite. In this release, you invoke WLST from:
(UNIX) ORACLE_HOME/oracle_common/common/bin/
(Windows) ORACLE_HOME\oracle_common\common\bin\wlst.cmd
Oracle Home Location Redefined and No Middleware Home
Redefining of the Oracle home and elimination of the Middleware home. See "New And Deprecated Terminology for 12c" in Oracle Fusion Middleware Concepts.
OPMN is No Longer Used in Fusion Middleware
OPMN is no longer used in Oracle Fusion Middleware. Instead, system components are managed by the WebLogic Management Framework, which includes WLST, Node Manager and pack and unpack. See "What Is the WebLogic Management Framework" in Oracle Fusion Middleware Concepts.
Oracle Web Cache Not Part of Fusion Middleware
Oracle Web Cache is no longer part of Oracle Fusion Middleware.
Moving From Test To Production is Carried Out in a Different Way
The test to production operation is still possible however, the process is different from what was available in Oracle Business Intelligence Release 1 (11.1.1) as it applies solely to metadata (content, data model and authorization). For information, see Chapter 22, "Moving Oracle Business Intelligence Between Environments".
New Commands For Process Control
New process control commands replace the old start stop commands. For information, see Section 1.5.3, "Process Control Commands".
Managing Metadata In Business Intelligence Archive Files
All Oracle Business Intelligence metadata, including repository, Presentation Services catalog, and user authentication is stored in BAR archive files. The BAR file is a mechanism for managing or moving a self contained set of Oracle BI metadata between environments. For information, see Chapter 9, "Managing Metadata and Working with Service Instances".
Single Enterprise Install
In this release the Oracle Universal installer offers a single install type for your Enterprise which provides an Administration server, and a Managed server. For information, see Section 1.3, "What Is the Oracle Business Intelligence System Logical Architecture?" and Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence.
Changes to Scaling Out
In this release the scale out procedures for Oracle Business Intelligence have changed. For information, see Chapter 3, "Scaling Your Deployment".
Simplified Configuration
Configuration files are no longer duplicated. Separate configuration files still exist for example, for Oracle BI Presentation Services and BI Server, but they are not duplicated in the case of a cluster. For information, see Section 8.3, "Configuring Oracle Business Intelligence System Settings".
Managing System Component Instances Using Commands
OBIS (BI Server) system component instances are separately managed in BI 12.2.1 using service instance commands. For information, see Section 9.2, "Managing Service Instances".
Collecting Diagnostic Bundles
A new script enables you to collect the diagnostic bundles needed by Oracle Support or Development to help resolve issues. For information, see Section 6.2, "Collecting Diagnostic Bundles".
Synchronizing Mid-Tier Database Connection Details Command
A new command enables you to synchronize mid-tier database connection details when they have changed. For information, see "Synchronize Mid-Tier Database Connection Details Command".

New security features in Oracle BI EE 12c (12.2.1) include:
BISystemUser and BISystem Removed
To simplify administration and configuration in this release Oracle Business Intelligence no longer requires a real user called BISystemUser (or equivalent) for internal communication. The system user concept is now deemed "virtual" and is represented by the credential, for which the values are securely randomly generated by the Configuration Assistant. Oracle BI components continue to use this credential for internal communication, backed by Oracle BI Security. The application role BISystem is also no longer present in the Policy Store, and will be removed from any upgraded 11g environment.
User GUIDs Removed
In this release user GUIDs have been removed to make administration easier. GUIDs are replaced with user names. There is no longer any need to refresh GUIDs as part of lifecycle operations. Your administrator is now responsible for ensuring that users leaving the system are cleaned up from Oracle Business Intelligence.
Database Security Store
In this release the Security Store (Policy and Credential Stores) is configured in a relational database rather than in a file. The database is the same as used by RCU. This change makes scaling easier, and makes clusters more reliable.
Easier SSL Configuration
In this release configuring SSL end to end is now less complex and uses offline commands.
The key differences in SSL support in this release (from 11g) are as follows:
  • SSL uses the WebLogic trust store
    No additional BI-specific trust configuration is required.
  • Offline commands
    There is no need to use Fusion Middleware Control UI to configure processes.
  • Diagnostics for WebLogic certificate issues
  • Higher security - TLSv1.2 only
  • Configuration is central and not intermingled with user configuration.
  • Supports advanced options with no risk of settings being overwritten.
Migrating Catalog Groups to Application Roles
In this release a new process enables you to migrate Catalog groups to application roles.

This section describes new features for Oracle BI EE 12c (12.2.1). It contains the following topics:

New Service

Oracle Business Intelligence 12c (12.2.1) includes the following new service:


New features and changes for Oracle BI Publisher 12c Release 1 (12.2.1) include:

Generate Explain Plan from SQL Data Set

For data sets generated by SQL queries issued against the Oracle Database, you can now generate an Explain Plan to provide valuable information about the efficiency of your query. For more information, see Section 9.8.1, "Generate Explain Plan."

Best Practices Information

Poorly constructed data models can result in out-of-memory exceptions. Use these best practices guidelines to help you tune your data models for more efficient memory usage. See Chapter 9, "Performance Best Practices."

In Release 12c (12.2.1) the look and feel of the user interface is refreshed. You will notice new icons and some changes to the presentation of features on the Home page.

Naturally we can expect, the previously described new features are included in 12c.
(here, here and here)

There are new tutorials:


  1. Hi,
    I am not able to download file 2 full size in oracle page it is showing like 1.8 GB and while I am downloading it is like 1.4 GB getting installation error Please help me

    1. Venkat, managing Oracle download is not my specialty, but whenever I have similar problems, I use Firefox add in named DownloadThemAll. It usually solves such problems.
      If it doesn't help, try Oracle Support.

  2. this article nice ,this information is very useful to me and our company ithubonlinetraining

  3. Bluehost is ultimately one of the best hosting provider with plans for all of your hosting requirments.