Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Book Image

SAP BusinessObjects Dashboards 4.1 Cookbook

Overview of this book

Table of Contents (26 chapters)
SAP BusinessObjects Dashboards 4.1 Cookbook
Credits
Foreword
About the Author
Acknowledgments
About the Author
Acknowledgments
About the Reviewers
www.PacktPub.com
Preface
Index

Using Live Office Connection


With SAP BusinessObjects Live Office it is possible to insert data from Crystal Reports documents and Web Intelligence reports into Microsoft Office products (Word, Excel, Outlook, PowerPoint). Since data can also be refreshed with this add-on, the Live Office Connection can be a very useful way to provide our dashboards with fresh data.

Getting ready

For this recipe you will need SAP BusinessObjects BI Platform to be installed on your machine and the Live Office Connection software installed on your client computer. You will also need a Crystal Reports document, a Web Intelligence report, or a Universe to connect to.

How to do it...

  1. Open a new SAP BusinessObjects Dashboards file and go to Preferences... in the File menu. In the Excel Options section, check if Live Office Compatibility is enabled.

    Note

    For better tool stability, only enable this option when you are actually using Live Office in your dashboard.

  2. Go to the Live Office tab of the spreadsheet. Click the...