Configuring Top N Parameters 
Use
Use this screen to configure the parameters specific to the Top N template. See Top N (OLAP) for the description, business question, and workflow for using this template.
Procedure
...
1. In the Define Query Ranks and Values section of the screen, choose and define rank types according to the values in the table below:
Define Query Ranks and Values Parameters
Rank Option |
Checked |
Type |
Value |
Top rank |
If checked, calculate in query. If unchecked, ignore. |
Count |
Numeric value indicates count (for example, 5 specifies Top 5). |
Percent |
Numeric value indicates percentage (for example, 10 specifies Top 10%). |
||
Bottom rank |
If checked, calculate in query. If unchecked, ignore. |
Count |
Numeric value indicates count (for example, 5 specifies Bottom 5). |
Percent |
Numeric value indicates percentage (for example, 10 specifies Bottom 10%). |
You can configure a query to calculate both top and bottom ranks, and the rank type (count or percent) can differ between the two.
2. In the Define Members section of the screen, select the level that contains the members you want to see in the query’s result, and the measure to use for the Top N calculation, using the parameters in the table below:
Define Members Parameters
Parameter |
Value |
Action |
Dimension |
Lists all dimensions in the cube on which the query is based (see Selecting a Cube). |
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 N calculation. |
3. Click Next.
Result
You proceed to the Define Filters screen.
Example
For a complete example of using the Top N template to create a BI iView, see Example 4: BI iView.