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.
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
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/wlst.sh
(Windows) ORACLE_HOME\oracle_common\common\bin\wlst.cmd
Oracle Home Location Redefined and No Middleware Home
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
New Commands For Process Control
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
Changes to Scaling Out
Simplified Configuration
Managing System Component Instances Using Commands
Collecting Diagnostic Bundles
Synchronizing 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
oracle.bi.system/system.user, 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 Structures
Oracle Business Intelligence 12c (12.2.1) includes the following new structures:
New Methods
Oracle Business Intelligence 12c (12.2.1) includes the following new methods:
Publisher
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 11.1.1.9 new features are included in 12c.
There are new tutorials:
0