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

       2.      Configure joins

       3.      Configure filters

       4.      Specify the sort order

       5.      Configure Minimum/Maximum parameters

       6.      Preview the result

 

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

·        Using the SQL Editor

 

Example

For an example of working with the Minimum/Maximum template, see Configuring Minimum/Maximum Parameters.