SAP Knowledge Base Article - Public

3059153 - Error "Wrong cardinality: 'Parameter Name', Please select a single cardinality" using parameter in Advanced Formula context

Symptom

  • Cannot select multiple values in prompt in Advanced Formula
  • Error "Wrong cardinality: 'Parameter Name', Please select a single cardinality"
  • Setting "Any" for Cardinatily in Parameter setting
  • Using the parameter in Context in Advanced Formula Step

Environment

  • SAP Analytics Cloud (Enterprise) 2021.10.1

Reproducing the Issue

Context has be defined again with the parameter after changing its Cardinality. Then text script should be changed based on Parameter configuration.

Currently below are supported for dimension member Parameter with Cardinality : Any and Level : Any at the same time.

Cardinality : Single  &   Level : Leaf   >> Supported
Cardinality : Single  &   Level : Any    >> Supported
Cardinality : Any     &   Level : Leaf    >> Supported
Cardinality : Any     &   Level : Any     >> Not Supported

If you would like to use Any Cardinality for dimension member parameter, set the change Level to  "Leaf".

Cause

Define context with the parameter again after changing its Cardinality. 
Then text script should be changed based on Parameter configuration.

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-PL-AF , Advanced Formulas , Problem

Product

SAP Analytics Cloud all versions