Hello experts,
I am now building some reports based on SAP HANA with SSRS, I want to create some user interactions forms to let users change some filters and then update the reports. But I did not find how to create parameter for HANA, I tried below query, but it did not work. Anyone has any suggestion or experience on this?
SELECT
COMPANY_CODE ,
PLANT ,
PERIOD
FROM
ZAMSBW.ESC_VARIANCE_SNAPSHOT_TBL
WHERE
COMPANY_CODE = $$Company_Code$$