Tuesday, November 3, 2015

OBIEE 12C New Features

Many new features has been added in the OBIEE 12C including new views, new UI level functions, column properties, Powerful visual analyzer tool etc.,
  • Let us see some of the new visualizations available in 12C:

  • All Views are enhanced in such a way that we can 'right click' on all graphs & other views to sort, drill, keep the column or remove the column from the view.

  • 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.

New View Added:

  • A new View called 'Heat Matrix' view has been included which represents the two-dimensional data. This is well suited for analyzing large amounts of data and identifying outliers.
    You can find the values by 'Roll over' on the cells. Or you can make it as display always.

New UI 'R Analytics' Functions:

  • One of the great advantage of OBIEE12C is availability of new set of functions related to 'R Analytics'  added in the 'edit formula' tab.
  • 'R' is a programming language and software environment for statistical computing and graphics. The 'R' language is widely used among statisticians and data miners for developing statistical software and data analysis.
  • To work with 'R Analytics' functions we have to setup 'R' in the environment.
  • The 'R Analytics' function set includes
Cluster, Evaluate Script, Outlier, Regr, Trendline functions.

New Time series Function:

  • A new time series function called 'Forecast' has been added.

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 include 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 source like excel file through the 'Add Data Source' option available.

Visual Analyzer

  • This is a completely new powerful visualization application introduced in OBIEE12C.
  • VA provides greater flexibility to Rapidly create rich analyses through drag-and-drop configuration of new visual grammar.
  • Using VA we can build the reports from the sources OBIEE repository and also from external content.

BI Server New Features

  • Logical Level Sequence Numbers for Time Dimensions for faster time series calculations. And to improve the query time.
  • DISPLAY, SORTKEY Syntax Supported in the SQL ORDER BY Expression
  • Oracle Database FAN & Connection Failover Supported by Oracle BI Server

Following New Command Line utilities are added
      • Download Repository
      • Upload Repository
      • List Connection Pool
      • Update Connection Pool
      • Rename Application Role
      • Delete Application Role
      • Rename Users
      • Delete Users
      • List Repository Variables
      • Update Repository Variables

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.

New Features for Oracle BI System Administrators

  • 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 Not Part of 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(BAR File)
  • Single Enterprise Install. No separate 'Software only' and 'Simple Install' is available.
  • Simplified Configuration
  • Managing System Component Instances Using Commands
  • Collecting Diagnostic Bundles

Migration from OBIEE 11g to 12c

    • We can migrate the Oracle BI 11g metadata to 12c is a two step process, and is carried out by using the BI Migration Script (migration-tool.sh).
    • The catalog and WebLogic Security configurations needs to be reconfigured/migrated like in OBIEE 11g.

New Features in Oracle BI Security

  • BISystemUser and BISystem are removed.
  • User GUIDs Removed
  • Database Security Store
  • Easier SSL Configuration
  • Migrating Catalog Groups to Application Roles

New Features for Oracle BI Publisher 12c

  • Generate Explain Plan from SQL Data Set
  • Best Practices Information


  1. Can someone give me the list of Limitations of OBIEE 12C for my Case Study.

  2. very informative blog and useful article thank you for sharing with us , keep posting Ruby on Rails Online Course

  3. Best R Programming Training in Bangalore offered by myTectra. India's No.1 R Programming Training Institute. Classroom, Online and Corporate training in R Programming
    r programming training

  4. Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. R Programming insitute in chennai

  5. I like your blog, I read this blog please update more content on hacking,
    Nice post
    Tableau Online Course

  6. It's really a nice experience to read your post. Thank you for sharing this useful information. If you are looking for more about R Programming institutes in Chennai | R Programming Training in Chennai

  7. Thank you for sharing such great information with us. I really appreciate everything that you’ve done here and am glad to know that you really care about the world that we live in.
    Cloud computing Training in Chennai
    Hadoop Training in Chennai
    Cloud computing Training institutes in Chennai
    Best Cloud computing Training in Chennai
    Hadoop Course in Chennai
    best big data training in chennai


  8. It's really a nice experience to read your post. Thank you for sharing this useful information. If you are looking for more about big data training in Velachery | Hadoop Training in Chennai | big data Hadoop training and certification in Chennai | Big data course fees

  9. Your blog on RPA is so attractive that i am not able to stop myself to read this blog of yours on RPA.This blog contains all the important topics and points of RPA. Requesting you keep updating this post on RPAand help them who is eager to gain knowledge on RPA.
    Thanks and Regards,
    Uipath training in chennai
    blue prism training institute in chennai
    blue prism training with certification in chennai

  10. Thank you for sharing valuable information.This article is very useful for me valuable info about
    OBIEE Online Training
    OBIEE Training
    OBIEE Online Course .keep updating.........


  11. I have read your blog very useful information to everyone.Thanks for sharing and keep updating more.If you are looking for python course visit our website.
    Python Training Institute In Bangalore

  12. Thank you so much for sharing this useful infirmation.It is very attractive.keep posting more.Visit our site for any courses
    data science training institutes in bangalore

  13. This comment has been removed by the author.


  14. I recently came across your blog and have been reading along. I thought I would leave my first comment. I don't know what to say except that I have enjoyed reading. Nice blog. I will keep visiting this blog very often.
    OBIEE Online Training
    OBIEE Training