Passing multiple Values in Input Parameter from SAC to SAP Datasphere SQL View

[akashsingh]

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?

[former_member106189]

I envisage that the problem could bethat the Filter that’s been added within Datasphere uses ‘equal to’ which is therefore expecting one single value.

If you change the Filter to ‘like’ in order to take multiple values then attempt the SAC story prompt generation again.

No promises as I’m away from my desk but suspect that this is the issue.

[Neetha_Raju]

Has anyone found any way out for this issue as we are also looking for similar kind of functionality?

[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".