A Known Differences: Oracle Business Intelligence 12c

This appendix lists the differences in appearance and functionality of the Oracle BI 12c system after migration.

Oracle Business Intelligence Release 12c includes many new and enhanced features. To learn about the features and enhancements, see the "What's New" sections described in those guides.

SCM: DSO and AR Balance Trend Are Displayed Differently in 12c

The DSO and AR Balance Trend graph in the Supply Chain and Order Management module can be displayed differently in Oracle BI 12c even if the underlying data used to generate this graph is the same. The display difference occurs due to the manner in which the BI Server handles the order of the time period data that is fetched from the database.

Visual Cues in BI Composer are Displayed the Same Accessibility Mode

Visuals cues, such as icons and check boxes, which are displayed on pages in BI Composer, are displayed the same whether you have accessibility mode turned on or not. Even though the list of text-based wizard page links are not displayed on a wizard page in accessibility mode, screen reader applications such as JAWS can read them.

Enabling Embedded Content in Dashboards

For security reasons, you can no longer embed content from external domains in dashboards. To embed external content in dashboards, you must edit the instanceconfig.xml file.

For a complete procedure, see Embedding External Content in Dashboards in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

Trellis Views Display Without Grid Lines in 12c

A trellis is a view type that presents multidimensional data laid out in a set of cells in a grid, with each cell displaying a subset of data shown as numbers or as graphs. The trellis view allows users to display multiple views all at once for quick comparison, and to display data that reveals trends. In Oracle BI 11g, the trellis view contained grid lines, by default. With Oracle BI 12c, you can select horizontal or vertical lines, or you can select the default option.

To specify the grid options:
  1. Open the trellis view for editing.
  2. Click the properties dialog.
  3. Based on your choice, select:
    • Horizontal
    • Vertical
    • Default option

Domain Home and bipublisher Folder Path Different in 12c

The Domain home and bipublisher file paths are different in 12c as compared to the 11g system.

For Domain Home:

In 11g: mwhome/user_projects/domains/bifoundation_domain/

In 12c: ORACLE_HOME/user_projects/domains/bi/

For bipublisher folder:

In 11g: DOMAIN_HOME/config/bipublisher/

In 12c: DOMAIN_HOME/bidata/components/bipublisher/

Oracle BI EE Content Changes for 12c

This topic describes the difference in appearance for analyses and views after you migrate to 12c.

The following describes changes to analyses and views between 11g and 12c:
Change Description
The Gauge view shows a data column In 11g, the gauge view did not display unit data. In 12c, the gauge view displays the value of the gauge chart in the form of a data column below the chart.
Prompts are left-aligned in PDF files In 11g, when you export an analysis to PDF, prompts are center-aligned. In 12c, when you export the same analysis to PDF, prompts are left-aligned.
The bottom border of the title view does not span the page width In 11g, when you export an analysis to a PDF file, the bottom border of the title view spans the width of the page. In 12c, when you export the same analysis to PDF, the bottom border spans only the width of the title view.
Measures hidden in views In previous releases, if you marked a measure as hidden in the Column Properties dialog, then the measure was still displayed in views if the measure was part of the view's measure list (that is, not added to an edge of the view but used as intended as a metric). In 12c, a measure that you mark as hidden isn't displayed in views.

Changes to Catalog Structure

In releases prior to Release 11.1.1.9.0, when you first sign in to Oracle Business Intelligence, folders are automatically created for you to hold content that you eventually create. Examples of these folders are the _portal folder to hold personal dashboards and the _delivers folder to hold alerts. Starting with Release 11.1.1.9.0, these folders are not automatically created when you sign in for the first time. Instead, the folders are created when they are needed.

The following list shows the structure of the Oracle BI Presentation Catalog for a user before Release 11.1.1.9.0:

/users/<user>
/users/<user>/_delivers
   /users/<user>/_delivers/_deliveries
/users/<user>/_filters
/users/<user>/_portal
/users/<user>/_selections
/users/<user>/_savedcolumns
/users/<user>/_subscriptions
/users/<user>/_thumbnails
/users/<user>/_prefs
   /users/<user>/_prefs/deliveryprofiles
/users/<user>/_prefs/devices

