Hi,
I have some 100+ webi reports based on universe A. Now we have got a newer universe B, which is a replica of universe A but contains less data, hence faster to execute reports based on this. Now, in full client, we can directly change the universe name in VIEW DATA option. Is there anything similar in webi? Otherwise it would be a pain to recreate all those 100+ reports.
Please suggest. We use BO XI R2.
arnabpaul2k (BOB member since 2008-04-02)
what do you mean when you say it contains less data? if it is replica of A when can you change A to look like B and not have to worry about changing reports at all
sfaridi 
(BOB member since 2002-08-29)
you can change the universe refferred to in each report individually but I don’t know how to do all reports in one go.
If you open the query for the report between the toolbars and the universe classes is a tab which is normally selected to data. the other tab is for properties and on that tab you can change the universe.
This is also where you would change the name of a query after it has been saved.
thanks
katy
kt_beck (BOB member since 2008-02-01)
Changing a source universe is a feature of XI R2 (it was not in R1 if my memory is correct). I have not seen any scripts to do it, so you’re looking at a manual update of each report. Here’s a suggestion that will save you that effort:
This is sort of like the famous “shell game” where you are moving things around under the covers. Be sure to make a backup (BIAR file) of the reports and universes so you have a fall-back position if this does not work as expected, but I think it should.
Dave Rathbun 
(BOB member since 2002-06-06)
Thanks a lot… this will solve my problem!
@ Shoaib, the previous universe contained historical data while the new universe contains only current data. When I say identical, it’s a bit wrong, I should have said, identical classes/objects. The current universe contains a new fact table which is structure-wise same as the original fact table but contains only the current data. While the original fact table in historical universe contains 19million records, the current fact contains only 2 million records. This makes the queries run faster.
arnabpaul2k (BOB member since 2008-04-02)
hi Dave,
What you have told works perfectly, this is what we have done recently and it worked for me.
thanks,
Reddy69 
(BOB member since 2007-10-12)
Hello all,
I’m about to embark on a fairly irreversible, (i.e. I want to get this right first time!), combination of universe development and 6.5-XI upgrade.
My question is if I take a copy of a universe, re-arrange the class structure and move objects between classes and then save it as the original universe, will my existing reports like it?
I’m assuming they will because the object ids will remain the same, whereas repointing my existing reports to the new universe won’t work because the class structure will be different.
Please can somebody confirm?
Thanks, Steve
steveayres 
(BOB member since 2006-11-23)
Not sure to be honest.
But I think I’d be inclined to create a dummy universe with a few objects and classes.
Create a couple of reports against it.
Make a copy of the universe and keep it out of harms way
Re-arrange objects accordingly, export universe, delete local version (not the backup!).
Then launch reports and see what happens.
Diane1969 (BOB member since 2007-01-18)
so long as you dont delete and recreate objects existing reports should remain happy
sfaridi (BOB member since 2002-08-29)
Thanks Diane, I have been doing that in the pause and it all seems to be okay.
sfaridi, I agree.
I couldn’t help but feel I have overlooked something important but maybe it’s just a crisis of confidence. :?
Steve
steveayres (BOB member since 2006-11-23)
This hasn’t worked quite as expected. 
New reports are fine but reports that I have migrated and converted seem to be tied to the original 6.5 filename of the universe. When I save my new universe as the old one and export it, that link to the original 6.5 filename is lost and the reports don’t like it.
Not sure what to do now. :?
steveayres (BOB member since 2006-11-23)
An update for those who are interested. It seems I have to:
Take a copy of the new universe.
Save the old universe as the new universe and export.
Point the reports at the ‘new’ universe.
Save the copy of the new universe as itself and export.
Save the new universe as the old universe and export.
Point the reports at the old universe.
I have about 140 reports - bad enough but not catastrophic. 
I’d be interested to know why my reports are looking for the old eight character 6.5 filename though. 
If you’re west of me, say goodbye when you leave work! 
steveayres (BOB member since 2006-11-23)