I am currently connecting to SAP HANA database using a SQL Open Connection in Pipeline Pilot 2019. I have been asked if PP accepts/utilizes Input Parameters (not where clause parameters), but I am having troubles passing them in. Here is an example SQL statement that would work in HANA Studio, but not in PP. Any help would be appreciated
SELECT TOP 1000
“date”,
“product”,
SUM(“productRating”) AS “productRating”,
SUM(“amount”) AS “amount”
FROM “INPUTPARAMETERS_HDI_DB_1”.”inputParameters.db::example4″
(placeholder.”\$\$IP_1\$\$”=>’ ‘ ‘oranges’ ‘,’ ‘apples’ ‘ ‘)
GROUP BY “date”, “product”;