Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to set "0" instead of "null"

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!
Answers
-
Check this link, try the data format .. #, ##0;-#, ##0; 0
http://kapildeopatil.blogspot.pe/2012/02/replace-null-values-in-pivot-table.html
0 -
Already tried it, didn't work for me
Thank u anyways!!
0 -
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
0 -
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.
0 -
HI
Check this link..
How to Replace Null Values in an OBIEE Pivot Table : Total Business Intelligence
0 -
Can you try this 0+IFNULL(CASE WHEN ... THEN 0 ELSE 1 END ,0)
0 -
Please refrer to the below link
http://total-bi.com/2010/10/replace-nulls-in-obiee-pivot-table/
0