HANA Modeling

 

1. Inner join: http://basisbynaveen.blogspot.com/2022/09/inner-join-syntax.html                                 
2. Left Outer: http://basisbynaveen.blogspot.com/2022/09/left-outer-join.html                                     
3. Right Outer Join: http://basisbynaveen.blogspot.com/2022/09/right-outer-join.html                         
4. Full Outer Join: http://basisbynaveen.blogspot.com/2022/09/full-outer-join.html                             
5. Referential Joins: http://basisbynaveen.blogspot.com/2022/09/referential-joins.html                      

6. Employee dimension calculation view :

7. http://basisbynaveen.blogspot.com/2022/09/employee-dimension-calculation-view.html
8. Calculated column with 2 projections and 1                                                                                          join: https://basisbynaveen.blogspot.com/2022/09/calculated-column-with-2-projections.html
9. Different types of Nodes: https://basisbynaveen.blogspot.com/2022/09/different-types-of-nodes.html                                                                                                                                            
10. Restricted column: http://basisbynaveen.blogspot.com/2022/09/restricted-column.html                  
11. Smart Data Integration (SDI) & Smart Data Access (SDA) introduction and installation :   https://basisbynaveen.blogspot.com/2022/09/smart-data-integration-sdi-smart-data.html    
12. Importing data and Build your own models: https://basisbynaveen.blogspot.com/2022/09/importing-data-and-build-your-own-models.html        
13. Create HANA DB remote connection: https://basisbynaveen.blogspot.com/2022/09/create-hanadb-remote-connection.html
14. Create MTA (Multi Target Application) project: https://basisbynaveen.blogspot.com/2022/09/create-mtamulti-target-application.html
15. UAA setup - Access between tenant and HDI: https://basisbynaveen.blogspot.com/2022/10/uaa-setup-access-between-tenant-and-hdi.html
16. 
    

tunning with saptune

 

Backup and recovery introduction

 what is persistence layer?

persistence layer is required to ensure that the HANA system can be restarted or restored back to the last consistent state in case of a power failure or abrupt shutdown or system failure.

    Database data is stored 2 places:

         1. Data volumes.
         2. Log volumes.


1.Data volume:

    It contains system data, Application data and undo logs
    it write data in Async mode.

    

2. Log volume:

Redo logs store the changes to the data (insert, update , Delete).

Synchronous writes on commit.

Savepoint: changed data and undo logs are written from memory to disk.

                     default every 5 minutes

                     Automatic execution.

to take complete backup of system, need 3 things:

1.  Complete backup.
2.  incremental / differential backups.
3. Most recent log entries from the log area.

    

Prerequsites to rename tenant database

 * Tenant DB should be in stopped status.

* You have the system privilege DATABASE ADMIN.

* The database to be rename is not part of a copy operation or move operation.

* The database to be renamed does not have system replication active.

*The database to be rename does not have the SAP HANA dynamic tiering option.

SAP ABAP server start up issue - cleanup all the start logs

 1. Login server @ OS level with <sid>adm.