Show TOC

Object documentationTop N Parameters Locate this document in the navigation structure

 

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?

Structure

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.

Example

For a step-by-step example, see Creating a BI iView in the SAP NetWeaver Visual Composer Modeler's Guide.