How to Replace Null Values in an OBIEE Pivot Table?

How to Replace Null Values in an OBIEE Pivot Table

It's simple tip that allows you to supress null values in a pivot for cells which have no data.
Create a simple report. I’m using the Samplesales RPD here.
　
A pivot table view of this data would look something like this by default:
　
Now switch back to the 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
　
If you want a dash/strike (-) then you could enter:
#,##0;-#,##0;-
Or if you want to add a custom message then something like this would work:
#,##0;-#,##0;no data
Our pivot table now shows something other than null values.

Its a bug in OBIEE11g

I have raised SR and confirmed it defect obiee11.1.1.3.version but after obiee11.1.5 released also that major bug is not yet resolved that why i am just wondering
fyi:
Fix by 11.1.1.6.1 as mentioned in the Bug.
Bug 13054445 [http://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=13054445] - REPLACING NULL VALUES WITH "0" IN AN OBIEE 11G PIVOT TABLE IS NOT WORKING
for more refer :
https://forums.oracle.com/forums/thread.jspa?threadID=2319791


Regards,
Deva