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

Optimizing BEx Query performance


In this recipe, we will give you some specific performance optimization recommendations when using BEx Queries as a data source for your data connection. Standard SAP BW optimization practices like InfoCube design, using aggregates, OLAP caching, and so on have not been covered here, as it is too general and out of the scope of this book.

How to do it…

We will discuss three topics here.

Use dashboard specific queries

Do not reuse existing queries that are used for reporting with analysis tools, such as BEx Analyzer, SAP BusinessObjects Web Intelligence, or SAP BusinessObjects Analysis. These queries tend to have a broad setup with lots of (free) characteristics and key figures, whereas for a dashboard, extremely specific queries are required. The dashboard queries should provide a result set with only the data that is required, and nothing more.

Also, do not use BEx Query Views. Instead, if you want to reuse an initial query and change its structure, make use...