I’m looking for some help. We incorporate Business Objects (version 4.1.5 currently) into our product. We are not using a repository. The users process their data, load it into their SQL Server database, and use a program written in VB to view canned reports and create ad hoc reports.
We have decided to start processing user data at our site, and now will have multiple databases and multiple sets of reports. The problem is that all the reports point to the same universe, and that universe can only point to one database. We need to find a way to have multiple universes and multiple sets of reports. I know the easy answer is to make a copy of the universe, point it to the correct database, and change the reports to point to the new copy of the universe. However, there are over 60 reports, and the reports have an average of two or three queries each.
We are looking for a unique way around this situation. I looked at the BO 5.0 object model and found the way to the universe for a query, but it is only readable. Can anyone help?
Thanks,
Marian Cooney
Technical Development Advisor
McKesson HBOC
Malvern, PA
You can set up custom connections under Supervisor, eg different connections for different groups - like one could be Data-US and another could be Data-ASIAPAC…these connections could then point to different databases, as long as they supported the universe structure…
We had to set up some users differently to support this, tho… users that may need to use more than one database end up w/ more than one login…
Make sense?
Brent
I’m looking for some help. We incorporate Business Objects (version 4.1.5
currently) into our product. We are not using a repository. The users
process their data, load it into their SQL Server database, and use a
program written in VB to view canned reports and create ad hoc reports.
We have decided to start processing user data at our site, and now will have
multiple databases and multiple sets of reports. The problem is that all
the reports point to the same universe, and that universe can only point to
one database. We need to find a way to have multiple universes and multiple
sets of reports. I know the easy answer is to make a copy of the universe,
point it to the correct database, and change the reports to point to the new
copy of the universe. However, there are over 60 reports, and the reports
have an average of two or three queries each.
We are looking for a unique way around this situation. I looked at the BO
5.0 object model and found the way to the universe for a query, but it is
only readable. Can anyone help?
Thanks,
Marian Cooney
Technical Development Advisor
McKesson HBOC
Malvern, PA
In a message dated 00-02-01 14:32:51 EST, you write:
We are looking for a unique way around this situation. I looked at the BO
5.0 object model and found the way to the universe for a query, but it is only readable. Can anyone help?
Since you are not using a repository, I am assuming that you are using personal or shared connections, correct? If you are using ODBC, then your application should be able to determine who is logged in and therefore the appropriate settings to use. You could then update the ODBC settings to point to the proper data source.
In other words, leave the universe alone (and therefore the report as it was) but update the database source under ODBC.