Re-pointing Identical reports to different universes

building reports webintelligence
1

Not sure if this is possible on BO, but I have a number of Webi reports, and I want to point some of them to a new universe. I know we can go into each report and re-point, but we have over 40 reports to do!! and this will happen quite frequently- So I would like to know of a quicker way.

Basically, I have identical reports which go into region specific folders, each region sits on an identical universe but connected to different databases! Eg

Folder = UK - Report 1 - TradeUniverse - London Connection
Folder = France - Report 1 - TradeUniverse - France Connection
etc

Any help appreciated.

sabre1 (BOB member since 2008-02-27)

2

Check out this rather clever suggestion by Mr Rathbun:-

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

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

3

You could also use the Report Engine SDK to modify the WebI document to use the new universe.
Attached is a sample using Java.
webi_change_datasource.zip (31.0 KB)

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