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?