Hi,

I've a MDX query which uses a a calculated member, to get a moving
average, simple calculation.
The calculated member is applied to all my customers (approx: 50.000)
and Measure is my transactions table (approx: 20.000.000).
I know that "calculated members" are only calculated in run-time, but
my query is taking too much time.

I wonder if there isn't any way of forcing the cube to calculate the
"calculated members" when processing and keeping them stored, for fast
querying.

Thank you.
Pedro Ávila