Passing multiple Values in Input Parameter from SAC t...

[leoalberto80]

Hello,

I have an SQL View which has input parameter for Customer. I have then created an Analytical Model for the SQL view and used it in SAC story.

Unfortunately the variable in SAC can only input one value. User would like to input multiple customers in SAC and these values should be used in the SQL View. Is there any way to achieve it.

I know how to use filters in Analytical Model but the requirement is to use it in SQL View as there are subsequent calculations based on the user input.

[leoalberto80]

Hello. Have you found the way to pass multiple values to one input parameter?

[albertosimeoni]

Hello,

the problem is that the views in Datasphere are SQL views that accept only a single value input parameter.

While the analytic model is a column view (more similar to a calcualtion view) 

=> in fact in recent releases we can manage multiple value variables in model but only for restricted measures and filter variables, but we can not define a multi-value source variable to be mapped to view input parameter.

I add this inprovement request to HANA Cloud database.

https://influence.sap.com/sap/ino/#/idea/356660

After this is unlocked we can ask another for Datasphere itself.

Edit: please upvote this request, it requires 10 upvote it will be "acknowleged".