TM1 Forum

Hi all,

Connecting to a HANA 1.0 revision 122 view via ODBC.

Standard selections are working fine. When I need to pass parameters into the view/query is where I am lost on the proper syntax. I have pFiscalPrd and pSource setup as string parameters. Here is the sql. The 2 Enter Value is where I want my parameters to go.

SELECT
"_BIC_TNCOMPCOD",
"_BIC_TNMANUFAC",
"_BIC_TNCBPCUST",
"_BIC_TNCOSTCTR",
"_BIC_TNPROFITC",
"CALMONTH",
"SOURSYSTEM",
"_BIC_TNMATERIL",
"_BIC_AAGRACCOU",
"LOC_CURRCY",
"UNIT",
"FISCPER",
sum("QUANTITY") AS "QUANTITY",
sum("DEB_CRE_LC") AS "DEB_CRE_LC"
FROM "_SYS_BIC"."ZGLOBAL.ZGLOBAL_TD.FI/TDGLHV001" WHERE (("SOURSYSTEM" IN ('<Enter Value>'))) AND (("FISCPER" IN ('<Enter Value>')))
GROUP BY "_BIC_TNCOMPCOD",
"_BIC_TNMANUFAC",
"_BIC_TNCBPCUST",
"_BIC_TNCOSTCTR",
"_BIC_TNPROFITC",
"CALMONTH",
"SOURSYSTEM",
"_BIC_TNMATERIL",
"_BIC_AAGRACCOU",
"LOC_CURRCY",
"UNIT",
"FISCPER"


Thanks in advance for any assistance.

In the Prolog, build up the query with the parameters you want as a string and write it to the local variable DATASOURCEQUERY.