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 3 of 7
Performance Analysis of an Attribute view in SAP HANA
In SAP HANA Modeling, you have an option of switching to Performance Analysis mode. This is used to check if Joins in Attribute view are meeting with performance optimized joins and cardinality based on data in the table.You can see 2 options when you select Performance Analysis mode:Join Details:This defines Join type used and proposed cardinality based on data in the tableData Source Details:Defines table type, partition type and a number of rows in tables.
Read MoreUsing Time subtype of an attribute view in SAP HANA
Time subtype Attribute View is a special type of Attribute view that adds a Time Dimension to Data Foundation. To know more about the difference between Standard Attribute view and Time Attribute view, you can refer this SAP thread:https://archive.sap.com/discussions/thread/3253551
Read MoreAdding a package to Delivery unit in SAP HANA
In SAP HANA, Delivery unit is known as single unit, which can be mapped to multiple packages and can be exported as a single entity so that all the packages assigned to Delivery Unit can be treated as a single unit.Delivery units can be used to export all the packages that make a delivery unit and the relevant objects contained in it to a HANA Server or to the local Client location.The user should create Delivery Unit prior to using it. This can be done through HANA Modeler -> Delivery Unit -> Select System and Next -> Create -> Fill ...
Read MoreChecking performance of SAP HANA system
This can be checked in Performance tab under Administration icon in SAP HANA.In this tab, you can check the following:ThreadsSessionsBlocked TransactionsSQL Plan CacheExpensive statement traceJob ProgressLoad
Read MoreRequirements to use a text join in SAP HANA
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 −
Read MorePort number for SAP HANA Cockpit offline administration
Following perquisites should be met for accessing SAP HANA cockpit for offline administration −To access this, you need credentials of the operating system user (adm user) that was created when the system was installed.Communication port 1129: As this Port 1129 is required for communication with the SAP Host Agent in a standalone browser via HTTPS.HANA Cockpit is configured with HTTP accessWeb browser supports the SAPUI5 library sap.m.
Read MoreSoft and hard stop of HANA system using HANA Studio
To stop a HANA system, right-click the system you want to stop and choose Configuration and Monitoring → Stop System…Following options are available when you stop a system −Soft − The system is stopped after all running statements have finished or the specified timeout is reached.Hard − The system is stopped immediately. Open transactions are aborted and rolled back.
Read MoreStop and start a particular database service in SAP HANA
Yes, you can start/stop a particular service of HANA system. To stop a service, go to Administration editor → Services tab. Right-click the service and choose the required option:
Read MoreAdding a service to a tenant database
To scale out a tenant database and/or distribute it across multiple hosts, you can add further server components, for example, an additional index server or a separate XS server. You add a service to a tenant database using the ALTER DATABASE SQL command.You do this from the system database using the following command −ALTER DATABASE ADD Following perquisites should be met to perform this task −You are logged on to the system database.You have the system privilege DATABASE ADMIN.
Read MoreRemoving a service from a tenant database in SAP HANA
Yes, it is possible to remove a server component, which are no longer required. This can be performed using ALTER DATABASE SQL command.Following perquisites should be met to perform this task −You are logged on to the system database.You have the system privilege DATABASE ADMIN.To remove a service, you need to open SQL console of the SAP HANA studio and run “ALTER DATABASE” statement.ALTER DATABASE DB1 REMOVE '' AT LOCATION 'HOST_A:30XXX'
Read More