Use the Configure Top N Parameters screen to configure parameters specific to the Top N template. With this template, you can build queries that calculate the rank of a level based on a specific measure. This template is not limited to top values, but also lets you select bottom values, independently or together with top values. This sort of query makes it easy to identify your leaders and laggards.
This template can address business questions such as the following:
Who are my top ten or bottom ten customers?
The main sections and controls of this screen are listed in the following table:
Section |
Control / Value |
Description |
|
---|---|---|---|
Define Query Ranks and Values |
In this section, use the checkboxes to include top, bottom, or both rank types in the query results. Use the values below to configure the rank type (count or percent), which can differ between the two. |
||
Top rank type |
Count |
Select this option to configure a top count rank. Enter a number in the Value field to indicate count (for example, 5 specifies top 5). |
|
Percent |
Select this option to configure a top percent rank. Enter a number in the Value field to indicate percentage (for example, 10 specifies top 10%). |
||
Bottom rank type |
Count |
Select this option to configure a bottom count rank. Enter a number in the Value field to indicate count (for example, 5 specifies bottom 5). |
|
Percent |
Select this option to configure a bottom percent rank. Enter a number in the Value field to indicate percentage (for example, 10 specifies bottom 10%). |
||
Define Members |
Dimension |
Lists all dimensions in the cube on which the query is based. Select the dimension that contains the hierarchy to display in the Hierarchy field. |
|
Hierarchy |
Lists all hierarchies in the currently selected dimension. Select the hierarchy that contains the level to display in the Level field. |
||
Level |
Lists all levels in the currently selected hierarchy. Select the level that contains the members you want to see in the query's result. |
||
According to measure |
Lists all measures in the cube on which the query is based. Select the measure to use for the top (or bottom) N calculation. |
For a step-by-step example, see Creating a BI iView in the SAP NetWeaver Visual Composer Modeler's Guide.