How to set "0" instead of "null"

31e8341a-0a76-4353-91bb-f63fa296256d · Nov 23, 2016 9:57AM

Hello people

I'm having an issue using obiee 11g:

I have this pivot table:

I want to show a zero instead these blank spaces (i'm asuming these blank spaces are "null" values)

I'm using this condition:

I tried using the "IFNULL" function and it didn't work

Any idea guys? how can i do what i want?

Thank you so much

Greetings from Argentina!

cesar.advincula.o · Nov 23, 2016 10:35AM

Check this link, try the data format .. #, ##0;-#, ##0; 0

31e8341a-0a76-4353-91bb-f63fa296256d · Nov 23, 2016 10:36AM

Already tried it, didn't work for me

Thank u anyways!!

Jasmine Pauline · Nov 23, 2016 11:15AM

This is a Code issue in OBIEE 11.1.1.5.0.

Unpublished Bug 13054445 - replacing null values with "0" in an obiee 11g pivot table is not working has been opened to address this issue

Download and install patch 13054445.

OBIEE 11g: Null Values Displayed in Pivot Table Even if You Change the Custom Numeric Format (Doc ID 1384691.1)

HTH-

Jasmine

[Deleted User] · Nov 23, 2016 1:12PM

Errr your "measure" is a string?!

You literally output '0' and '1' as strings - i.e. letters and not numbers! So the data formatting can't ever work.

P G · Nov 23, 2016 11:53PM

HI

Check this link..

plyskovich · Nov 24, 2016 2:50AM

Can you try this 0+IFNULL(CASE WHEN ... THEN 0 ELSE 1 END ,0)

1036082 · Nov 25, 2016 5:30AM

Please refrer to the below link

MFA for Oracle Community