connection used by templates...

[saramaia]

Hi!

I made a quite bit complicated report and saved it...

If i open it later, the report will always connect to the universe i generated it from, right??

But what if the universe has 4 connections to 4 different databases...
What will happen in the report?
If I only have the BusinessObjects module (and not the Designer) can i make that report using other connection in the universe other than the one i generated the report with??

Hope i made myself clear...

Thanks

Sara

 

[blom0344]

Hello Sara,

There are a number of steps involved in the transfer of data from source to report. A typical universe has connection to 1 database (unless you are working with linked universes). One of the parameters you set for a universe is the connection (to test-database, life database etc. ) If you want the universe to work upon a different database you can reset the connection it works with , for instance with a connection to a testdatabase. This will work, provided the data-structure is exactly the same (tablenames, fieldnames). Resetting the connection is done in designer. You will not accomplish this from within the report itself. There must be ways around this, cause in the past I worked with reports that ran both on life or test environment. I recall however that with old 4 version there was a problem with reports using multiple data-providers (you had to run every data-provider seperately from within the report) T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[skrandel]

I gotta be honest. I'm not sure that TBLOM's answer answered your question or not.

A universe cannot have more than 1 connection, so you really don't have to worry.

You can have a report that has data in it from multiple universes. Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com