SAP Knowledge Base Article - Preview

3330897 - "#" is displayed for Null values and "## " for empty values in reports based on HANA Ina (http) connection

Symptom

  • Null and empty values are displayed as # and ## in web intelligence document based on HANA Ina (http).
  • Same behavior for reports based on Datasphere.
  • Same behavior for Analysis for OLAP and Analysis for Office based on HANA Ina (http).
  • "#" values are displayed for Null / Not Assigned data.
  • "##" values are displayed for Blank / Empty data.
  • Null values are displayed as Null and empty via HANA JDBC and OLAP.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform (BI) 4.3
  • SAP BusinessObjects Business Intelligence Platform (BI) 2025
  • Web Intelligence
  • Analysis for OLAP
  • Analysis for Office
  • HANA HTTP
  • Datasphere

Product

SAP BusinessObjects Business Intelligence platform 2025 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

hana http, webi, ao, afo,  olap, null, #, ina , KBA , BI-RA-WBI , Web Intelligence , BI-RA-AO-XLA , Excel Addin , BI-RA-AWB , Analysis, edition for OLAP (Web) , BI-BIP-IDT , Information design tool , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.