Tip Doctor, Insider Learning Network.
This tip is from a May 2010 article in BI Expert by Ingo Hilgefort, director, BI Solution Architecture, Technology Solution Management. He provides a set of common best practices for integrating SAP BusinessObjects Web Intelligence with SAP NetWeaver BW. The best practices are grouped into the areas of universe, BW query, and report design.
Universe Designer provides useful functionality when your list of values for a prompt returns a large list of members. In such a situation, you should consider activating the Delegate search option (Figure 1). You can activate this option by opening the properties for both elements of the corresponding list of values in the universe. Remember that a list of values generated based on an SAP variable has two elements — one for the key and one for the description. Therefore, you need to configure this property for both elements.
Figure 1 Activate the Delegate search option for the key and for the description
er you activate this property, you can open or create an SAP BusinessObjects Web Intelligence report. If the user is prompted for a value, you will notice two major changes:
- The list of values is not being loaded anymore, even in a case where the prompt is mandatory
- The user has to use the search capability to first narrow down the list of values and select a value (Figure 2)
Figure 2 SAP BusinessObjects Web Intelligence prompt with delegated search
For more information on SAP BusinessObjects and BI-BW visit the group pages on Insider Learning Network.