SAP Knowledge Base Article - Public

2807570 - "A non-empty value must be used in the comparison" appears after SAP HANA datasources have been changed in a SAP Analytics Cloud (SAC) story

Symptom

  • After views have been remapped all tables are blank in the story.
  • It seems some of the links between the original story and the new HANA views are broken.
  • Story Filters can not be removed.
  • While doing some actions error message being returned as response from GetResponse calls: 

Number: 42473
Text: "A non-empty value must be used in the comparison"
Type: 2

Environment

  • SAP Analytics Cloud 2019.8
  • SAP HANA Cloud Platform

Cause

Invalid filters regarding changed variables haven't been removed automatically from the Story. When variables are changed in database, the saved variable filter information in frontend story is invalid. We need to either migrate or
remove those inconsistent filters.

Resolution

Fix has been released in Wave 2019.16 to let users to remove stuck filters and auto-correct it.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics empty, white, remove, delete tables, grid, , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning Functionality, Planning Models , LOD-ANA-BR , Digital Boardroom (DiBo) , LOD-ANA-PR , Predictive Scenarios, Smart Predict , Problem

Product

SAP Analytics Cloud 1.0