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.
Passing Parameters to a HANA View
-
- 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
Newb Jeff
10.2.2 FP 3
Excel 2010
10.2.2 FP 3
Excel 2010
-
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: Passing Parameters to a HANA View
In the Prolog, build up the query with the parameters you want as a string and write it to the local variable DATASOURCEQUERY.