Use the Analysis Process Designer to Reduce Your BEx Query’s OLAP Time

  • by Puneet Kapoor, BW Specialist, TIMET
  • August 15, 2011
Find out how you can use the Analysis Process Designer as an alternative way to reduce high OLAP time for SAP Business Explorer queries, especially when using them as a Business Intelligence Consumer Services or Query as a Web Service connection to feed dashboards.
Key Concept
The Analysis Process Designer is a workbench for the creation, execution, and monitoring of analysis processes. Data from different data sources in SAP NetWeaver BW can be combined, transformed, and staged for analysis in several individual steps so that it can be resaved in data targets in SAP NetWeaver BW (i.e., DataStore objects for direct updates or InfoObjects with attributes) or in SAP Customer Relationship Management.

You can use SAP BusinessObjects tools on top of SAP NetWeaver BW, given there are multiple integration techniques. Among them are direct access to InfoCubes (InfoProviders) and Business Explorer (BEx) queries. However, due to the availability of variables, hierarchies, and restricted and calculated key figures, a BEx query is still the preferred and controlled way to feed data to SAP BusinessObjects applications. Depending on your software version, you can either use a BEx query directly via a Business Intelligence Consumer Services (BICS) or via an SAP BusinessObjects OLAP universe, through Query as a Web Service (QaaWS).

Based on your businesses reporting requirements, you can have simple or complex technical designs, but it’s always a challenge and a need to have optimized front-end solutions that combine SAP BusinessObjects with SAP NetWeaver BW as a data source. A fast BEx query’s response directly reflects on the performance of a dashboard. I am keeping simple designs out of this article because they are easy to handle in SAP BusinessObjects without compromising the design and performance. However, for complex reporting requirements in SAP BusinessObjects, it’s advisable to push the processor-intensive calculations back down to SAP NetWeaver BW.

Puneet Kapoor

Puneet Kapoor is BI specialist at TIMET, a large supplier of titanium metal products. He has eight years of experience in SAP Netweaver BW and three years in SAP BusinessObjects.

See more by this author


Comments

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.