Procedures in SAP HANA
DROP PROCEDURE (New Syntax)
Syntax
Drop procedure [schema] name [cascade]
Description
Drops a procedure created by create procedure from the database catalog. If cascading abrupt is defined, dependent objects will also be dropped.
Otherwise, they are in validated. After cascading drop, a procedure with the same name can be created which can make the previously invalidated dependent objects valid again.
Procedure Calls
A procedure can be called by client our the outer most level using any of the separated client interfaced or with in the body of procedure.
CALLS – PROCEDURE CALLED FROM CLIENT (DEPRECTED) SYNTAX)
SYNTAX:-
CALLS [schema.] name (paraml[,…])
Example:-
CREATE FUNCTION GET OUTPUT (IN CUT INT EUR, IN currency VARCHAR (3),
OUT output – puts it –publishers,
OUT output –year It – years)
If the above function is called using
Calls get output (1000,”’ EUR”’, ot—publishers, null);
| Variable | Table |
| OUT PUT – PUBS | “System”. ‘OT – PUBLISHERS” |
| OUT PUT – YEAR | “system”. “OUTPUT – yare – 4cf5faobf9397f88e10000000a12737f |
Learn the core features of SAP HANA and become master with our expertise Training.
Internal Procedure Syntax
CALLS [schema.] name (@ assigned – variable@ borrd – variable)
Example
Calls add discount (@1st – expensive-books@, it – on – sale_;
Example
Calls add discount (@1st – expensive-books@, it – on – sale_;
Add discount function is called. The variable@ it_expensive – books@is assigned to the function and the variable IT – on – sales is bound by this function call.
Note
For procedures CALLS will be sup laced by call <procedure Name> (<procedure parameters>) or
Call <procedure name> (<procedure parameters>)
With overviews
CALL – PROCEDURE CALLED FROM CLIENT (NEW SYNTAX)
SYNTAX:-
CALL [SCHEMA.] name ( parmlt,….])
Example:-
CALL add discount (books, Null. ?):
CALL – WITH OVERVIEW FROM CLIENT (NEW SYNTAX)
SYNTAX:-
CALL [SCHEMA.] name (param [,…]) with overview
Example:
CREATE FUNCTION get out put (in cut integer, in currency,
VARCHAR (3),
OUT output – puts tt – publishers,
OUT output –year tt-years)
If the above procedure
CALL get out put (100, “’EUR”’, ot – publishers, null) with overviews;
Returns the following table:-
| Variable | Table |
| OUP PUT – PUBS | “SYSTEM” . “OT – PUBLISHERS” |
| OUT PUT – YEAR | “SYSTEM” . “OUTPUT – YEAR – YAR 4CFSFAOBF9397F88E10000000A12737F” |
CALL-INTERNAL PROCEDURE CALL (NEW SYNTAX):-
SYNTAX:-
CALL [Schema.] name (:in-paraml, out—parmi [,…])
Appendix:
SAP Business Objects Advanced Analysis
Before performing advanced analysis in business objects me need to perform modeling his HANA database
The BO analysis for Microsoft office
SAP BO analysis is additions for ms-office address that allows multi dimensional analysis of olap sources in Ms-Xcel and Ms-Excel work book design
And intuitive creation of BI presentation with ms-power point the will be available for
1) Ms office 2010 (Excel and power point)
2) Ms office 2007 (excel and power point)
3) Ms office 2003 ( excel)
In the edition for Microsoft office you can use SAP BEX query views net weaver BW info provider and HANA tables & analytics & calculated views
The data is displayed in the workbook & crosstabs we can insert multiple gross tabs with data from different sources
Using design parcel we can analyze the data and change the view an display data
Working with analysis in Microsoft office 2010
There are three options available in Ms-office
File ------ >add ims
Open Data source
Open work book
Save work book
Activities in excel
DATA source
Undo
Data analysis
Display
Insert component
Tool
Planning
Design panel
Settings
Activities in power point
Data source
Undo
Filter and sort
Display
Insert component
For an Indepth knowledge on SAP HANA, click on below