cancel
Showing results for 
Search instead for 
Did you mean: 

WebI report BICS connection promotion

vinayakgole
Active Participant
0 Kudos

Hi,

We have a webi report based on a BICS connection which in turn connects to a Bex query in the backend. The report was developed in the development environment with the details as below.

SAP BW system: BID

BICS Connection: Conn_BID

Report: Test_rep

When this report is promoted to the quality environement, could you please let me know how to point the connection to quality?

SAP BW system: BIQ

BICS Connection: Conn_BIQ

Report: Test_rep

We promoted the report but it is still pointing to Development (BID).

Thanks and regards,

Vinayak

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Vinayak,

Open IDT in your quality system
Insert a session using "Repository Resource"
Select the connection "Conn_BID"
Click on "Edit" button
Change the client/system number/application server accordingly.
Save and test the connection.
Refresh the report and confirm if the data is correct.

Thanks,
Vivek

vinayakgole
Active Participant
0 Kudos

Thanks Vivek,

Will this have to be done everytime we promote a set of reports?

Seems cumbersome.

Regards,

Vinayak

Former Member
0 Kudos

Sure No problem Vinayak.

And yes, you have to do this task everytime you perform such activity. We don't have any such option which allows the updation of connection information at the time of migration and logically speaking it is not even possible.

Thanks,

Vivek

Former Member
0 Kudos

Hi Vinayak,

You can move the connection from DEV environment to TEST environment using LCM. And then you need to change the server details accordingly in TEST environment. This is one time activity and this connection always be there in TEST environment. So next time onwards when ever you migrate the reports from DEV to TEST, you need to change the source for each report to the TEST connection after migration. This activity is for every time you migrate the reports.

Hope it helps you...!!

Answers (1)

Answers (1)

IngoH
Active Contributor
0 Kudos

Hi,

you should be able to move the connection from DEV to QA using the Lifecycle Managment environment and change the server details

regards

Ingo Hilgefort