Oracle Analytics Cloud and Server

Products Banner

FUSION Custom BIP Report Output Displaying NULL as in Column , Instead of blank

Received Response
483
Views
1
Comments

Summary

FUSION Custom BIP Report Output Displaying NULL as in Column , Instead of blank

Content

Hello

We have to pass null values to few columns ,So in data model we are passing NULL as default and same is showing working when we check the data with in data model but  we are seeing this as String in report output instead of blank

Templates .xpt and .rtf 

But when I tested myTemplate through Microsoft word add  then there its giving blank records  in column and  its not showing NULL as string.

Did any one too faces this issue ?

Documents uploaded

1) "WSI AR Franchisee Billing Invoices Report_WSI AR Franchisee Billing Invoices Report (3)" ,Output file generated from BIP 

2) "Data model Output" 

3) "Output generated Through Word ADD"  ,  Output generated through Microsoft word addIn tool

 

 

Regards

Najeeb 

Code Snippet

Data model column

CONCAT(CONCAT('"',rcta.invoice_currency_code),'"')  "Invoice-currency",
  NULL "CompanyAddr",
  NULL "WsiTaxId",
  Null "WsiCompAddr",
  Null "FraPartnerCompName",
  Null "FraPartnerCompAddr",
  Null "FraPartnerTaxid",
  CONCAT(CONCAT('"',rctla.interface_line_attribute14),'"') "CountryId"

Data Model Output.PNG

Answers