Skip to Content
0
Aug 30, 2018 at 08:29 AM

How to extract data using DS from a HANA calculated view, receiving error.

125 Views

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.