Would it be possible to tell me how I can find out which is the universe a report is based? We have a couple of reports to migrate but I don’t seem to find out which report belongs to which universe.
If you can modify the report, you should be able to see / change the universe that’s linked to that dataprovider. That would work for small quantities - if you have a lot, I don’t have a quick answer…
I know you can modify the data source but there are also objects in the universe which are imported into the report and if I cannot see the universe name it is impossible to know to which universe these objects belong. It’s a strange situation but I have to come up with an answer as soon as possible.
My idea was (as you have said) to see what is the datasource and then go to designer and check the universe datasource. If the two are the same then all is fine. Now I’m looking for a better approach, if there is any. Maybe a VB script or a way to clearly show the universe.
In XI 3.1: Go into the CMC - Universes, and find the universe that you are talking about. Right click on it, and choose Tools - Relationships. You will get a list of everything related to that universe (Reports, Connection, Folder). This functionality didn’t exist in XIR2.
We can help you at no charge as we’re doing a limited beta on software that does just this; you’ll get a complete Deski metadata database and we’ll get your feedback on your experience using our tool. If this sounds like something you’d like to do, drop me a line.