SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 103
Minimum/Maximum (Relational)
Purpose
The Minimum/Maximum template is a relational template with which you can build queries
that find the minimum or maximum value of a field, and provide details from the row that holds
that value.
You should use this template if you would like to address business questions such as the
following:
Which store has the smallest revenue; where is that store and who is the manager?
Prerequisites
You have a relational data service configured as a BI system.
Process Flow
After using the BI Query Wizard to select a relational data service and the Minimum/Maximum
template, the wizard steps you through the following process flow:
...
1. Select fields [Page 110]
2. Configure joins [Page
114]
3. Configure filters [Page
116]
4. Specify the sort order [Page
118]
5. Configure Minimum/Maximum parameters [Page
104]
6. Preview the result [Page
119]
Result
After you have completed the wizard screens according to the process above and clicked
Finish, you return to the Visual Composer workspace, where a new data service has been
created with the query you have configured.
A data service created with the BI Query Wizard is configured automatically with a start input
and a table view as output. These three elements together constitute a complete iView, ready
for preview and deployment to your portal.
To continue working with your data service and query, see:
• Working With Queries [Page
130]
• Using the SQL Editor [Page
128]
Example
For an example of working with the Minimum/Maximum template, see Configuring
Minimum/Maximum Parameters [Page 104].
