The SAP BusinessObjects Business Intelligence Platform 4.1 includes significant performance benefits when one reports on SAP BW. These benefits are a great reason to upgrade for those of you using BW. Specifically there are enhancemets:
On report creation or edit with Web Intelligence or Crystal Reports for Enterprise documents which are based on BEx Queries.
On report refresh with Web Intelligence or Crystal Reports for Enterprise on BEx queries with variables.
On addition of a BEx Query to an Analysis for OLAP workspace
Web Intelligence documents based on BEx Queries via BICS
A big advantage here is that when you select a BEx query with mandatory variables which do not have default values, a variable screen (shown below) will display BEFORE the query panel. This will save some time.
Additionally, you should see a substantial performance gain for the report refresh portion once you've entered the variable values via this prompt window. Note that this particular gain is not seen when user-defined prompts are combined in a document with BEx variables.
View time also brings quicker rendering of the prompt window (screenshot below) as well as a quicker refresh once the mandatory prompt is entered for your end users.
In addition, there is now a new "Design Time" API that has been implemented at design / edit time. This particular feature requires that your SAP BW server is updated to the level indicated at the bottom of this blog. This Design Time mode allows for the fetching of metadata and master data with far less RFC calls. Specifically, the new API is used when you select queries while designing a report.
How does that look in actual practice? Well as an example, when you select your query
You'll see a lot less of the loading screen
before the BEx queries available objects are displayed (shown below). The first query you select on a particular server will take more time than the rest due to the initial handshake / warm-up process. Afterwards, it should be very fast. You'll still get some of these benefits even if your BW server isn't of the version listed below.
Crystal Reports for Enterprise
Report creation or modification on BEx Queries
Similar to the workflow in Web Intelligence, Crystal Reports also shows a variable screen before the query panel when the query contains mandatory variables without default values. Due to this, the variable screen should load more quickly. This allows the query panel itself to load more quickly. Finally the report itself is refreshed more efficiently.
The report consumers will also see benefits at view time. The prompt screen (shown below) will render more quickly. In addition, there are improvements with the generation of lists of values in this variable screen. The gain increases as the list grows larger. Finally, the report should refresh more quickly.
Analysis OLAP - selection of BEx Queries
The Open Data Source interface has changed slightly. It now opens to the Find tab instead of the Folders tab. This is helpful when there are a large number of queries on the system as you can immediately search without waiting for the initial folder / query view to load.
FAQ:
What are the BW server requirements to take advantage of the Design Time improvements?
As mentioned earlier, you should still see improvements without the following in most areas. However, to get the maximum you must meet the following criteria (subject to change):
The BW backend needs the following service pack levels and SAP notes in order for the design time improvements to be enabled and fully functional:
BW 7.30 SP8 or BW 7.31 SP5+, plus all the SAP notes listed below.
For critical cases, there is also a collection of notes for 7.30 SP7 available (excluding the notes mentioned below, so you need to apply them as well).
Even better, the versions which already contain everything are 7.30 SP10, 7.31 SP08 and 7.40 SP05
Additional SAP Notes:
I've heard good things about the performance gains from our BI 4.1 ramp-up customers and would love to hear stories of any improvements from those of you reading this blog.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
10 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
6 | |
4 |