Hi all,

Say I have a very simple cube with just one dimension, MONTH, and one
measure, UNITS_SOLD. I can use the MDX filter function to find the
maximum UNITS_SOLD across all months, but how can I find which MONTH
member that the maximum UNITS_SOLD value corresponds to?

e.g.

MONTH UNITS_SOLD
Jan 10
Feb 5
Mar 40
Apr 20

I want to create a calculated member that returns, in this case, "Mar"
as the member name which corresponds to the maximum UNITS_SOLD value
across the set.

I'd be very grateful for some pointers on how to do this as I'm
relatively new to MDX, and a bit stumped.

Thanks (in advance!)
Damian

Damian,
you could filter the dataset by the member you created.

Foodmart example is as follows:

WITH
MEMBER [Customers].[MaxCustomer]
as
'max(descendants([Customers].[All Customers], [Customers].
[City]))'
select hierarchize([Time].members) on 0,
{Filter(descendants([Customers].[All Customers],
[Customers].[City]), ([Customers].currentmember,[Unit
Sales])=[Customers].[MaxCustomer])} on 1
from Sales
where ([Unit Sales])

err, typo sorry, "MDX filter function" should read "MDX MAX function"

Thanks Brian, that gave me exactly the start I needed. I appreciate
you taking the time to help out.
Damian