- 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.
- SAP Analytics Cloud
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] )
- 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- Search for SAP Analytics Cloud content using Google or Bing:
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
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