Learn step-by-step instructions for how to create a Business Intelligence Consumer Services (BICS) connection and then use it to connect three BusinessObjects reporting tools: Web Intelligence, Design Studio, and BusinessObjects Analysis, edition for Microsoft Office, to an SAP BW BEx Query.
By reading this article, you will learn:
- How to create Business Intelligence Consumer Services (BICS) connections using the Information Design Tool (IDT)
- A step-by-step process for connecting SAP BusinessObjects client tools to SAP BW using a BICS connection
A Universe is the Semantic Layer that resides between the database and the end user, providing business representation to the technical data structures. The Information Design Tool (IDT) is an SAP BusinessObjects metadata design tool that enables designers or developers to create and manipulate metadata from various data sources and to create Universes. Universes are manually created using the IDT and are saved in the SAP BusinessObjects repository with the file extension UNX. The Central Management Console (CMC) helps create and manage SAP BusinessObjects platform users and groups, and enables publishing, organizing, and defining security levels for all BusinessObjects platform content. The CMC also enables managing servers and creating server groups.
These detailed step-by-step instructions show the process for setting-up connectivity between SAP BusinessObjects client tools (Web Intelligence, Design Studio, and BusinessObjects Analysis, edition for Microsoft Office—from here on, simply referred to as Analysis Office) and SAP BW Business Explorer (BEx) Queries. Using these connection steps will help you alleviate performance bottlenecks and, by learning design best practices for connecting SAP BW queries, you can avoid major performance challenges.
How to Create a BICS Connection
In this section, we show the steps for creating a BICS connection. BICS connections can be created by using either the SAP BusinessObjects Information Design Tool (IDT) or the Central Management Console (CMC).
The IDT is an SAP BusinessObjects metadata design tool that enables designers to extract, define, and manipulate metadata from relational and OLAP sources to create a Universe. The CMC is a web-based tool that helps administrators manage the SAP BusinessObjects platform.