Dimensional expression help!

[cogswell]

Dimensional expression help

My time dimension has Year, Quarter and Month. All the years have 12 months each as their children, except the current year (which has 6). I need a dynamic set expression:

• of the latest months for all my years (December 2009, December 2010 and June 2011), and
• their member captions be the parent years (2009, 2010 and 2011)

To think of this in another way, I need a list of the 'youngest' child of each child.

Any good way to do this? Or am I forced to create a static set and do yearly report maintenance? I have tried the following and others but got the 'invalid coercion' error everytime.

Code Select Expand

set(lastChild(children([Time])))

set(lastSibling(members([Cube].[TimeDimension].[Time].[Month])))


[cogswell]

Anyone?