How to Use BICS to Connect SAP BusinessObjects Client Tools to SAP BW (Part 2)

  • by Shreekant W. Shiralkar, Global Head, SAP Analytics CoE, Tata Consultancy
  • Deepak Sawant , Leader of SAP BW Center of Excellence, Tata Consultancy Services Ltd.
  • Jyoti Jain, Associate at Tata Consultancy Services Ltd.
  • November 7, 2016
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.
Learning Objectives

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
Key Concept
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.

For more details about Business Intelligence Consumer Services (BICS) connections and best practices for designing BEx Queries, refer to our other two related BI Expert articles, “How to Use BICS to Connect SAP BusinessObjects Client Tools to SAP BW (Part 1)” and “Quick Tip: Best Practices for Designing SAP BW BEx Queries and a Comparison of Connection Options.”

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.

Shreekant W. Shiralkar

Shreekant W. Shiralkar is a senior management professional with experience on leading and managing business functions as well as technology consulting. He has authored best selling books and published many white papers on technology. He also holds patents for innovations. Presently he is global head of the SAP Analytics Centre of Excellence at Tata Consultancy.

See more by this author

Deepak Sawant

Deepak Sawant is an SAP analytics professional with 16 years of experience designing, developing, and maintaining large and complex BI programs for a variety of Fortune 500 companies. He played a key role in the design, development, and deployment of business analytic solutions in financials, supply chain, product costing, production, and planning functions. Deepak has performed multiple roles in technology consulting, delivery management, pre-sales, and operations management for leading organizations, namely Tata Consultancy Services Ltd., IBM, Reliance Industries, and Wockhardt Group. Currently he is leading the SAP BW Center of Excellence at Tata Consultancy Services Ltd., where he has been instrumental in establishing innovative consulting service offerings.

See more by this author

Jyoti Jain

Jyoti Jain is an associate at Tata Consultancy Services Ltd., with 10 years of experience in IT, primarily serving the banking, manufacturing, life-science, and travel and hospitality industries. She is part of Tata Consultancy Services’ SAP Center of Excellence and is engaged in architecting and designing solutions on the SAP BusinessObjects platform.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.