An MDX Question?
OLAP Server User Guide
Configuring icCube
Running icCube
Migrating icCube
Security
Creating Schemas/Cubes
Working with icCube
Reporting Tools Integration
Embedding icCube
Plugins/Extensions
Web Reporting
Installation
Local Settings
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
Reference
icCube Client Library
XMLA Client Library
BottomPercent (standard MDX)

Returns a ascending sorted set which cumulative percent is greater or equal than the specified percent (i.e., a value between 0 and 100).

Parameters

Name Type Cardinality Default value
set  set-expression  one   
percent  numeric-expression  one   
measure  numeric-expression  one   

Return

set

Description

Function sorts the set in the ascending order according to the specified measure and returns the minimum number of elements whose cumulative percent is greater or equal to the specified percent.

If 0 was specified as a percent the member with the lowest value is returned.

See Also

TopPercent BottomCount TopCount BottomSum TopSum

Examples

BottomPercent(set,percent,numeric)
BottomPercent(set,percent,numeric) - duplicated members

Special Examples (errors, null, ...)

BottomPercent(set,percent,numeric) - percent > 100 and empty values
BottomPercent(set,percent,numeric) - percent equals 0
BottomPercent(set,percent,numeric) - negative percent
BottomPercent(set,percent)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.

icCube OLAP version: 2.5.1 13-May-2012 02:21:10 GMT