SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 59
The following templates, listed together with their descriptions and sample business
questions, are provided for relational data services:
Relational Query Templates
Name Description Sample Business
Question
All Data [Page 96]
(default)
Selects all records and all fields
as the final result, without any
filters or joins.
What are all the available
grade levels and their
details?
Count [Page 97] Counts all occurrences of a
certain type of data in a group or
groups within a table.
How many employees is
each different manager
responsible for?
Freeform [Page 98] Walks you through defining a
query without the constraint of a
particular business question.
Not applicable.
Heatmap [Page 99] Aggregates values of a selected
primary group and compares them
with values of a secondary group
by displaying the results in boxes
of differing sizes and colors.
What is the relative
distribution of sales among
certain divisions and
companies?
Minimum/Maximum
[Page 103]
Finds the minimum or maximum
value of a field, and provides
details from the row that holds that
value.
Which store has the
smallest revenue; where is
that store and who is the
manager?
The templates designated as default above are the default templates when you
configure a query directly in a data service. See Configuring Queries Directly in
Data Services [Page 123] for more information.
The relational Count template is not available for SAP Query data services.
3. Click Next.
Although we provide a sample business question for each query template, note
that a given template can address many different questions. For example, you
can configure the Top N query template to address any of the questions below:
• What are my top five customers based on sales?
• What are my bottom ten products based on margin?
• What products make up the top 10% of sales?
Result
You proceed to the first screen specific to configuring your query. Future steps in the
navigation trail update based on the template you have chosen.
Select a template from the table above to view the specific steps involved with configuring
that query.
