Hi!
Thanks for the answer.
"This also feels like its a work around for some other issue, so maybe looking for an alternate solution for that would be better."
The measure is a writeback partition measure for financial budget, which I'm changing from Excel writeback. This is a special case where I can't allocate weighted values for empty on 0 cells from Excel what-if-analysis. That is the reason for the whole 0--->0.000000000000001 script, so that the weighted allocation writeback would always work. Sure, I can do it in SQL/ETL, but it is cumbersome since this measure aggregates data from 2 partitions: writeback & source partition. I would need to check the aggregated results for 0.
"Although this is still likely to be slow as you are crossjoining the leaves of 5 dimensions and forcing the engine to re-aggregate on the fly"
Can I force it for only those cells which have value for [Measures].[Budget Amount 2 - EDIT]? Cube space size would be reasonable then. I also need to overwrite only where value=0 not any other values. Your MDX doesn't take that into account.
Since it is a "money/currency" type measure there are no blanks involved. Only cells with actual values: 0 or actual numbers or empty cells (which I'm trying to leave out of the SCOPE).
Thanks a lot,
Kaarel.