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 (@1st – expensive-books@, it – on – sale_;
Example Calls add a 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 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