Quick Tip: Best Practices for Designing SAP BW BEx Queries and a Comparison of Connection Options

  • 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.
  • February 15, 2017
This checklist helps you learn SAP BW BEx Query design best practices to enable you to build performance-optimized SAP BW BEx Queries. Also see a quick comparison of the three SAP BusinessObjects connection types: Business Intelligence Consumer Services (BICS), relational, and Business Application Programming Interface (BAPI) connections. This quick tip also helps you decide which SAP BusinessObjects connection type is right for your scenario.

The connection type used between SAP BusinessObjects and SAP BW, large data volumes, or computing resources may not be the only causes of poor performance for BusinessObjects reports. Oftentimes, the design of the data-sourcing BEx Query can negatively impact performance. Design considerations in SAP BW data models and SAP BW BEx Queries can improve the performance of BusinessObjects reports that use Business Intelligence Consumer Services (BICS) connections. The following is a list of design factors that should be taken into consideration and evaluated to help you design and develop optimized SAP BW BEx Queries.

These quick tips are a companion to our two other BI Expert articles, “How to Use BICS to Connect SAP BusinessObjects Client Tools to SAP BW (Part 1)” and “How to Use BICS to Connect SAP BusinessObjects Client Tools to SAP BW (Part 2).” For more detailed information about the BICS connection and how to connect SAP BW to SAP BusinessObjects reporting tools, refer to these articles.

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.