I have some Distinct Counts in a Multidimensional Cube, and Cannot seem to be able to create another calculated column from the Distinct Count and make zero is no rows exist for that Distinct Count.
Thomas
Technology Tips and News
I have some Distinct Counts in a Multidimensional Cube, and Cannot seem to be able to create another calculated column from the Distinct Count and make zero is no rows exist for that Distinct Count.
Thomas
You could put a test in the calculated member. Or an even easier way to ensure a zero is returned is to add zero to your measure (SSAS treats a null as mathematically zero). eg
Measures.MyDistinctCount as Measures.RawDistinctCount+0
Hope that helps,