SAP Datasphere: Enabling Multiple Selection on Variable (Prompt) Screen

[SCN]

Hello everyone,

I need help enabling multiple selections on SAP Datasphere's prompt screen at the analytical model level. Currently, we can only make a single selection.

We need users to be able to select multiple years, such as 2023 and 2024, as well as ACT and PLN planning categories, so they can compare the two periods.

I've included screenshots showing the current expression in the filter and the prompt screens. Please advise. Thank you. SAP Datasphere 

[Martin_Kuma]

not sure if I understood. You would like to create a filter variable in Analytic Model, which you pass down to the SQL view and you need to select multiple values at once? Did you try this? 

Again, not sure if I understood correctly. 

There is also a nice blog to analytic model and variables: https://community.sap.com/t5/technology-blogs-by-sap/sap-datasphere-analytic-model-series-using-vari...