SAP Knowledge Base Article - Public

2967427 - Calculated dimension doesn't show complete value list in Set Filter dialog in SAP Analytics Cloud (SAC)

Symptom

  • Calculated dimension doesn't show complete value list in Set Filter dialog in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (Enterprise) 2020.14.11

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a story based on the problematic model.
  3. Add a table/chart with one dimension and one measure.
  4. Create a Calculated Dimension with the following Formula:
    ----------------------
    IF(<the dimension added into table/chart> = (<value list>), "<new value 1>", IF(<the dimension added into table/chart> = (<value list>), "<new value 2>", <the dimension added into table/chart>))
    ----------------------
    => The calculated dimension will show all values correctly in the table/chart.
  5. Try to apply filter (both widget filter and page filter) on the calculated dimension.
    => It doesn't show complete value list in Set Filter dialog and all values are not in alphabet order.

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, 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, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, calculated, dimension, calculation, formula, filter, list, values, order, missing, , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0