SAP Knowledge Base Article - Public

3057677 - Story Table shows hash sign "#" instead of blank in SAP Analytics Cloud?

Symptom

  • When an empty value is displayed in a table, instead of showing blank it displays the hash sign "#" in  SAP Analytics Cloud (SAC).
  • There doesn't seem to be an option to change this behaviour.

Environment

  • SAP Analytics Cloud

Resolution

This is designed behaviour or the SAC table and currently there is no option to change the behaviour.

To work around this a calculated dimension can be added to the table that will display blank when there is not data. For example with a model called "Person" with a dimension "Eye_Colour" a formula that will display as blank instead of "#" can be written like this:

IF( [d/"Person":Eye_Colour].[p/ID]="#"," ",[d/"Person":Eye_Colour] )

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, help, documentation, information, PAM, requirements, ajuda, ayuda, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Using, Working, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PL , Planning , LOD-ANA-PR , SAC Predictive , How To

Product

SAP Analytics Cloud 1.0