HANA Calculation view to SSRS reporting

[former_member211603]

Hi All,

We have calculation view(CV) built in HANA studio and it has user input parameters. Based on those inputs there are calculated columns created in view.
For reporting, we have built HANA to SSRS ODBC connection and trying to access HANA data.

We are able to access CV data. But there is an issue we are facing, while passing inputs to HANA input parameters. Currently if we hard code input values then we are able to get required data. But how to dynamically pass user inputs from SSRS reports to HANA CV input parameters.

Syntax we tried is:
SELECT col1, col2 FROM _SYS_BIC."HANA_CALCULATION_VIEW_NAME" ('PLACEHOLDER' = ('$$DATE$$','@ACT_DATE'))

DATE is HANA CV input parameter. and ACT_DATE is dynamic variable we are passing from SSRS.

it is giving syntax error for SSRS input parameter. Please help if you have any inputs on this scenario.

[hussein_alaedin]

You can create stored procedures with parameters in hana and call them from SSRS ,that is what we did to have a live ssrs data

[former_member211603]

Hi All,

Any inputs would be really appreciated.

[former_member211603]

Hi All, In continuation to this post, as a workaround, we have removed input parameters from HANA and deleted all calculations from HANA CV created based on input parameters.

In SSRS we have created user input using ? and passed it to HANA column/field DATE to get the data. Now in SSRS we will be doing all the calculations. This is a workaround.

But we really want to have solution to pass input values from SSRS report to HANA input parameters so that all calculations can be done in HANA itself and report performance can be improved.

Please suggest.