Monday, May 23, 2011

OBIEE 11g- Deploy RPD - Create New Catalog

Steps to deploy repository and create a new web catalog in OBIEE 11g
  • Go to http://{localhost}:7001/em and login
  • From left pane, expand Business Intelligence and click on coreapplication
  • Go to Deployment tab then Repository sub-tab
  • In the Change Center: click Lock and Edit Configuration
  • Click Close when you receive the confirmation message Lock and Edit Configuration - Completed Successfully.
  • In the Upload BI Repository section: Click Browse and navigate to the directory with the yourrepository.rpd repository. Select the yourrepository.rpd and click Open
  • Enter your-repository-password as password and click Apply.
  • (Optional: If you want to create a separate catalog; In the Presentation Service Repository section, you will have a  string like this one: $ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/SampleApp
  • Delete the default catalog- SampleApp in this case and enter a name that you want to give to your catalog e.g. MyNewCatalog you should have something like this $ORACLE_INSTANCE/bifoundation/OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/MyNewCatalog)
  • In the Change Center: click Activate Changes
  • Click Close when message Activate Changes - Completed Successfully message appears.
  • Go to Overview tab and click Restart. Click Yes to confirm restart.
  • Click Close when you receive the message Restart All - Completed Successfully.
  • Go to http://{localhost}:9704/analytics login to create reports in new rpd with Your-New-SA subject area.
More information in OBIEE 11g Documentation Libraray: http://download.oracle.com/docs/cd/E21764_01/bi.htm

Cheers!
Deepak

3 comments:

  1. Hi Deepak,

    I found this post very useful. I also wanted to know how to create a brand new web catalog to be used along with my rpd .

    One way I tried was by copying the contents of default Catalog like SampleAppLite to my new catalog folder "MyNewCatalog" and modifying them. But this is very tedious.

    Is there some easier and better way where I can create a brand new web catalog to be used along with a new rpd that I would like to upload in OBIEE 11g?

    ReplyDelete
  2. I followed the steps you have laid out...it worked...awesome and thanks.
    Quick question:
    What is the easiest way to migrate a RPD and a catalog from one 11g environment to another.

    I did the following steps.. let me know if there is a better way...

    After setting up the empty catalog... I archived the shared folders (setup at SA group level) from the source development server and unarchived it into the new server. It worked great for shared folders... not sure if this will work for user folder as well...
    It will be very useful if I can migrate the whole Catalog including the user folders...


    Our setup is, we have multiple server for development we start with default RPD, and then configure the new server with AD auth setup etc. Then I need to move all the changes from one server to another including the RPD and the catalog contents.
    This is how we plan to setup production also.

    Thanks
    Sundar

    ReplyDelete
  3. Hi Deepak,

    I found this post very useful.One thing in my directory structure i have path $ORACLE_INSTANCE/bifoundation but after that this path OracleBIPresentationServicesComponent/$COMPONENT_NAME/catalog/SampleApp is not available.

    Please help

    ReplyDelete