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.
set(lastChild(children([Time])))
set(lastSibling(members([Cube].[TimeDimension].[Time].[Month])))