SAP Knowledge Base Article - Preview

2869646 - Analysis Office shows # for NULL / Not Assigned and ## for Empty / Blank records

Symptom

When executing a HANA data source in Analysis Office, the tool displays the following:

ID/Key value in Analysis Office ID/Key value in HANA
#

Null / Not Assigned

##

Blank / Empty


Read more...

Environment

Analysis for Microsoft Office

Product

SAP Analysis for Microsoft Office all versions

Keywords

null, empty, values, id, text, blank, not_assigned, #, ## , KBA , BI-RA-AO-XLA , Excel Addin , 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.