Procedures In SAP HANA

Drop Procedure (New Syntax)

Syntax: Drop procedure [schema] name [cascade]

Description: Drops a procedure created by creating a procedure from the database Catalog. If cascading abrupt is defined, dependent objects will also be dropped. Otherwise, they are invalidated. 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 the client our the outermost level using any of the separated client interfaced or within the body of the procedure. CALLS – PROCEDURE CALLED FROM CLIENT (DEPRECATED) 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
OUTPUT – PUBS	“System”. ‘OT – PUBLISHERS”
OUTPUT – YEAR	“system”. “OUTPUT – yare – 4cf5faobf9397f88e10000000a12737f

Internal Procedure Syntax CALLS [schema.] name (@ assigned – variable@ borrd – variable)

Example Calls add a discount (@1^st – expensive-books@, it – on – sale_;

Example Calls add a discount (@1^st – 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 a discount (books, Null. ?):

Call – With Overview From Client (New Syntax)

SYNTAX:- CALL [SCHEMA.] name (param [,…]) with an overview

Example: CREATE FUNCTION get output (in cut integer, in currency, VARCHAR (3), OUT output – puts tt – publishers, OUT output –year tt-years) If the above procedure CALL get output (100, “’ EUR”’, ot – publishers, null) with overviews;

Returns the following table:-

Variable	Table
OUTPUT – PUBS	“SYSTEM”. “OT – PUBLISHERS”
OUTPUT – YEAR	“SYSTEM” . “OUTPUT – YEAR – YAR 4CFSFAOBF9397F88E10000000A12737F”

Call-Internal Procedure Call (New Syntax):-

SYNTAX:- CALL [Schema.] name (:in-paraml, out—parmi [,…])

If you want to enrich your career and become a professional in SAP Hana, then visit Tekslate - a global online training platform: "SAP Hana Administration Training" This course will help you to achieve excellence in this domain.

SAP Business Objects Advanced Analysis

Before performing advanced analysis in business objects my need to perform modeling his HANA database

The BO analysis for Microsoft office

SAP BO analysis is additions for an ms-office address that allows multidimensional analysis of OLAP sources in Ms-Xcel and Ms-Excel workbook design And intuitive creation of BI presentation with the ms-power point the will be available for

1) Ms office 2010 (Excel and PowerPoint)

2) Ms office 2007 (excel and PowerPoint)

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