Hi. I'm working on a conditional piece of mdx that started looking like what you see way below. The idea is to modify this measure's behavior based on which dimension was chosen without nesting scope statements. The detail and date hierarchy
level numbers look good on Date A but the grand total is 0 when I dice on Date A. I suspect what was posted at
explains why this happens but the solution given there applies to a different class of problem (I think).
Can someone help to explain how grand totals etc can be aggregated properly for calc'd measures? I tried multiplying [Whatever Orig] by 1 and even put the calc'd member in a different measure group to no avail. I also used a raw assignment prior to
the calculate that kind of looked like [measures].[Whatever Orig] = IIF(ROOT([Date A]),0,...) ; but that didnt work either. Eventually there will be more scope statements.
View Complete Post