SAP Knowledge Base Article - Public

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

Environment

Analysis for Microsoft Office

Cause

This is not a bug in the tool, but the intented behavior since AO 2.5 SP2, as explained in SAP note below:

>> 2257472 - Display of empty keys from HANA views in Analysis clients

Resolution

Refer to SAP note below:

>> 2343234 - Usage of Members # and ## in the SAP HANA Database in Analysis Office / Design Studio and Analysis OLAP

Keywords

null, empty, values, id, text, blank, not_assigned, #, ## , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions