• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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

Summary
Review Date
Reviewed Item
Procedures in SAP HANA
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Procedures in SAP HANA"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.