The cube is 6 dimensions (N-elements: 6x8x14x3x8x5), so tiny. The depreciation rule takes prior month book value and multiplies by a certain percentage. It only does this for 2 scenarios, for 2 years, for 12 months, so not many calculations at all, but it literally runs into several minutes to recalculate! Due to IF conditions I can't use markers, but the cube isn't that large, so doubt that it would have an impact. Any ideas? Has anyone had similar issues? Alternatively, would I rather need to do this via ETL? Bit worrying though, as the cube is still tiny, with data in only a few cells (6 or 7!).

Any help would be very much welcome!