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.

A.1 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 appear different in 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.

A.2 View Display Error: Invalid Column Encountered in Orders Outstanding Report

You might see a View Display Error message that states that an invalid column was encountered when loading the Orders Outstanding Report in 12c. This error is displayed because the ID of the column that causes the error exists in the XML definition of the report, but not in the subject area table. You must manually edit the XML definition and remove the invalid column.

A.3 Visual Cues in BI Composer Appear Same in Regular and Accessibility Mode

Visual cues, such as icons or check boxes, displayed on a BI Composer wizard page in accessibility mode are the same as displayed in regular mode in Oracle BI EE 12c. 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.

A.4 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 Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.

A.5 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

A.6 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/

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

A.8 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.