Analytics Software

Hi,

I am using obiee11g pivot table view,

I have tried so many views but it's not work. My oracle support team also tired but could not solve it

1.) used BIN method is that measure columns

2.) ifnull(column name,0)

3.) case condition:

Case when columns is NULL then 0 else column end

4) data formate override custom formate option

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

http://obieeelegant.blogspot.com/2011/06/how-to-replace-null-values-in-obiee.html

Note:

I don't want to show strike-rate and custom message in that blank cell. I want to show blank cell(null values) as 0 in the obiee11g pivot table view.


Obiee10g version is working fine only issues in obiee11g

Thanks in advance...




Thanks

Deva