I am trying to extract data from SAP HANA calculation views, where all views have prefixes like prod.fi/view_name
e.g. prod.fi/cv_bseg, prod.md/cv_mseg etc.
SQL Query --select * from prod.fi/cv_bseg (this works great in SAP HANA so i know syntax is right)
Not sure if escape characters like "/" in the calculation view name is causing this.
SAP Connection is built successfully using tsapHANAInput and i have tested this if i query small table directly which works for statement like "select * from BSEG".
I have also tried playing around sql query tsapHANARow but no success.
(reading other topics i tried something like prod.fi//cv_bseg or prod.fi/\\cv_bseg) for escape characters but its not doing the trick.
