SAP Knowledge Base Article - Preview

2621944 - Key value (#) is shown instead of the blank Text value (null) of a BEx characteristics in SAP Front-End reporting tools based on BICS layer


  • When executing a report based on a BEx query through the BICS layer, the Key value appears of the BEx characteristics instead of the Text value, which is empty (null).
  • Expectation would be to return the empty (null) Text value, instead of the Key value, which is a # in this case.
  • The behavior is the same in all front-end reporting tools that is using the BICS layer, such as Crystal Reports, Web Intelligence, Analysis for Office, Design Studio.
  • Still the Key value is shown after setting the parameter BICS_INFOOBJECT_TEXT_DISPLAY = X in RSADMIN as described in SAP Note 2404184.
  • When setting the Characteristic Presentation to Key in RSRT:
    Characteristic Properties Key.png
  • We can see that it shows the Key value (#).
    RSRT Key #.png
  • When setting the Characteristic Presentation to Text in RSRT:
    Characteristic Properties Text.png
  • It shows the empty Text values (null).
    RSRT Text Empty.png
  • However, when creating a report in any of the mentioned reporting tools (here is an example from Crystal Reports), we can see that the Key value (#) is retrieved instead of the Text value (null).
    Crystal Text #.png
  • The same behavior is observed when executing the BEx query in Information Design Tool (IDT) in Query Panel (from BI 4.2 SP3 and newer).
    IDT #.png

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



  • SAP BusinessObjects Business Intelligence Platform 4.x
  • SAP Analysis for Microsoft Office
  • SAP Crystal Reports
  • SAP Crystal Reports for Enterprise (CR4E)
  • SAP Web Intelligence
  • Information Design Tool (IDT)


SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2


bi, boe, bw, bex, bics, webi, crystal, cr, cr4e, empty text, null, blank, missing, key, #, not assigned , KBA , BI-RA-WBI , Web Intelligence , BI-RA-AD , Design Studio End Of Maint Note 2622437 , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-BIP-SL , Semantic Layer , BI-RA-CRE , Crystal Reports for Enterprise , Problem

About this page

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

Search for additional results

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