ICubeExecuteFilterFunctionTop

Assembly: Cubes;

Description

The ICubeExecuteFilterFunctionTop interface contains properties that are used to determine specific settings of the function that filters data by selecting greatest or least values.

Inheritance Hierarchy

ICubeExecuteFilterFunctionTop

Comments

To get settings, cast the object described by the ICubeExecuteFilterFunction interface to the ICubeExecuteFilterFunctionTop interface. The ICubeExecuteFilterFunction.Predefined property must return the Top value for the object.

On using the functions that select greatest or least values the following MDX query block is created:

TOPCOUNT (Set_Expression, Count [, Numeric_Expression ] )

TOPPERCENT/BOTTOMPERCENT (Set_Expression, Percentage, Numeric_Expression)

TOPSUM/BOTTOMSUM (Set_Expression, Value, Numeric_Expression)

Properties

  Property name Brief description
Argument

The Argument property determines the value, with which data is compared on filtering.
Function_

The Function_ property determines the function that filters by selecting greatest or least values.
Set_

The Set_ property determines selection of the elements, by which values filtering is executed.
Value

The Value property determines the expression that usually presents the MDX expression returning the dimension.

See also:

Cubes Assembly Interfaces