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

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.