SAP Developer has Published 85 Articles

Using Text join in SAP HANA

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:16:56

208 Views

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

Example of using Text join in SAP HANA

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:16:14

584 Views

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)); ... Read More

Use of savepoints in SAP HANA

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:12:36

562 Views

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 ... Read More

Setting savepoint manually in SAP HANA system

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:11:50

163 Views

You can run savepoint manually by executing the below command −ALTER System SAVEPOINTChecking savepoint statistics of SAP HANA

Use of Persistence layer in SAP HANA

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:10:38

157 Views

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 ... Read More

Real time data replication in SAP HANA

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:09:52

656 Views

SAP HANA Replication allows migration of data from source systems to SAP HANA database. Simple way to move data from existing SAP system to HANA is by using various data replication techniques.System replication can be set up on the console via command line or by using HANA studio. The primary ... Read More

Using column base tables in SAP HANA Calculation view with Star Join

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:08:53

275 Views

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 ... Read More

Using Calculation views inside another calculation view in SAP HANA

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:07:13

434 Views

Yes, Calculation views are composite views and they can be used to combine other views. You can consume other Analytical, Attribute, and other Calculation Views & tables. It can perform complex calculations not possible with other views.

Changing language in Text join in SAP HANA

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:06:26

322 Views

To change the language, go to Additional Properties tab in Database user logon and change the language as shown below −

Using Text join in SAP HANA Modeling

SAP Developer

SAP Developer

Updated on 24-Feb-2020 06:05:40

199 Views

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 ... Read More

Advertisements