RE: SSO Multiple SAP BW Sources via BICS
I have a BI 4.1 system setup which connecs to SAP BW via BICs. I will require the user to be able to connect to different source systems for example, in the BI 4.1 UAT system if they will need to be able to connect to SAP BW Dev or Prod systems as and when required.
I am thinking of setting up the BI 4.1 system so it has authentication setup with SAP BW Dev or Prod. The BICs connection will have SSO. In turn if the user logs in using the SAP BW Dev user e.d. DEV~100\USERA then they will connect to the Dev system. If they use the user PRD~100\USERA then they will connect to the Production system.
Does anyone have any concerns with this? At the moment we use XI 3.1 universe to connect to SAP BW and we can use manage access restrictions at the universe level to switch access if required – so we need a way to do this using BICs.
This setup will not work. A Webi quey based on Bics can connect to a single sap bw system. You have to consider installing different bo systems for every sap bw system you are using and setup the connection object to point to the appropriate sap bw system.