I am trying to extract data from a HANA calculated view. When I try to run the extract I receive an error message that the SQL statement is incorrect. If I try to update the schema in the SQL transform I receive the following error:
ODBC Data source <HANA> error message for operation <OdbcDB::describeQuery>: [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 SQ syntax error ; incorrect syntax near "{": Line 4 col 42 (at pos 148)>. BODI-1130199
Here is the syntax I am using:
SELECT * FROM "_AccessHANA"."HANA.HANA.app-tal-ana.app-hcm/CV_RPT_BIG_METRICS_VIEW" ('PLACEHOLDER' = ('$IP_STARTFYPERIOD$',{$G_FY2015B}),'PLACEHOLDER' = ('$IP_ENDFYPERIOD$', {$G_FY2015E}))
Any help would be greatly appreciated with why this is erroring out when passing in the required parameters.