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 −

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 More

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

You need to follow below steps to install a new license key in SAP HANA −Step 1 −In the SAP HANA studio, navigate to the properties page of the database for which you have requested the license key.Step 2 −On the properties page, choose the button for installing the license key.Steps 3 −Navigate to your license file and select it.Step 4 −After a successful confirmation, the properties page of the system is updated with the new license information if this is valid for the database.

A new license key is required in the following scenarios −When your current license key is about to expire.You have changed the hardware. As a result, the hardware key has changed. Your database continues to run with a temporary license key that was generated automatically.There is a change of the main memory amount.A change of the system ID of your existing SAP HANA database is planned, for example, due to recovery, copy, and/or renaming. A valid license key for the new system ID must be available for the change to avoid a system standstill.There is a change of the installation ... Read More