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.
Would you like to see this full item?