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  

Working with analysis in Microsoft office 2010

There are three options available in Ms-office File ------ >add ims

Open Data source

Open workbook

Save workbook

Activities in excel:

DATA source

Undo

Data analysis

Display

Insert component

Tool

Planning

Design panel

Settings

Activities in PowerPoint

Data source

Undo Filter 

sort Display

Insert component

For in-depth knowledge on SAP HANA, click on below

• Performance Tuning in SAP HANA
• Security in SAP HANA
• Organizing system Landscapes in SAP Hana
• Analytical Privileges in SAP HANA
• Security in SAP HANA
• SAP HANA Views