The following list shows the structure of the Oracle BI Presentation Catalog for a user in Release 11.1.1.9.0 and later. Objects previously stored in the "_prefs" and "_subscriptions" folders are moved to the "_internals" folder. The "_deliveries" folder is merged with its parent folder "_delivers".

/users/<user>/_delivers
/users/<user>/_portal
/users/<user>/_filters
/users/<user>/_selections
/users/<user>/_savedcolumns
/users/<user>/_thumbnails
/users/<user>/_internals
   /users/<user>/_internals/subscriptions
      /users/<user>/_internals/subscriptions.atr
   /users/<user>/_internals/_deliveryprofile_profile1
      /users/<user>/_internals/_deliveryprofile_profile1.atr
   /users/<user>/_internals/_device_device1
      /users/<user>/_internals/_device_device1.atr
   /users/<user>/_internals/_favorites
      /users/<user>/_internals/_favorites.atr
   /users/<user>/_internals/cacheduserinfo
      /users/<user>/_internals/cacheduserinfo.atr
   /users/<user>/_internals/volatileuserdata
      /users/<user>/_internals/volatileuserdata.atr
   /users/<user>/_internals/defaultdevices
      /users/<user>/_internals/defaultdevices.atr
   /users/<user>/_internals/defaultdeliveryprofile
      /users/<user>/_internals/defaultdeliveryprofile.atr
   /users/<user>/_internals/userprefsxmlstore
      /users/<user>/_internals/userprefsxmlstore.atr

During upgrade, you can optionally remove empty folders within each existing user's home directory or relocate existing folders to their new locations. This change has no effect on folders for existing users.

To remove empty folders within each existing user's home directory or relocate existing folders to their new locations, specify the following elements within the <Catalog></Catalog> nodes in the instanceconfig.xml file:
  • To remove all empty folders: <CleanEmptyFolderInHome>true</CleanEmptyFolderInHome>
  • To relocate existing folders to their new locations: <CoalesceHomeDirectoryFolders>true</CoalesceHomeDirectoryFolders><

Note:

Revert the changes after completing the task.

Installing Oracle BI with Oracle Database Release 12.2.0.1.0

If you are installing Oracle BI 12c (12.2.1.4.0) on Oracle Database Release 12.2.0.1.0, you might see a "BI Startup failure" error message on the Configuration Progress screen.

To work around this issue:
  1. Stop the database listener by entering the following command:
    lsnrctl stop
  2. Open the sqlnet.ora file in an editor.
    By default, this file is located in the NEW_ORACLE_HOME/network/admin directory. You might also find the file in the directory that is specified by the TNS_ADMIN environment variable.
  3. Add the following line in the sqlnet.ora file:
    SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
  4. Save your changes and close the file.
  5. Start the database listener by entering the following command:
    lsnrctl start
  6. Try to install Oracle BI 12c (12.2.1.4.0) again.

Specifying Widths of Sections on Dashboard Pages

HTML style properties, such as those for specifying the widths of sections on pages in dashboards, behave differently in Oracle BI 11g than 12c.

You specify a size by setting the Size option in the Additional Formatting Options area of the Section Properties dialog when editing a dashboard page.

In Oracle BI 12c, if you want a section to have a certain width, don't select the Minimum Size option in the Size dialog.

Changes in the Footer of Target Analysis

The list of items that is displayed in the footer of the target analysis page in 12c is different as compared to that of the 11g system.

In 11g, from the Actions menu, click Analysis, and then click Other Analysis. The footer of the Target Analysis page displays the following options:

  • Return
  • Analyze
  • Refresh
  • Print
  • Export
  • Add to Briefing Book
  • Create Bookmark Link

In 12c, the footer displays the following options:

  • Return
  • Create Bookmark Link

Note:

You cannot edit the footer.

Change in the Location of the tnsnames.ora File

The location of the tnsnames.ora file is different for releases 12.2.1.3.0 and 12.2.1.4.0.

For release 12.2.1.3 and earlier:

Create or copy your tnsnames.ora file to:

[DOMAIN_HOME]/config/fmwconfig/bienv/core

For release 12.2.1.4 and later:

Create or copy your tnsnames.ora file to:

[DOMAIN_HOME]/bidata/components/core/serviceinstances/ssi/oracledb