We have a proble within a cube measure. We ant to design acube
containing something like a "running sum". I am quoting this, beacause
i didn´t fin any similar expression for this.

So, if the column "Sum" is the expression we wanted, we want to get
this
result in the cube. (TIme is a dimension with the elements
Year,month...)

We just found this on the web groups for the food mart database, but
the sum
is not resetting at the beginning of the ýear.


Year Month Value Sum
=======================
2002 12 1 1
2003 1 5 5
2003 2 3 8
2003 3 12 20


hanks for your help

Jens

Just do
sum(Periodstodate([Time].[Year],Time.CurrentMember),([Measures].[X]))

will give you the required result



MrIgel (AT) gmx (DOT) de (Jens) wrote in message news:<2ad00ef3.0404060708.db462f (AT) posting (DOT) google.com>...

Thank, its work really fine.

Jens.

(Here are something matching words to find this problem for the german
guys, (Analysis OLAP Running sum laufende Summe rollup sum mdx)