How can I re-associate a WebI report with a universe in XI?

building reports crystal reports
1

I created a number of WebI reports in XI, dropped the universe they were created from, then re-published the same universe. The reports now return a “Universe not found. See your BusinessObjects administrator. (Error: WIS 00501)” error. Is there a way to re-associate a report with a universe?

ronpadz :us: (BOB member since 2005-09-14)

2

Did you find the solution? I’m having a similar problem.

tendulkar :india: (BOB member since 2004-03-15)

3

Sadly, a WebI report cannot be reassociated with another universe – even if the new universe has the exact same name. The association is with an underlying global unique identifier (invisible to the developer/user) rather than the universe name itself. This is a horrific and short sighted “feature”. I know this to be true in XI release 1 but cannot attest to whether or not this remains true in release 2. :wah:

ronpadz :us: (BOB member since 2005-09-14)

4

This is an issue inherited from WebI 2.x to 6.x

The “universal identifier” is none other then the universe_id UNV_X_UNIVERSES and the UNV_% tables in the repository. (2.x-6.x)

This is the primary key used to store the universe into the database.

Now, you can try and use the data from OBJ_M_DOCUMENTS and OBJ_X_DOCUMENTS to try and find which universe_id the wqy or wid is pointing to. Alter the primary key of your new universe to the old primary key and you should be fine.

!!!NOTE: Altering the repository using SQL may get the support people in BO very upset. Please back up your database before you try and attempt anything like this and if it doesn’t work, restore it back to the original state. I do not recommend it if you do not have a development environment. (i.e. separate server, RDBMS, repository etc etc… actually, if you did have this setup, you will find that report migration from dev to prod will have this problem anyway as the universe id is usually different in dev and prod, seems like the id is not a seq number.)

jcupy :hong_kong: (BOB member since 2004-10-13)

5

jcupy-
Have you tried this in XI where the repository structure is entirely different than in 2.x thru 6.x?

ronpadz :us: (BOB member since 2005-09-14)

6

You are right. The structure is different. However, the universes are still stored in tables and the documents still accesses the “universes” via the primary key.

Unfortuately, I am just investigating the XI R2 upgrade myself so I can’t tell you all the exact table / field names… yet. :nonod: Perhaps some digging around or some other BO employees can help you out there.

Good luck :stuck_out_tongue:

jcupy :hong_kong: (BOB member since 2004-10-13)