SAP Knowledge Base Article - Public

2665613 - Thresholds disappear in a table after applying a filter on a dimension in SAP Analytics Cloud

Symptom

  • Threshold defined on the table on a particular column works correctly.
  • When applying filter to the particular metric dimension values, threshold disappears.

Environment

  • SAP Analytics Cloud 2018.12
  • Live Data Connection to SAP HANA

Reproducing the Issue

  1. Create a Story based on a HANA Live model.
  2. Add a table and create a new threshold (thresholds are displayed correctly).
  3. Apply a filter on any of the dimensions in the thresholds (thresholds all disappear)

Cause

The updated filter could cause a conflict between 2 thresholds on the same dimension, and as such we let the user choose which one to show.

Resolution

When you add the filter to the story/page/table, the threshold should remain there (since it covers a broader scope than the one you have). The threshold is only hidden if you modify a filter on the threshold itself.

Workaround:

  1. After you observe that the thresholds disappeared, toggle the Show Thresholds option off and on. (More see in SAP KBA 2527389)
  2. The threshold is being displayed correctly.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

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 , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0