Much waited OBIEE 12c is released – All new features, Improvements

25 Oct

Much waited OBIEE 12c is released. This version is another major release from Oracle after OBIEE 10g and11g. This version has many improvements, Enhancements, and advanced new features in installation, migration, analyses and dashboards, Oracle BI Mobile, Oracle BI Publisher, metadata repository development, system administration, integration and API, and localization.

Download link:



New Features in Presentation Services:

  • Visual Analyzer: A brand new powerful visualization application in OBIEE Suite. 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.
  • Views Enhancements: New context menu (Right Click) on all graphs & other views to sort, drill.
  • New Heat Matrix view type to represent the two-dimensional data. This is well suited for analyzing large amounts of data and identifying outliers.
  • New Data Format properties “Scale for % (x 100)”: Specify whether to multiply data by a 100 to display it as a percentage when setting the properties of a column

New Features in BI Server:

  • 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
  • Generate Fragmented Aggregates in Aggregate Persistence
  • 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

New Features in Administration:

  • Installation: Much faster and straight forward. And mostly, the configurations & folders directories are simple and clean.
  • NO more OPMN, all services including OBI System & Java services are managed by WebLogic.
  • Migrating 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 ( The catalog and WebLogic Security configurations needs to be reconfigured/migrated like in OBIEE 11g.
  • BAR (BI Archive file): A new archive format which contains OBIEE Catalog, RPD and Security packaged in one file. The file will be created in current environment and imported in Target environment. The BAR file creation process has following options while creating it.
    • export all: To export everything including users and data sources are the same between two systems.
    • export without user folder content: Migrating the Catalog without the User’s Folders.
    • export without connection pool credentials: Migrating the upgraded RPD from one environment to another without connection Pool information. When Imported the BAR in Target environment, The RPD will be updated the new changed by not changing the Target System Connection Pool Information.
    • Syntax:
      • Creating the BAR File from Current Environment: 
        exportServiceInstance(domainHome, serviceInstanceKey, workDir, exportDir, applicationName=None, applicationDesc=None, applicationVersion=None, includeCatalogRuntimeInfo=false, includeCredentials=None)
      • Importing the BAR file in Target environment:
        importServiceInstance(domainHome, serviceInstanceKey, barfile)

New Features in Security:

  • BISystemUser and BISystem Removed, No need to have BISystemUser in LDAP. 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.
  • User GUIDs Removed: 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
  • Database Security Store: Policy & Credential store is configured in database instead of the file System-jazn & etc.
  • Easier SSL Configuration: Configuring SSL is much easier than earlier versions.

Overall this is a great release after OBIEE 11g from Oracle. Best version to start exploring and do great analysis.

Stay tuned for more interesting articles on OBIEE 12c here.

Shiva Molabanti


12 responses to “Much waited OBIEE 12c is released – All new features, Improvements

  1. JanardhanaRao

    November 11, 2015 at 1:29 pm

    Thank you soo much on this info

  2. mihai

    November 12, 2015 at 4:09 pm

    how to enable wna sso in analytics on obiee12c?

  3. ss

    November 19, 2015 at 11:24 am

    Good Post

  4. mohan

    March 1, 2016 at 11:27 am

    Hi Shiva,

    I would like to deploy catalog from obiee to Can you plese share the steps

  5. raj9blog

    May 12, 2016 at 7:30 am

    Hi Shiva,

    I am creating reports in OBIEE 12c from excel file data which was uplaoded through analytics.
    Now i want to create Drilldown (Hierarchies) for the excel file Data. Can we create hierarchies for an excel data file from analytics. Pls share the details how to create hierarchies.

    I am using OBIEE 12c stand alone application.

  6. Rafael

    September 26, 2016 at 8:45 pm

    Excellent post’m in trouble after the migration to 11g 12c url does not accept authentication weblogic could help me

    • Shiva Molabanti

      October 12, 2016 at 12:14 am

      Make sure the application roles and Policies that you have in 11g are migrated to properly. In 12c EM, go to applictaion policies and check the BIServiceAdministrator/BIAdministrator have the permissions to manage teh catalog.

  7. Suman Das

    November 28, 2016 at 6:53 pm

    Hi Shiva,
    I want to create a sample map report in 12C for a project POC. Please could you guide me.

  8. Kumar

    January 26, 2017 at 6:57 am

    Hello Shiva,
    Can you please provide me OBIEE 11g to OBIEE 12 c Upgrade document on linux. Also how does security work when we do upgrade? can we create a report using Excel as a data source?


    Appreciate your help.


  9. Emmanuel

    March 30, 2017 at 1:51 pm

    Hi Chiva,
    While installing OBI 12c configuration assistant on Windows, i get an “Ensure the Database being used in compatible error” at step 4
    Kindly advise on how to resolve this.
    Oracle Home version :
    thank you


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: