SAP Knowledge Base Article - Public

2733467 - Aggregation type set to NONE not working when a threshold is applied in SAP Analytics Cloud (SAC)

Symptom

When a threshold (with a comparison measure) is applied to a blank measure in a table object, the measure now displays a value when it should still be blank.

Environment

  • SAP Analytics Cloud 2018.22.2

Reproducing the Issue

1. Open the sample model BestRunJuice_SampleModel
2. Go to Account and modify the Aggregation Type for measure Quantity_sold, set it to "NONE"
3. Save the model 
4. Create a story, Add a canvas Page 
5. Add a table to your page 
6. Select existing model BestRunJuice_SampleModel
7. Select to display only Quantity_sold measure 
8. See that aggregation type set to NONE is working for now as we don't see any data in the table 
9. Configure a threshold by using a comparison to a measure  It doesn't a matter if this means nothing from a business point of view, this example is just to show you the behavior.
10. See that now, data is displayed for the measure Quantity sold, and this is not the expected behavior.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

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 , 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