Question Re: Passing multiple Values in Input Parameter from SAC to SAP Datasphere SQL View in Technology Q&A

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

akashsingh — Tue, 25 Apr 2023 14:21:08 GMT

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.

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

former_member106189 — Tue, 25 Apr 2023 19:06:34 GMT

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.

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

leoalberto80 — Fri, 25 Oct 2024 17:31:49 GMT

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

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

Neetha_Raju — Fri, 23 May 2025 15:14:25 GMT

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

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

albertosimeoni — Wed, 17 Sep 2025 10:25:24 GMT

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