How to implement multiple connections for a single universe?

building semantic layer
1

  1. Create two group g1 and g2 with one user in each group.

  2. Create two Database d1 and d2 (both are identical in structure)

  3. Create two new ODBC connection
    a.con1 =>d1 database
    b.con2=>d2 database

  4. Create two new connection using Designer
    a. group1 =>con1
    b. group2=>con2

  5. Create a Universe using con1

  6. export the universe to Repository

  7. Login to Supervisor

  8. select group g1 and change the connection of Universe to con1

  9. select group g2 and change the connection to universe to con2

  10. Login as user1 i.e member of g1 group and create a report.

  11. Save the report. This displays the data stored in database d1

  12. Login as user2 i.e member of g2 group and create a report.

  13. Save the report. This displays the data stored in database d2

The above works fine with BusinessObjects 6.5.1 version.
How can we achieve the same using our new version i.e Business Objects XIR2
:hb:

rakeshs13 :india: (BOB member since 2006-08-23)

2

i think you should try the same steps as you have done for BO 6.5.
But in BOXIR2, there isn’t any Supervisor. There is a CMC.

Kindly share your experience after doing this.

Regards,
Izhar

izhar :pakistan: (BOB member since 2007-07-11)

3

With XI R3.0/2.0 you apply those so called universe overloads via the Universe Designer Module. Same functionality!

Andreas :de: (BOB member since 2002-06-20)

4

Search in this forum…

Check this thread to get some idea:
https://bobj-board.org/t/100260/10

BO_Chief :us: (BOB member since 2004-06-06)