38
24 Best Practices
24.1 Increasing Performance of Analysis Applications with
Multiple Data Sources
Background
To prevent deadlock scenarios while processing multiple data sources, SAP BusinessObjects Design Studio
processes all data source calls sequentially. This may reduce the performance of analysis applications that
contain multiple data sources.
Solution Possibilities
There are three ways to increase the performance of analysis applications that contain multiple data sources.
Note
The second and third solutions are only available as of SAP BusinessObjects Design Studio version 1.2.
1. Selection of data sources initialized at startup
By default, data sources are initialized at application startup. However, in many business scenarios, it is often
a requirement that applications do not display all screens (parts of an application) at startup. You can achieve
this by using the components Tabstrip (where only one of the tabs is visible) or Pagebook (where only one
page is visible) or simply by setting the component's property Visible to false. Data sources used to display
information that is not immediately visible at application startup should be initialized later (not at application
startup). For these data sources, you must set the property Load in Script to true. The script method
loadDataSource() must be called when the data source is needed.
Example: In this example, the application contains a tabstrip component, where the first tab (tab with index 0)
is visible at startup. The second and third tab refer to data contained in the data sources DS_2 and DS_3
respectively. DS_2 and DS_3 should have Load in Script set to true. The On Select event of the Tabstrip
component should contain code similar to this:
if (TABSTRIP_1.getSelectedTabIndex() == 0) {
// DS_1 is already loaded at the beginning. Nothing to do.
} else if (TABSTRIP_1.getSelectedTabIndex() == 1) {
DS_2.loadDataSource();
} else if (TABSTRIP_1.getSelectedTabIndex() == 2) {
DS_3.loadDataSource();
}
2. Sharing of data sources among multiple charts
With SAP BusinessObjects Design Studio 1.2, multiple charts can be assigned to a single data source. Each
chart can display a different subset of the data contained in a data source, which holds the superset of the
displayed data. For example, a data source could contain data for multiple regions (Europe, America, etc).
Application Designer Guide: Designing Analysis Applications
Best Practices
© 2014 SAP AG or an SAP affiliate company. All rights reserved.
159
