Single Repository vs Multiple Repositories

663712

Hello All,

I wanted to collect your inputs about what you think about implementing projects with Single Repository vs Multiple Repositories.
Does any approach have any special benefits?
Also has anyone setup Multiple Repositories on one BI server (OS is Solaris 10)?
Please let me know.

Thanks,
Micros

631335

I'm going to write a document about this sometime in the future.
Right now these are some basic steps:

1. Deploy a new version of analytics application on OC4J using the analytics.war on $ORACLEBI/web/
2. Edit file $ORACLEBI/oc4j_bi/j2ee/home/applications/analytics_<new>/WEB-INF/web.xml and change value for "oracle.bi.presentation.sawserver.port"to 9711
3. Add new repository on NQSConfig.Ini and restart BI Server
4. Create a new entry on $ORACLEBI/setup/odbc.sh as a copy of AnalyticsWeb, that should point to the new repository
5. Create a new catalog folder on $ORACLEBIDATA/web/catalog
6. Create a new instanceconfig.xml and add <Listener port=”9711″ />after the <DNS .../> entry.
7. On the new instanceconfig.xml change the Catalogpath to point to the new catalog folder created on step 5, and DNS to the one created on step 4
8. Create new scripts to start the sawserver with parameter the complete path to the new instanceconfig.xml.
9. Restart OC4J and BI Server and start the new Presentation Services with the scripts you made.

This is not a complete guide but the outline of the procedure. I 'm planning to make it complete sometime (if I find some free time)
You can also check the following links
[http://www.be-ice.eu/2007/09/11/managing-multiple-presentation-services-on-the-same-unix-box]
[http://bvellinger.blogspot.com/2008/01/obiee-10132-and-multiple-presentation.html]

Giorgio

663750

hello Micros,

If you have small project its beneficial to use Single repository

and the main advantage to have a Single repository is the execution speed ,

If you are using multiple rep its difficult to merge them and the speed is very low

631335

Hello Micros

I have made an installation with one BI Server with multiple repositories, served by multiple presentation services, on Oracle Unbreakable R4. It is a little bit tricky but it works.

663712

Can you share how you did it? What was the tricky part?

631335

I'm going to write a document about this sometime in the future.
Right now these are some basic steps:

1. Deploy a new version of analytics application on OC4J using the analytics.war on $ORACLEBI/web/
2. Edit file $ORACLEBI/oc4j_bi/j2ee/home/applications/analytics_<new>/WEB-INF/web.xml and change value for "oracle.bi.presentation.sawserver.port"to 9711
3. Add new repository on NQSConfig.Ini and restart BI Server
4. Create a new entry on $ORACLEBI/setup/odbc.sh as a copy of AnalyticsWeb, that should point to the new repository
5. Create a new catalog folder on $ORACLEBIDATA/web/catalog
6. Create a new instanceconfig.xml and add <Listener port=”9711″ />after the <DNS .../> entry.
7. On the new instanceconfig.xml change the Catalogpath to point to the new catalog folder created on step 5, and DNS to the one created on step 4
8. Create new scripts to start the sawserver with parameter the complete path to the new instanceconfig.xml.
9. Restart OC4J and BI Server and start the new Presentation Services with the scripts you made.

This is not a complete guide but the outline of the procedure. I 'm planning to make it complete sometime (if I find some free time)
You can also check the following links
[http://www.be-ice.eu/2007/09/11/managing-multiple-presentation-services-on-the-same-unix-box]
[http://bvellinger.blogspot.com/2008/01/obiee-10132-and-multiple-presentation.html]

Giorgio

663712

Awesome! Thanks

David_T

Wow. After all that, no points for Giorgio?!

667465

Hi Giorgio
Do you have the document, since i have tried almost everything but i am still not able to do it.
Here is the link where i have written all the steps please correct them if you find any mistake or please add steps if in case you find it missing.
link : 3715965

I badly need to try this, because people dont believe that this can be actually done.

thanks