SAP Knowledge Base Article - Public

2392748 - Constant values in calculated columns are blank and cannot be filtered in SAP Analytics Cloud

Symptom

  • Using a calculated column assigned to a constant value.
  • When the dimension is added alone to a table, it has no values visible.
  • When a measure is added to the table, the calculated column displays values.
  • It is not possible to use filters via the Builder menu, or via story filters on the dimension.

Environment

  • SAP Analytics Cloud
  • SAP HANA

Reproducing the Issue

  1. Create a calculated view in SAP HANA.
  2. Create a calculated column assigned to a constant value.
  3. Create a model on the view in SAC.
  4. Create a story using the model.
  5. Add the calculated column and try to filter on it.
  6. Observe that no values are available to filter on.

Cause

This behaviour is by design as per Note 1764662.

Resolution

For every table which has a calculated column, select a measure and enable the Keep Flag

See Also

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

Keywords

c4a, analytics, story, chart, union, join , KBA , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem

Product

SAP Analytics Cloud 1.0