Saturday, February 11, 2012

How to create a new Catalog in OBIEE11g

Hi
  1). Go to localDrive:C:\OBIEE11G\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
2). Open your instanceconfig.xml file
3). Find <CatalogPath> and </CatalogPath> tags
4). Write the new catalong name that you want to create (suppose sh_new) then your tag should look like this
<CatalogPath>C:\OBIEE11G\instances\instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalog/obirep</CatalogPath>
5). Save the file and start/re-start the BI presentation service
6). It automatically creates the obirep catalog, once we start our presentation service and you need not to create anything manually..



Note:
Catalog Manager is useful in managing your reports and give permissions to the users and folders..
As per the name implies you can understand that it's used to manage the catalog that you have...
The list of things that we can do with catalog manager are: (as per my knowledge)
1). Rename the report names, dashboard names, and other stuff
2). Used to give permissions for particular folders or particular objects for particular users..
3). copy and move the reports to other folders
4). copy and move the reports to other machine's catalog which are in network and accessible.
5). Can modify the XML for reports and prompts presents in this catalog if you know the XML

Via Em and Catalog manger careting new catalog is very strange.some times it works and some times not working its throwing like this error while crating in Catalog manager

file:///?\C:\OBIEE11G\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\obirep\root.atr could not be accessed.
file:///?\C:\OBIEE11G\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\obirep\root.atr could not be accessed.
also EM unable to create new catalog issues. so better to above suggested methods its works fine.

Thanks
Deva

       

No comments:

Post a Comment