Changing universe behind a report if the orig uni is deleted

We have made some big changes to the database and the universe, but a few reports were left out. Now I have 3 reports that look at the same universe, but the old universe is deleted and new one with same name and connection is published. I am aware that the universe ID has changed, but as a supervisor, I should be able to change the universe ( from my experience with other reporting tools).

Anyone knows how to do this? Do I need to work at the database level directly?

Thanks


chiragk :us: (BOB member since 2003-10-22)

You really have very few options here.

You will need to save each tab of the report as a template. Make sure you save all the variables.

Then you will have to rebuild the Data Providers and then apply all the templates. You’ll have to do some checking to make sure it’s all OK.

The problem is that you can’t assign a DP to new universe if the old one isn’t there.

There isn’t any method that I know of to fix this at the repository level, either, since all the info is stored in the .REP file.


Steve Krandel :us: (BOB member since 2002-06-25)

Hi Steve,
I want to understand this issue. I believed that the universe at the report level gets identified by the Universe Short name/Long Name. If we create a report with a universe X and if we delete and recreate universe X shouldn’t our report point to our new universe automatically.

      Basically when we used to get these sort of issues while renaming Universes(while standardizing) we used to save a local copy of the universe with the old name, so that the report allows us to open the window to change the Universe in the data manager. May be my understanding is wrong. Can you throw some light on this.

Thanks


Ashokkumar (BOB member since 2004-05-20)

I do have a local copy of the universe saved. Would I be able to use this to open the .rep file?

Thanks,
-Chirag


chiragk :us: (BOB member since 2003-10-22)

I was able to use the old copy of the universe. I logged in into BO in offline mode. Then replaced the copy of the universe (in …Application Data/BO/Universe) with old copy, and was able to open the document. I was able to change the universe to our QA universe and then later changed it to PROD.
Phew!!!
Took long but less than rebuilding it would have… :shock:


chiragk :us: (BOB member since 2003-10-22)

Chirag,
You didn’t say you had a local copy. That clearly saved you alot of effort.

If you have a local copy and a general supervisor id, you can fix most anything.


Steve Krandel :us: (BOB member since 2002-06-25)

I’m in UK right now and jet-lag is killing me.


chiragk :us: (BOB member since 2003-10-22)