How to use a stored procedure

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