Linking reports to renamed Universe

building reports webintelligence
1

Hi,

I have several reports which were running against a universe. I changed the name of the universe and would like to point the reports to the new universe. Nothing about the universe has changed other thanthe name it is saved as. How can this be achieved?

Thank you!

VACoder :us: (BOB member since 2014-06-25)

2

i’m not exactly sure on this one but i think that you can rename the universe without changing its unique identifier so you may not have to do anything if you do that possibly

but if that’s not the case or maybe you made a copy when you renamed then you’d just go into the webi document right click on the dataprovider and do change source. if you don’t have that option then you need to have different access in cmc.

then you pick the new universe and a wizard will start, which compares the original universe objects involved in each data provider with the objects in the new universe to find matches. you can then resolve and unmatched objects and override the preselected matches or discard objects included in the original query.

then you can save the query without refreshing, discard the changes, or refresh, which saves the query like option 1, but you’d still need to save the document to actually save the query.

erik.stenson :us: (BOB member since 2012-07-30)

3

So After I posted I poked around a bit and discovered that if I had used CMC to change the name the ID would have stayed the same and i would have never known the difference.

What I did, the wrong thing, was ‘Save As’ in Universe Designer to change it’s name and then I exported it to CMC and THEN I deleted the old universe. Hard lesson. But I only had to build a handful of new reports so all is well.

Thanks for your reply!

VACoder :us: (BOB member since 2014-06-25)

4

I am pretty sure you can just update the SID in your CMS database - beware though… that’s probably not advised.

Thomas Evans :new_zealand: (BOB member since 2013-10-17)

5

Painful lesson, A Save as action generates a new CUID, as you have found.
The worst thing you could have done is deleted the “old” universe, as you could remediated, via one of the methods, below:-

There is a useful trick here, for dealing with the issue here, providing you haven’t deleted the old universe:-
https://bobj-board.org/t/106492

You could also repointed the queries in Webi, again, providing you hadn’t deleted the old universe :slight_smile: .

Mak 1 :uk: (BOB member since 2005-01-06)