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
Articles by SAP Developer
Page 6 of 7
Using 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 MoreImage format supported in SAP HANA Modeling view export
There are different Image format options available:
Read MoreAccessing SAP HANA Cockpit for offline administration
The SAP HANA cockpit for offline administration is accessible at https://:1129/lmsl/hdbcockpit//index.html or http://:1128/lmsl/hdbcockpit//index.html. You can also navigate to the SAP HANA cockpit for offline administration from the standard SAP HANA cockpit.With use of SAP HANA cockpit for offline administration, it displays content as tiles that function as entry points to individual applications.
Read MoreDifferent tiles in SAP HANA Cockpit offline administration
When you open SAP HANA Cockpit for offline administration, following tiles are available:
Read MoreSpecify a stop wait timeout (date and time) in SAP HANA
You can also stop HANA system by setting date and time and this comes under Soft stop.In case you don’t shut down the system before the specified timeout, it is shut down forcefully.
Read MoreDifference between stop and kill a service in SAP HANA
Stop...The service is stopped normally and then typically restarted.Kill...The service is stopped immediately and then typically restarted.
Read MoreActivating any missing service in SAP HANA
In Services tab under Landscape, you can right click on any service name and select Start Missing Service. This service activates any inactive service in your HANA system.
Read MoreOpening diagnosis mode automatically in SAP HANA system
In following scenarios. When you open Administration editor, it is opened automatically in diagnosis mode:When you open the Administration editor for a system without an SQL connectionWhen you initiate the start, stop, or restart of a systemYou can also open diagnosis mode manually by navigating to following path:
Read More