How to Pivot SAP BW Queries

  • by Joerg Boeke, Independent BW Senior Consultant and Solution Architect
  • April 15, 2004
Although BW provides filter and drill-down functionality, many BW users miss the pivoting functionality of MS Excel. The author provides seven easy steps to enable drag-and-drop functionality in SAP BW queries. This gives end users the power to optimize their BW queries.

I know from many talks with FI/CO end users who are running BW that they want to continue using the pivoting functionality of MS Excel.

BW reporting provides filter and drill-down functionality, and with the help of SAP Business Explorer (BEx), you can use the toolbar or select items from the context menu for BW reporting. However, some FI/CO users may not like the menu of the regular SAP BEx Analyzer, which analyzes data in reports. Instead, they prefer the drag-and-drop functionality of Microsoft Excel, which can add new characteristics (customer or invoice numbers) or key figures (net value, margin in percent, number of sold items) to rows and columns.

I'm going to show you a way to use the MS Excel pivot functionality based on SAP BW data. Using Excel functionality, I'll connect to SAP BW and query the data of a specific SAP BW query or InfoCube. You'll see how to combine the filter functions provided by Excel with the authorization and data quality functionality of BW.

An InfoCube in terms of BW is an object storing data of a predefined area such as CO-PA. Data from R/3 is loaded to BW InfoCubes to take the performance load off R/3 for reporting matters. A query is a report definition that can be run by users without any knowledge of a programming language. It describes characteristic objects such as account types, customers, and invoices numbers, and key figures such as net value, quantity, and number of invoices.

The following steps assume that you are running an SAP BW system and that you are able to access your SAP BW system with the help of a valid BW user ID and password. I tested the functionality with MS Excel Office 2000 and higher. For steps 1 and 2, SAPGUI must be installed at your PC client. Your BW administrators must have already defined InfoCubes and queries that you can connect to. Names and data content should be provided by your BW team.

Joerg Boeke

Joerg Boeke is an SAP NetWeaver BW solution architect and senior consultant working with BIAnalyst GmbH & Co.KG, with 19 years experience in SAP NetWeaver BW, having worked on it since SAP BW 1.2A. He offers significant expertise in the SAP NetWeaver BW reporting area, including design, data integration, data visualization, performance optimization, and the cleanup of existing SAP NetWeaver BW systems. He is the author of SAP BW 7.x Reporting - Visualize your data.

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.