Passing Parameters to a HANA View

Post Reply
Bucjeff
Posts: 13
Joined: Tue Jul 28, 2015 4:47 pm
OLAP Product: TM1
Version: Planning Analytics 2
Excel Version: Office 365
Location: Florida USA

Passing Parameters to a HANA View

Post by Bucjeff »

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.
Newb Jeff
10.2.2 FP 3
Excel 2010
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: Passing Parameters to a HANA View

Post by David Usherwood »

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