How to use a stored procedure

[Former Member]

Can i create a stored procedure referencing analytic views / attribute views instead of tables

If i have a stored procedure with all logic it gets created under schema / procedures.

Now, where can i use the above created procedure, is it possible to directly call from BO reports universe?

I want to see from how many ways can this stored procedure be called by, is it from sql script based calc views?

I am really good at using stored procdures on dot net based environment sp's based on sql server.

This is the first time trying to understand the sap hana.

Kind regards,

Roger

[rajarshi_muhuri]

you can call the procedure from anywhere as long you call it with right parameters/ signature

1. you can call the procedure in a sql script

2. call it in hana modeller

3. call it via data services

4. call it via a java call

but not sure where would you put that call statement in a BO report though

[DavidSmith]

How would you call the SP in HANA from Data Services?  I have to do this and get errors from a SQL Transform.  for example I need to call this SP from a data flow:  CALL "OWNER"."SP_TEST1('USERNAME1');