aggregation Problem

I created a cube for Inventory valuation.
Every monthend a static Inventory valuation of every item will be put in the
cubes.
1. I don't want to aggregate the value across the months;
2. If the user view by year, I would like to system to put the Latest
valuation in that year. for examples 2003 = 2003/Dec, 2004 = 2004/Dec, 2005 =
2005/Jan.
How can I achieve it in the cubes design?
Hi Kam
Try looking at the ClosingPeriod MDX function in BOL
Yours sincerely
Thomas Kejser
M.Sc, MCDBA
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:7B95BD16-6351-407E-95DD-244D962F9266@.microsoft.com...
>I created a cube for Inventory valuation.
> Every monthend a static Inventory valuation of every item will be put in
> the
> cubes.
> 1. I don't want to aggregate the value across the months;
> 2. If the user view by year, I would like to system to put the Latest
> valuation in that year. for examples 2003 = 2003/Dec, 2004 = 2004/Dec,
> 2005 =
> 2005/Jan.
> How can I achieve it in the cubes design?