MDX: all to date function wanted

[fmientjes]

I would like to know the syntax for getting the sum of a field upon a time parameter. A sort of YTD function, but then extended with all previous years.

for example:
2007 Jan: 100
2007 Feb: 100
....
2008 Sep: 100

Time parameter: August
This Month will show 100
YTD will show 800 (8 x 100)
All time will show 2100 (21 months x 100)
"All to Date" should show: 2000 (20 months x 100)

How can I achieve a calclation within my cube to show "All to Date"?

I am a newby to MDX . Help is very appreciated.
Frans

[Island1]

A good start might be the range operator (":"), but you could certainly get fancier - keeping in mind the nature of accumulation, and whether that is what you are truly after (if these are financial accounts, as an illustration, not all accounts would be cumulative - inventory or fixed assets, for example ...)

Give us more detail as you develop your approach, and as further questions arise...

Good Luck.

Bill

[Island1]

Just checking to see if you had further questions.

Good Luck!

Bill