MDX NON_EMPTY_BEHAVIOR value 0 or null

Hello,

I want the value for NON_EMPTY_BEHAVIOR to be 0 or null.

This can't be done with:

FORMAT_STRING = "€ #,#;-€ #,#;€ 0",

NON_EMPTY_BEHAVIOR = 0,

VISIBLE = 1 ;

or

FORMAT_STRING = "€ #,#;-€ #,#;€ 0",

NON_EMPTY_BEHAVIOR = null,

VISIBLE = 1 ;

I can create a named calculation, use this in the measure group and in the NON_EMPTY_BEHAVIOR but I don't like this construction.

FORMAT_STRING = "€ #,#;-€ #,#;€ 0",

NON_EMPTY_BEHAVIOR = { [Zero] },

VISIBLE = 1 ;

Does someone has a better solution?

Regards

Hessel Appers

Hello! Perhaps you got this wrong. NON_EMPTY_BEHAVIOR is not about how you display zero or null in cells.

It is about optimizing calculated measures and you always refer to a measure for this property.

HTH

Thomas Ivarsson