Hi SSC Veteran,

This kiddie works :

WITH MEMBER [Measures].[MinValue] AS MIN([Order Date].[CalendarHierarchy].CURRENTMEMBER, [Measures].[Sales Amount]), FORMAT_STRING = '0'

MEMBER [Measures].[MaxValue] AS MAX([Order Date].[CalendarHierarchy].CURRENTMEMBER, [Measures].[Sales Amount]), FORMAT_STRING = '0'

SELECT

{[Measures].[Sales Amount],[Measures].[MinValue],[Measures].[MaxValue]} ON 0,

[Order Date].[CalendarHierarchy].[Year].Members ON 1

FROM

(

SELECT [Order Date].[CalendarHierarchy].[Year].[2006] ON 0

FROM MyFirstCube

)

Year Sales AmountMinValue MaxValue

2006 6530343 6530343.5263999465303446530344

but i'm confused ...using the currentmember seems to force it to use the context of the subcube. However my question is we have used a SUBSELECT where we have created a subcube purely of only 2006 figures Sales and the [All] which is the root of the calendar hierarchy has only this year in its member list. This is not a WHERE we it acts as a slicer where i would still expect it to see the other years.

So using the currentmember or the literal viz:

MEMBER [Measures].[MinValue] AS MIN([Order Date].[CalendarHierarchy].[Year].Members, [Measures].[Sales Amount]), FORMAT_STRING = '0'

MEMBER [Measures].[MaxValue] AS MAX([Order Date].[CalendarHierarchy].[Year].Members, [Measures].[Sales Amount]), FORMAT_STRING = '0'

should in my eyes give the same thing. Is my argument wrong ?