Oracle Business Intelligence 12C Overview

Start Here

Get in touch with a
TriCore Solutions specialist

Blog | May 24, 2016

Oracle Business Intelligence 12C Overview

Oracle Business Intelligence 12C is latest analytics suite release of the Oracle BI System with major changes to architecture and new updated feature sets such as visual analyzer, better life cycle management, BI Ask and Data Mashups. 

Oracle Business Intelligence 12C Overview



The Oracle Home location has been redefined and there is no more middleware home. OPMN is no longer used in Oracle Fusion Middleware. Instead, system components are managed by the WebLogic Management Framework, which includes WLST, Node Manager. 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 sets of Oracle BI metadata between environments.

Parameters are now changed directly in files - no more MBeans or parameter changes via Enterprise Manager. A new command enables you to synchronize mid-tier database connection details when they have changed. A new script enables you to collect the diagnostic bundles needed by Oracle Support or Development to help resolve issues.

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. GUIDs have been removed to make administration easier, GUIDs are replaced with user names. There is no longer any need to refresh GUIDs. BISystem and BISystemUser are removed - this is all handled internally now, so we don't have to worry again about corrupted system credentials and similar issues.

New Features:

1. Visual Analyzer

Visual Analyzer is an interactive web based tool used to explore and analyze your data. It enables you to perform rapid data discovery using standard Oracle BI "Subject Areas" or using your own external data sources (Spreadsheets). It was first available in Oracle BI Cloud Services, complement to answers and dashboards for data exploration. Visual Analyzer allows you to create different analysis and reports in the same place and shows the results immediately on the same page.


2. RPD Modeling

New command line utilities to Download Repository, Upload Repository, List Connection Pool, Update Connection Pool, Rename Application Role, Delete Application Role, Rename Users, Delete Users, List Repository Variables, and Update Repository Variables. 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.

3. Visualizations

All views are enhanced in such a way that we can right click on all the graphs and views to sort, drill, keep or review the column from the views. Under 'Column Properties'-->Data Format properties--> “Scale for % (x 100)” option is added that specifies whether to multiply data by a 100 to display it as a percentage when setting the properties of a column.



A new view called 'Heat Matrix' has been included which represents the two-dimensional data:



4. Adding Your Own Data to Analyses:

You can include dimensions and measures from external data sources in your analyses. The external data is loaded to the database, but is not part of the BI metadata catalog. You can create an analysis that includes only data from an external source, or you can blend dimensions and measures from the external data source with dimensions and measures defined in the BI metadata catalog. The external data must be stored in a Microsoft Excel format spreadsheet file. You import the data from the spreadsheet file into the BI EE database as an external data source. You then add columns from the external data source to your analyses. When the data in spreadsheet file changes, you can refresh the BI EE database with the changes. Also we can add external data sources like an Excel file through the 'Add Data Source' option.

5. Administration

  • We can invoke WLST from a single location
  • Oracle Home location re-defined and there is no middleware home now.
  • OPMN is no longer available in Fusion Middleware
  • Oracle Web Cache is not part of Fusion Middleware
  • Moving from test to production is carried out in a different way
  • New commands for process pontrol
  • Managing metadata in Business Intelligence Archive Files (BAR File)
  • Single enterprise install. No separate 'software only' and 'simple install' available.
  • Simplified configuration
  • Managing system component instances using commands
  • Collecting diagnostic bundles
  • Database security store
  • Easier SSL configuration
  • Migrating catalog groups to application roles
  • We can migrate the Oracle BI 11g metadata to 12c. It is a two-step process, and is carried out by using the BI Migration Script (

Thank you for reading the Oracle BI c12 overview, I hope you found this information helpful. If you have any questions or comments, please do not hesitate to contact TriCore Solutions or leave a comment below.

 Get Vikram's Oracle BI C12 Overview Whitepaper

Can't get enough Oracle knowledge?  Dowload the Oracle  Tips eBook!