Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP Basis Articles
Page 21 of 50
Using Text join in SAP HANA
In SAP HANA, you can use Text join to fetch description based on user’s session language. When a text join is used, it finds out details in user’s preferred language.Text join can be applied on below modeling objects in SAP HANA −Attribute ViewAnalytic ViewCalculation View
Read MoreExample of using Text join in SAP HANA
To implement Text join, create a table −CREATE COLUMN TABLE TEST.P_INFO (PROD_ID BIGINT, P_CAT NVARCHAR(50)); INSERT INTO TEST.P_INFO VALUES (11, ’FURNITURE’); INSERT INTO TEST.P_INFO VALUES (14, ’ELECTRONICS’); INSERT INTO TEST.P_INFO VALUES (25, ’FURNITURE’); INSERT INTO TEST.P_INFO VALUES (76, ’ELECTRONICS’);2nd table −CREATE COLUMN TABLE TEST.PROD_DESC (PROD_ID BIGINT, LANGUAGE NVARCHAR(10), DESCR NVARCHAR(100)); INSERT INTO TEST.PROD_DESC VALUES (11, ’E’, ’Table’); INSERT INTO TEST.PROD_DESC VALUES (11, ’D’, ’Chair’); INSERT INTO TEST.PROD_DESC VALUES (14, ’E’, ’32 LED’); INSERT INTO TEST.PROD_DESC VALUES (14, ’D’, ’32 inch LCD’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Comp Table’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Mixer’);Note that it should have ...
Read MoreUse of savepoints in SAP HANA
In SAP HANA database, changed data is automatically saved from memory to disk and at the interval on which it is saved is called savepoints and by default they are set to occur every five minutes. In SAP HANA, there is a persistence layer which is used to make these savepoint at regular interval. During this operation changed data is written to disk and redo logs are also saved to disk as well.The data belonging to a Savepoint tells consistent state of the data on disk and remains there until the next savepoint operation has completed. Redo log entries are ...
Read MoreSetting savepoint manually in SAP HANA system
You can run savepoint manually by executing the below command −ALTER System SAVEPOINTChecking savepoint statistics of SAP HANA
Read MoreUse of Persistence layer in SAP HANA
SAP Persistence layer is required in the following scenarios −In any database, main memory is volatile therefore data is lost during a restart or when a power outage occurs.Data needs to be stored in persisted medium.Backup & Restore is available.It ensures that the database is restored to the most recent committed state after a restart and that transaction are either completely executed or completely undone.
Read MoreUsing column base tables in SAP HANA Calculation view with Star Join
It does not allow base column tables, Attribute Views or Analytic views to add at data foundation. All Dimension tables must be changed to Dimension Calculation views to use in Star Join. All Fact tables can be added and can use default nodes in Calculation View.For more details, you can refer our tutorial link −https://www.tutorialspoint.com/sap_hana/sap_hana_calculation_view.htmYou have four tables, two Dim tables, and two Fact tables. You have to find list of all employees with their Joining date, Emp Name, empId, Salary and Bonus.This can be achieved using Calculation view with Star Join. You need to convert column based tables to ...
Read MoreChanging language in Text join in SAP HANA
To change the language, go to Additional Properties tab in Database user logon and change the language as shown below −
Read MoreUsing Text join in SAP HANA Modeling
To create an Attribute view, you have to navigate to Content tab → Package → New → Attribute ViewYou can select any of view type to implement a Text join in HANA.Add both the tables to Data Foundation and in Join type select Text join as shown below −Next is to save and activate Attribute view and text join is used.
Read MoreChanging default schema in SQL console in SAP HANA
To change the default schema, you have to select schema name from Catalog folder and click on SQL tab at the top.You can also right click on Schema in which you want to create Relational objects and select Open SQL Console. In below pic, you can see the Schema AA_HANA11 and right click → Open SQL Console.At the top of SQL console, you can see Schema name where the objects will be created using this console.
Read MoreGranting _SYS_REPO with SELECT to user schema in SAP HANA
In SAP HANA system _SYS_REPO user is required to create run time objects that are saved in HANA database under _SYS_BIC schema. When you activate modeling views in HANA, SYS REPO provides the read access to users on these modeling views. That is why it is required to grant _SYS_REPO with SELECT with GRANT privilege to user schemas.GRANT SELECT ON SCHEMA "SCHEMA_NAME" TO _SYS_REPO WITH GRANT OPTIONThis is required when you use objects of a table/view of a schema to build HANA Modeling Views. You need to grant _SYS_REPO the SELECT WITH GRANT privilege on this schema.
Read More