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 More

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.

In SAP HANA, Persistence layer is used for handling all operational and transaction data to take secure backup and restoring data incase of corruption or database crash. It provides use of Save point which can be used for restoring data.With use of concept of persistence layer of SAP’s relational database, it ensures the successful data restores. Besides managing log data on the disk, HANA’s persistence layer allows read and write data operations via all storage interfaces.Persistence layer in HANA ensures that database can be restored to the most recent committed state after a restart or after a system crash and ... Read More

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 ECC or transaction systems can stay online during this process. We have three types of data replication methods in HANA system −SAP LT Replication methodETL tool SAP Business Object Data Service (BODS) methodDirect Extractor connection method (DXC)These methods are based on different mechanism of data replication and is recommended for ... Read More

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 More

Like other database, you can insert rows in column based table in SAP HANA using Insert statement. Insert statement can be written in SQL editor in HANA.To open SQL editor, you can select HANA system and click on SQL sign at top.Below SQL statements can be used to insert the data −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’);Read More

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.

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

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.

When you use a Text join in SAP HANA, following condition should be met −You should have Text table always on the right side in joinThere should be a Language columns definedBelow shows an example of Attribute join where Language column is used in text join −