Full Catalog Migration in 11 G

 Full Catalog Migration

1.       Copy Catalog

Go to your OBIEE 11g installation folder … OBIEE Home >> instances >> instanceX >> bifoundation >> OracleBIPresentationServicesComponent >> coreapplication_obips1 >> catalog >> then choose catalog and copy catalog

When catalog is moved from one Linux environment (or windows environment) to another, create a zip (tar) copy of the catalog and then move this zip(tar) file to another Linux environment (windows environment). Without doing so there may be a possibility of missing the reports which does have long names.

WinScp also can be used in case if the files are getting moved from windows to Linux environment (whether the catalog is zipped or not). Recommended approach is to zip/tar catalog folder then ftp/winscp in binary mode to target destination and then unzip/tar.

Syntax for zip/unzip and tar is as follows

zip -r archivefile1 -This command copies the current directory, including all subdirectories into the archieve file

unzip archivefile1.zip - This command extracts the files from the zip file

tar -cvwf home.tar home/ - This command create a tar file named home.tar in the directory you currently are in of the home directory

tar -xvwzf myfile.tar.gz - This  command uncompress (untar) the myfile.tar.gz file in the current directory

2.       Open Fusion EM (Enterprise Manager) http://machine_name:7001/em and provide user credential.

c.       Go to Business Intelligence > coreapplication >Deployment Tab>Repository

d.      Click on “Lock and Edit Configuration” (Click close on the popup window appears)

3.       Once it is locked, choose BI Presentation Catalog section, the section shows the current location of the catalog used by Presentation Services. This section is used to change the location of the catalog or to share the catalog by pointing to a shared location.

The acceptable syntax is as follows: '/net/machine/disk3/sharedcatalogdata' or:'$ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog'.

Change the path to point to new web cat location e.g. $ORACLE_INSTANCE/SampleAppWebcat in the BI Presentation Catalog section then click on “Apply” , once applied then click on ‘’Active Changes’’.

4.       Then click on ‘’Close’’ once activation is confirmed

5.       Then click on “Restart to Apply Recent Changes”.

6.       Then click on “Restart button” to restart the services and new RPD will be deployed.

OBIEE 11g - Flash Player 10.1 required

OBIEE 11g - Flash Player 10.1 required

To display graphs as Flash objects in your browser, you need to have Adobe Flash version 10.1 running.
If you do not have this version, what you will see when you open up a Dashboard page or Analysis containing graphs will be something like this:

Dashboard page with graphs not displaying

So, you need to upgrade to Flash Player version 10.1 or install it if you don't have any version of the Flash Player installed.

Browse to http://www.adobe.com/software/flash/about/ and you will be able to see which version of the Flash Player you have installed.

Adobe Flash Player Information Page

To download and install the latest version, 10.1, browse to http://get.adobe.com/flashplayer/

From there, download and install the Flash Player.

After the installation completes, reload your Dashboard page, and the graphs should display correctly now.

Dashboard page with graphs displaying in the Flash format

This is the release note section:

The Adobe Flash Player is a cross-platform browser-based application runtime and is required for rendering graphs and scorecard objects in your browser.
Users must have Adobe Flash Player version 10.1 or above installed on their browsers in order to correctly view all graphs and scorecards generated by Oracle BI EE. Users can obtain information