If the specified 'percent' value is greater or equal than 100% all members will be returned, including empty cells.
In this case, the function behaves as Order(set,numeric2,BASC) function.
Query
WITH
MEMBER [Geography].[Geo].[E] AS NULL
MEMBER [Geography].[Geo].[20] AS 20
MEMBER [Geography].[Geo].[30] AS 30
MEMBER [Geography].[Geo].[50] AS 50
SELECT
BottomPercent( {[Geography].[Geo].[E],[Geography].[Geo].[20],[Geography].[Geo].[30],[Geography].[Geo].[50]},150, [Measures].[Amount] ) ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Geography].[Geo].[E] AS NULL
MEMBER [Geography].[Geo].[20] AS 20
MEMBER [Geography].[Geo].[30] AS 30
MEMBER [Geography].[Geo].[50] AS 50
SELECT
Order({[Geography].[Geo].[E],[Geography].[Geo].[20],[Geography].[Geo].[30],[Geography].[Geo].[50]}, [Measures].[Amount], BASC) ON 0
FROM
[Sales]
If the specified 'percent' value is equal to 0 the first element of the set is returned (lowest one).
Query
WITH
MEMBER [Geography].[Geo].[E] AS NULL
MEMBER [Geography].[Geo].[20] AS 20
MEMBER [Geography].[Geo].[30] AS 30
MEMBER [Geography].[Geo].[50] AS 50
SELECT
BottomPercent( {[Geography].[Geo].[E],[Geography].[Geo].[20],[Geography].[Geo].[30],[Geography].[Geo].[50]},0, [Measures].[Amount] ) ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Geography].[Geo].[E] AS NULL
SELECT
{[Geography].[Geo].[E]} ON 0
FROM
[Sales]
Returns an error if a negative 'percent' value is used.
Query
BottomPercent([Geography].[Geo].[City].Members, -1, [Measures].[Amount])
Result
Error Code : OLAP_OUT_OF_RANGE
Error Message : BottomPercent() : the percent value '-1.0' is out of range (expected range:'[0..1]')
Returns an error if a negative 'percent' value is used.
Query
BottomPercent([Geography].[Geo].[City].Members, 20)
Result