I used this mdx to create a field that shows me the cumulative quantity of
items not shipped (Rem Qty)...I have an additional measure that has the
Available qty placed into the cube always on the current date (cube is
rebuilt each day). This additional measure is added into measure...and then
I have the 'expected onhand qty' for each of my date periods.

Sum(PeriodsToDate([TimeWeek].[Year]), [Measures].[Rem Qty]+Avail)



However, this calculated measure greatly slows the cube. How have others
solved the question of showing (speedily, efficiently) the expected qty on
hand, based on previous days' inputs/outputs?



Thanks for your help!