SAP Knowledge Base Article - Public

3657137 - Variable prompts are not cascading in Datasphere

Symptom

  • You want to implement hierarchical (cascading) variable prompts - i.e., filtering the available values of one prompt based on the selection made in another.
  • Variable prompts are not cascading and only showing values based on the first date prompt selection

Environment

  • SAP HANA Multidimensional Services MDS / InA
  • SAP Datasphere

Reproducing the Issue

  1. Open the story in SAP Analytics Cloud.
  2. Input the dates (first variable) in the prompt.
  3. Open the member selector for the other variable prompt. And the values aren't filtered based on date selection/first variable

Resolution

Unfortunately, this functionality is not part of our SAP Datasphere product yet.

You can create an improvement request for this feature through the SAP Datasphere Customer Influence platform.

See Also

3483200 - Hierarchy option in Filter Variable prompt in Analytic Model is not available

Keywords

cascading, Datasphere, SAP Analytics Cloud, variable prompts, live data connection, input controls, date range filtering, cascading settings. , KBA , HAN-DB-ENG-MDS , SAP HANA Multidimensional Services MDS / InA , Problem

Product

SAP Datasphere all versions