OBIEE Online Training

Wednesday, June 8, 2011

Replacing Null as 0 in obiee

 criteria tab and edit the ‘column properties’ associated with your fact measure. Choose the ‘Data Format’ tab, tick to override the default format and choose ‘Custom’.
It seems that the syntax for this custom format is positive-value-mask (semi colon) negative-value-mask (semi colon) null-mask. So this means we have a few options.
E.g. if you want zeros (0) instead of null then enter:
#,##0;-#,##0;0
2) in that formula columns we have put it below case condition also ,
CASE WHEN Nom_amt IS NULL THEN 0 ELSE Nom_amt END
3) we have uncheked IS NULL check box in the admin tool also
IFNULL(columname,0)


IN OBIEE 11g above mothods won't work because it's a bug in obiee11.1.1.5.0 version please refer the BUG reference :

Bug 13054445 - REPLACING NULL VALUES WITH "0" IN AN OBIEE 11G PIVOT TABLE IS NOT WORKING

Thanks

Deva

No comments:

Post a Comment