change multiple BICS connections to point a single BICS connection for all reports in BI 4.1

[kkbonam]

Hi,

We are in process of BOBJ Upgrade from 4.1 to 4.2 SP5, as part of this migration we want to change all our existing multiple BICS connections to point a single connection. We have around 300 reports which would take much time to change manually for each report and we want to avoid this manual work.

So do we have any mass update thing like changing multiple connections to a single connection ? Need your help and inputs on this please ?

Our Current environment: BOBJ Dev -> BOBJ Prod

New 4.2 Environment is: BOBJ Dev - QA - Prod.

Down the line we want to develop/changes only in Dev and promote across QA and PROD. As part of this we moved our existing BOBJ reports content from BOBJ Prod to existing BOBJ Dev 4.1 and started cleaning. In this regard, we need suggestions on how to change multiple connections to a single BICS connection.

Thank you,

Kiran

[sven_oehme]

Hi Kiran,

In projects were we always have done this, it was part of changing the authorization type to SSO. So that we also was forced to switch from mutiple Enterprise connections to a single SSO connection.

The easiest way to do this, is to let the older connections be as they are and to handle this case with permissions.

olderreports (for examle your 300) ---> multiple connections

new reports -----> single connection

You can do this the following way. Put a permission like "no access" on the folder of the old connections. And put a different permission like "full access" directly on the connection. So that is possible that nobody is able to see the old multiple conections, it is not possible to build new reports on it. But it is possible to still use the connection in background for the existing reports.

A second way is to seach for a SDK application that can handle this mass movement automatically.

Greetz

Sven

[kkbonam]

Yes, we don't have any readily available solution from SAP on this process. We need to do it manually and this is only option we have as of now.

Thank you,

Kiran

[marton_retfalvi]

I believe you will need to do it manually.