Accesing HANA Stored Procedure in IDT

[Former Member]

Hi ,

I have a stored procedure in HANA and I need to access in IDT for my dashboard .

Could you please let me know how to access the HANA stored procedure in IDT.

PS: Stored Procedure has some INPUT Param, OUT parameter and I need to write back to HANA tables once I get input parameter from Dashboard.

Regards,

Nagaraj

[henrique_pinto · Accepted solution]

Hi Nagaraj,

I suppose the best way would be to create this procedure with the "WITH RESULT VIEW" option, which will then enable a column view that can be queried from your Universe. In BO, you can use a Derived Table to be able to define the PLACEHOLDER statement to send the input parameter to the Column View.

Check pages 16 & 17 of the HANA SQLScript guide for more details.

[former_member650725]

Hi Nagaraj,

I meet the same question with you.

Do you know how to do? If you knows, can you share with me the detial? Thank you!

Best Regards,

Yan

[Former Member]

Hi Nagaraj,

You cannot access HANA stored procedure in IDT, but for the same purpose you can use Calculation views which also accept IN parameter and returns output parameter as table type, which you can access in IDT.

Hope it will helpful for you.

-Ruchi