Is there any method to find out the database connection in the “BOI USER Module”.
We have a test server and a production server both of which consists of same data. Recently we have changed the connection from test to production. Now I want to ensure that the User module is pointing to the right server.
I changed the connection string in the universe(Designer module)and exported the universe . Do I need to do some changes in the User module too?
I created a document and created a cell with a formula in it that displays the ‘TEST’ vs the ‘PROD’ environment. Here is the formula - see if it works for you with some minor tweaking.
=If Match(Connection(DataProvider(<Show Group(Query 3 with MFIExpoR)>)),“regt”) Then “Using Test Database” Else “Using Production Database”
Javed Maqsood
Context Integration
Aravind, G (GEP, Contractor) wrote:
Hi,
Is there any method to find out the database connection in the “BOI USER Module”.
We have a test server and a production server both of which consists of same data. Recently we have changed the connection from test to production. Now I want to ensure that the User module is pointing to the right server.
I changed the connection string in the universe(Designer module)and exported the universe . Do I need to do some changes in the User module too?
I am currently investigate the impact on changing Business Objects’ connections from synchronous mode to asynchronous mode. It would be highly appreciated if anyone in the list could provide any information on how to decide fetch size to get optimal performance and at same time to get rid of “fetch out of sequence” error.
If somebody can also provide any information on what are the benefit of keeping connection for all the session or disconnect after each transaction, that will be great help.