cancel
Showing results for 
Search instead for 
Did you mean: 

How to use a stored procedure

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member182114
Active Contributor
0 Kudos

Hi Guy,

One option is to use a script calc view and inside it call the procedure, in this case the calc view can work as a wrapper.

Your calc views you apear on fixed schema _SYS_BIC after activation. As example one calcview named tabela on package pacote can be selected like:

select * from "_SYS_BIC"."pacote/tabela";

Regards, Fernando Da Ros

Answers (1)

Answers (1)

rajarshi_muhuri
Active Participant
0 Kudos

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
Advisor
Advisor
0 Kudos

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');