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