We use custom connections, eg the same universe but in supervisor we set different connections up. You could set one group up (in supervisor) for each schema you would want, maybe use a different login in these connections to default to the correct schema.
You do this in supervisor by selecting the unverse at the group level, choosing a new connection. Other groups wont change, unless by inheritance (eg, lower groups). In our set up we have a group per country, and each country points to a specific oracle instance. Schema should work the same
The nice part is you really only need the one universe, supervisor / repository handles the rest…
Good luck,
Brent
using VBA
Hi,
We are using BO 5.0.2 here and I am just trying to decide on how to do
something.
We have/are planning to have a number of otherwise identical sources of data - a
“yesterday” version, a “month” version, 4 “quarter” versions, and also
associated Development, 2 Test versions, and a “play” version of the data.
These “versions” will be basically a snapshot of the data at a point in time,
and the requirement for so many is as specified by our users.
My initial idea is to set these all up as otherwise identical universes pointing
to different schemas in our oracle database.
We want to be able to have a single report which we can move from one universe
(or one version of the data) to another. Now, of course using the client we can
do that manually, but we would like to be able to do it via the VBA, and I can’t
see a property or method in the documentation which allows us to do this. We
can, of course, get the name of the universe via the Data Provider objects’
“Universe” propery or “UniverseName” property, but these are readonly.
So my question is:
- Does anyone know of a way to do this?, and 2. Is this the right way to attempt this - should I not be looking at separate
universes?? Is there a better way???
Of course, we could just have 9 copies of each report, but we already have 160
reports - to then multiply this by 10, and accept the associated maintenance
headache doesn’t seem very wise to me…
Any information greatly appreciated,
Regards,
Richard.
Listserv Archives (BOB member since 2002-06-25)