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
- Open the story in SAP Analytics Cloud.
- Input the dates (first variable) in the prompt.
- 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
SAP Knowledge Base Article - Public