Fastest way to change Universes for WebI reports

building reports webintelligence
1

Hi All,

I have some 255 Reports for which I need to change the Universes. Just that these Universes exist for different databases. We have one version of the Reports but 2 versions of the Universes. Is there a way to change the WebI Report Universes ( from one to another Version) rather than manually going into the Report Query properties and changing the universes?

Need an answer quite promptly.

Regards,
Kapil Uppal

kapiluppal :india: (BOB member since 2006-06-15)

2

As far as I am aware, it is a completely manual process. However sombody may say that it can be done through an API but I don’t know.

plessiusa :netherlands: (BOB member since 2004-03-22)

3

Hi

You should manually change your universe in the report and keep into the public folders and no other option other than this.

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

4

Do we win a prize for promptness then?

dessa :madagascar: (BOB member since 2004-01-29)

5

Its just like being back at school…:rotf:

Check out this rather clever method from Mr Rathbun, remebering to take back ups first…

https://bobj-board.org/t/106492

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

6

good reply, just hope its not too late.

dessa :madagascar: (BOB member since 2004-01-29)

7

You can also use the API/SDK to change the universe on a WebI document.

See attached sample for details.
webi_change_datasource.zip (31.0 KB)

darcstorm :philippines: (BOB member since 2008-07-22)

8

Hi,

Thanks for sharing, good to know there are a number of ways to do this…

Cheers,

Mark.

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