What is BICS connection?
Nathan Sanders
Updated on May 20, 2026
BICS connectivity is the recommended way for BI tools to connect to Business Explorer (BEx) queries on the SAP NetWeaver BW server. In this tutorial, you will create OLAP connections to connect to an SAP NetWeaver BW data source based on a BW server, a cube, and a BEx query.
How do I create a BICS connection in WEBI?
You can create a BICS connection in CMC or also in Information Design Tool. A connection can be created to a single BEx query or to an Info Provider. Login to CMC console → Select OLAP connection from the dropdown list. Click on a New Connection → In Provider list, select SAP NetWeaver Business Warehouse.
How CMC check OLAP connection?
Log on to the Central Management Console (CMC) in SAP BusinessObjects Business Intelligence. Choose OLAP Connections . Check whether a connection has been established to the BW system.
How can I create OLAP connection in IDT?
Creating a New Connection in IDT – OLAP To create a new OLAP connection, right-click on Project name → New → OLAP Connection. Enter the connection name, description and click Next. Next, select an OLAP middleware driver. It shows a list of all available OLAP data sources.
What is a BEx report?
SAP Business Explorer (SAP BEx) provides you the set of tools to perform reporting, query analysis to support strategic decision. This tool provides a lot of queries and report designing functions. The BEx Report Designer tool can be used to create formatted reports for printing and presentation.
What is OLAP and OLTP in SAP?
OLTP stands for Online Transaction Processing, and OLAP stands for Online Analytical Processing. As their names suggest, the difference is how you USE them. OLTP and OLAP are two different types of databases and two different ways of processing data. OLAP is designed to handle analytical queries in a database.
How do I create a report in WEBI?
Creating a New Report
- Navigate to Reports, Report Writer, and select New.
- Enter your user name and password, and click Log On.
- Click Document List.
- Open the New menu and select Web Intelligence Document.
- Scroll through the list of universes and select Report Writer.
How do I publish my IDT connection?
Right Click on connection name → Publish connection to Repository → Enter BO repository password → Connect → Finish → Yes. . cnx-local unsecured – If you use this connection it will not allow you to publish anything to the repository.
How do I change my IDT universe connection?
In the Data Foundation Editor, click the Connections tab, and then In the “Connections” pane, right-click the connection, and select Change.
