Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Null value on my OLAP report
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Null value on my OLAP report
 Login/Join
 
Member
posted
I am trying to create a condition on my OLAP report. I want to display information when the Revenue source is not NULL. In the report output, the value is displayed as ".". I have tried specifying the condition as: When RevenueSource <> (.,".",NULL, ," ","",etc.) but haven't been able to filter Revenue Sources with "." out.

Does anyone know how to fix this issue?

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.7.2: Windows 7: all output (Excel, HTML, PDF)
 
Posts: 18 | Registered: June 22, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
. is the display value.
The FOCUS keyword for SQL NULL is MISSING.
WHERE field EQ MISSING ;


Brian Suter
VP WebFOCUS Product Development
 
Posts: 200 | Location: NYC | Registered: January 02, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
Also don't use <>, use NE.

And if you ever want to check a list, use WHERE FIELD IN (item1,item2,itemn) or WHERE NOT FIELD IN (item1,item2,itemn). MISSING cannot be in this list, it must be by its self.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6131 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
Member
posted Hide Post
Thanks guys. "MISSING" worked just fine.


WebFOCUS 7.7.2: Windows 7: all output (Excel, HTML, PDF)
 
Posts: 18 | Registered: June 22, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Null value on my OLAP report

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.