SAP BEx - Integration With BO

You can also integrate all BEx objects with SAP BusinessObjects tools. When you integrate BEx with BO tools, it broadens the scope for reporting and data analysis. You can perform the following integration with SAP BusinessObjects −

• Integration with SAP BO Dashboards
• Integration with SAP Crystal Reports
• Integration with SAP BusinessObjects Analysis.

When you open any of the BusinessObjects tools, you have an option to consume BEx Query to create a BI Report or Dashboard. You can use the existing queries in the Query Designer and can also create new queries in the BEx Query Designer tool.

Open SAP Crystal Report Designer to integrate with the BEx Query. Navigate to Data Source → Select BEx Query.

To connect to a Data source, go to File → New → from the Data Source.

You can also connect to other SAP BusinessObjects tools to connect to BEx Query and you can import the characteristics and key figures to create dashboards and BI reports.

To connect the Dashboard to the BEx Query, you need to navigate to the Query Browser → Add Query → Select BEx.

Next is to select the connection → Search for BEx Query that you should use based on the InfoProvider to use in the BO Tool.

This is how you can connect SAP BusinessObjects tools to BEx Objects.