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.