Try setting the ALL option to ON. This is used to tell WebFOCUS to return records even if a field referenced is null. You may also want to check the MFD to make sure the field definition indicates the field can be null if in fact it contains null values.

Originally posted by mgrackin:Try setting the ALL option to ON. This is used to tell WebFOCUS to return records even if a field referenced is null. You may also want to check the MFD to make sure the field definition indicates the field can be null if in fact it contains null values.

SET ALL = ON

The SET ALL = ON didn't work. The value in the cube are nulls but I will like them to be displayed as 0's in webfocus.