By Andrea Haynes, SAPexperts
Isha Gupta, a SAP BI consultant at Accenture, shows how to combine SAP BusinessObjects applications with SAP NetWeaver BW in her article “SAP BusinessObjects: Two Tips to Improve the Look of Your Reports.” She notes that SAP BusinessObjects Web Intelligence allows self-service reporting. However, she advises that you need to be cautious when combining the two applications to create SAP BusinessObjects Web Intelligence reports to ensure you achieve the desired functionality and interactivity.
One tip shows what to do if you have a structure in a BEx query that contains many key figures, but in the SAP BusinessObjects Web Intelligence report you want to display only a selected few key figures from that structure. Using the example of a structure called Rolling Periods that has key figures related to various months and quarter time periods of a year, she provides the following steps to display the key figures related only to all quarters.
Step 1. Create the SAP BusinessO
bjects Web Intelligence report on top of an SAP BusinessObjects Universe built on a BEx Query. You get the structure Rolling Periods displayed as a dimension in the data panel.
Step 2. Drag the Rolling Periods into the SAP BusinessObjects Web Intelligence report Result Objects panel.
Step 3. Drag the Rolling Periods again to the Query Filters panel. Click In list and select Value(s) from list from the drop-down options. This creates a filter of the type List of Values.
Step 4. In the next List of Values selection screen, select the key figures that you want to display on the SAP BusinessObjects Web Intelligence report by moving the selected values to the right-side pane. When you click OK in the resulting screen, then your SAP BusinessObjects Web Intelligence report displays only the selected quarter key figures (Figure 1).
Figure 1 SAP BusinessObjects Web Intelligence report display
The full article includes more detail and screenprints to illustrate the steps, as well as a second tip on how to display the values selected by users for various variables.