Hi - I am having a problem calculating an MRP formula which works in a
spreadsheet, but not in AS due to calculation orders. This is what I
am trying to solve:

Opening Stock (this period) = Opening Stock (last period) + Planned
Receipts (last period) + Actual Receipts (this period) - Forecast
(last period).

Now planned receipts includes "Opening Stock" in its calculation:

Planned Receipts (this period) = Opening Stock (this period) -
Forecast (this period)

I do check for the first time member and set values to zero to start
the calculation process.

I would really appreciate any help with this, it has been driving me
crazy!

Thanks Ian.

Check out the Solve Order property (property of calc member).

tom @ the domain below
www.tomchester.net


"Ian Hopewell" <ianh12345 (AT) iafrica (DOT) com> wrote

If both "Opening Stock" and "Planned Receipt" are on the same cube
dimension, then their relative Solve Order should not be an issue. Can
you provide some simple sample data, starting at the first time
member, and the MDX formulii?

- Deepak


ianh12345 (AT) iafrica (DOT) com (Ian Hopewell) wrote in message news:<15cd3617.0310162354.77fde51f (AT) posting (DOT) google.com>...