SAP Knowledge Base Article - Public

2886873 - The value in the filter cannot be searched for a Calculation Dimension in SAP Analytics Cloud (SAC)

Symptom

The value in the filter cannot be searched for a Calculation Dimension in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (Enterprise) 2020.2.2

Reproducing the Issue

  1. Create a model contains very large data.
  2. Based on this model, create a story. 
  3. In the story, add a crosstab to display the data from the model.
  4. Add a Calculated Dimension into this crosstab.
  5. Now add Page filter based on one normal dimension and this Calculation Dimension.
  6. Try to search a value in the filter.
  7. Note that, for Calculation Dimension, the search didn't return data. While this search works well for the normal dimension.

Resolution

This issue is currently a product limitation.

  • For normal dimension, the back-end server search is enabled. Therefore there is no limit for the data displayed in the filter. And user is also able to search any value inside the filter.
  • However for Calculation Dimension, the back-end server search is not implemented. The search scope will be limited to the first 4000 values. Therefore, for the data which is not in the list of first 4000 data, the search will return no data.

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 , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0