Creating New Web Catalog

Feeds:: Posts; Comments

« Lessons in Filters and the ‘is prompted’ operator

Calculating grand total as a column in Table View »

Creating New Web Catalog

April 8, 2010 by obieeone

I have been seeing a lot where people take paint or samplesales webcat and either cloning it or modifying it to make a new webcat. This has its issues and problems. For one, you inherit all the users and privileges that are there, especially if you were using and modifying this before you decided that it was not a good idea and that you should have a webcat unique for your area or application.

Why do all that work? There is a faster and better way to make a new webcat. Fastest and easiest way to make brand new webcat:

1. Modify ORACLEBIDATA_HOME/web/config/instanceconfig.xml. Change location of webcat to that of the new webcat. For my example, I changed from samplesales to testCat.

E:/OracleBIData/web/catalog/testCat</CatalogPath>

2. Restart Presentation Services

Thats it! Simple right. Well this is what is happening when you restart presentation services. Presentation Services looks at configuration and see that the webcat to use is testCat. It looks for webcat in the location specified to load. If it does not find it, it creates one for you.

Like this:

Be the first to like this post.

Posted in Presentation Services | 3 Comments

3 Responses

on July 7, 2011 at 9:23 am | Reply Hema

Hi Frank,

Is this applicable for OBIEE 11g also ?

I tried what you have suggested but Presentation Services (obips1) failed to start.

The exact steps I followed is :-

1. Removed the SampleAppLite folder under /instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog

2. Created an empty folder paint under catalog folder above

3. The modified the /instance1/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml.

to point to the paint catalog folder (empty)
/scratch/aime1/BIMATSMLR/BISFTWR/mw5368/instan
ces/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication
_obips1/catalog/paint

4. Then tried restating Presentation services but it failed to startup

Next I tried by copying the root folder and root.atr file inside the default SampleAppLite catalog folder to paint Catalog folder and restarting the Presentation services and it worked this time.

But of course I end up with same catalog as before only name being different.

Please help me out to create a brand new web catalog in OBIEE 11g.

Thanks,
Hema
- on July 7, 2011 at 1:20 pm | Reply obieeone
  
  I have never tried to see if this works in 11g; but, you could use Cat Manager to create new catalogs. I would create a new catalog using catalog manager locally, then move the new catalog completely over to the target system. Change the instanceconfig.xml to reference this new catalog and restart presentation services.
- on July 7, 2011 at 1:39 pm | Reply obieeone
  
  Actually after rereading your comment. I see the problem. You created the ../catalog/paint folder and left it empty and then set your instanceconfig.xml to this new paint folder. This confused the presentation services since this paint folder was there it presumes that the catalog exists. It then looks for the root directory and relevant subdirectories to load. These however do not exist as the folder is empty! What you should do is not create the folder beforehand and let the presentation services do it for you.