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
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
We promoted the report but it is still pointing to Development (BID).
Thanks and regards,
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.
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...!!