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...
