The below are listed steps that outline how to create OLAP BICS Connection for SSO access against SAP BW in IDT tool.
The similar steps could be applied for SAP Java Connector (JCO) connection used for relational UNX universe against SAP BW.
2. SAP SSO setup with Information Design Tool (IDT)
- Run IDT
- Insert session against repository by using SAP Authentication
(Make sure that user used to create repository session has all IDT rights setup in CMC)
- Create OLAP connection
- Select SAP BICS Client
- Set connection parameter
(Make sure that you set Use Single Sign On)
- Select Info Cube
(Or BEx query in the case that you selected SAP BICS Client in previous step)
3. Create WebIntelligence report with OLAP BICS connection
WebIntelligence is used as an example of BI4.0 client tool to explain necessary steps for setting SSO against SAP BW
Once BICS connection is created and available in the repository, user can use it to create WebIntelligence document/report.
The below image shows available data source options for WebIntelligence document/report. Bex is one of the options
and that means utilization of OLAP BICS connection.
4. Create WebIntelligence report with UNX universe
The steps to setup SAP Java Connector (JCO) for UNX universe are similar to those outlined for BICS connection.
JCO connection has to be created inside of the repository. This connection is using Data Federator that is running on server
side which the reason why it cannot be local connection.
Once UNX universe is created by using JCO connection, users will be able to used it to create WebIntelligence documents/reports.
References and links
How to setup SSO against SAP BW with SAP BO BI4.0 Common Semantic Layer (UNX) or BICS
Import SAP BO BI4.0 certificate into SAP BW
Setup of SAP SSO Service in SAP BO BI4.0 CMC
Generate keystore and certificate for SAP BO BI4.0