Automatically Update Charts and Tables in PowerPoint with SAP BusinessObjects Analysis

  • by Mustafa Aydogdu, Senior BI Consultant, Turkish Telecommunications
  • March 7, 2011
SAP BusinessObjects Analysis, edition for Microsoft Office allows you to connect Microsoft PowerPoint and SAP NetWeaver BW. This connectivity enables users to insert SAP NetWeaver BW data directly into a PowerPoint presentation. You can create a PowerPoint presentation that is fed from SAP NetWeaver BW, without using a universe.
Key Concept
SAP BusinessObjects Analysis, edition for Microsoft Office is the new generation front end for OLAP analysis in SAP BI tools. As an add-on to Microsoft Excel and PowerPoint, SAP BusinessObjects Analysis, edition for Microsoft Office can connect directly with SAP NetWeaver BW queries as well as with SAP BusinessObjects universes. SAP BusinessObjects Analysis does not replace BEx Analyzer directly; it is the premium application for analysis. BEx Query Designer remains the query design tool, regardless of whether you use SAP BEx Analyzer or SAP BusinessObjects Analysis.

Imagine that you are a finance analyst and preparing presentations for your managers with financial figures, including the balance sheet and profit & loss statement. If you are updating your figures often, it becomes time consuming to enter data into PowerPoint after collecting and formatting the data from SAP NetWeaver BW. With every update, you need to clear the cells and deal with the size and format of the raw data. SAP BusinessObjects Analysis helps you to easily put your data into PowerPoint and format it. Moreover, you can update your data by just one click without the need to format again and again after every update.

It is very hard to distinguish this new add-on from the usual Microsoft interfaces. It comes as a tab and groups functionalities inside the tab. Here is how to use SAP BusinessObjects Analysis and PowerPoint to display SAP NetWeaver BW data.

Step-by-Step Connection

First you have to install SAP BusinessObjects Analysis on your PC. For further information about installation, check Ingo Hilgefort’s article “SAP BusinessObjects Analysis, Edition for Microsoft Office — Your First Steps.”

As a prerequisite you need the following software installed on your client computer:

  • Microsoft PowerPoint 2007 or later
  • SAP GUI 7.x with SAP BW 3.5 and SAP NetWeaver BW 7.x Add-Ons
  • Windows XP or later

For more information about system requirements, refer to SAP Note 1466118 (Hardware & Software requirements for Advanced Analysis).

Mustafa Aydogdu

Mustafa Aydogdu is a senior BI consultant with Turkish Telecommunications. Prior to this, he worked at Accenture, helping large companies implement complex data warehouses in retail, FMCG, pharma, and telco industries. He has worked with several BI tools including SAP NetWeaver BW, SAP BusinessObjects, and QlikView. He has extensive experience in data modeling, design, configuration, and performance tuning of BI systems.

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.