Change many WebI Data Providers to UNX universe - how?

server administration XI Server Discussion
1

Hi,
I want to change the data providers of approximately 1000 WebI reports to use a UNX universe instead of a UNV universe (all in the same repository).
The UNX Universe was converted from the UNV universe currently in use by the webi reports.

I understand that I could open each report and change the universe, but with so many reports to change, I am looking for some automatic way to do that.

My questions:

  1. Is there a tool to change the universe used by webi reports (kind of a batch process)?
  2. If I delete the unv universe and put a unx universe with the same name in the repository, will the webi report “know” that it should use the new UNX universe?
  3. Is there anybody who has done the same thing and has recommendations for me?

Your help is highly apreciatied.
Our System is BO 4.0.

leaneye (BOB member since 2012-01-26)

2

Not that I know of, its a manual effort, more here:-

http://wiki.sdn.sap.com/wiki/display/BOBJ/Conversion+of+the+relational+universes+in+BI+4.x,+from+UNV+to+UNX

I don’t even think you could do something with the SDK at this stage.

No, as the webi reports have no link with the unx universe.

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

3

Thank you for your response.
I thought so (that there is no batch process) but I was hoping for a faster solution…
I will post my experiences after the unx conversion - which will be in a few months…

leaneye (BOB member since 2012-01-26)

4

Sound good.

I would check the BI 4.0 SDK route, though, link here:-

http://www.sdn.sap.com/irj/boc/sdklibrary

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

5

Hi leaneye,
have you investigated unv->UNX conversion? Please share - thank you!

bsok (BOB member since 2009-01-26)

6

SAP is planing to give us a API which will convert the all the reports pointing to UNX universe. We just need to pass CUID or ID of the folder where all the webi Reports reside and old UNV CUID and new univers CUID.

nammu (BOB member since 2011-12-02)

7

I want a migration tool provided by SAP that does it, I see no need for a customer to code/program anything for something like that.

Andreas :de: (BOB member since 2002-06-20)

8

Hello nammu,

  1. Could you please provide the source of your sentence? Is it official (SAP) or unofficial?
  2. When SAP is giving us this API?

Thank you for the info!
Bart

bsok (BOB member since 2009-01-26)

9

SAP told us will give this API, sometime in SP6 . But i am not sure this API will be available for public. This may be the request base or type of support level.

nammu (BOB member since 2011-12-02)

10

Did you ever get this API? If so how did it work?

bcomer :us: (BOB member since 2010-02-25)

11

Any Update on this? Currently I am looking for a solution for this. I do not want to manually change 200+ user reports from unv universe to unx universe.

BO)_User :us: (BOB member since 2010-03-01)

12

I never got this answer. I am still looking for this answer. I am going live with BO 4 soon and this will be a task for it

bcomer :us: (BOB member since 2010-02-25)

13

Hi did you ever get this?

abductee :uk: (BOB member since 2006-09-05)

14

As far as I know (and I asked some SAP program managers last week) SAP still don’t provide a way to do this.

You can vote for it on the SAP Idea site here: https://ideas.sap.com/D25543

There are at least two 3rd party tools that claim to help you migrate WebI docs,(I haven’t tried them) APOS Migrator and GB&SMITH 360 view

There is support for doing it via the API, but if your report has prompts it makes the code quite complicated (you need to fill in the prompts and refresh the document as part of the process)

You can see the process here http://scn.sap.com/docs/DOC-45986

Hayden_Gill :australia: (BOB member since 2002-08-15)