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
SAP HANA Articles
Page 7 of 58
Creating a copy of an existing Attribute view in SAP HANA
Yes, it is possible to create a copy of an existing Attribute view. While passing View name and View type, you can select the option of “Copy From” and this will enable Browse option from which you can select any of existing view to copy.
Read MoreCreating an Attribute view in SAP HANA
To create a new Attribute view, select the Package name under which you want to create an Attribute View. Right Click on Package → Go to New → Attribute ViewClick on Attribute View, and this will open a new Window. You need to pass Attribute View name and description. From the drop-down list, choose View Type and subtype. In subtype, there are three types of Attribute views − Standard, Time, and Derived.Once you finish the wizard, you can see view is created under the specified package.
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 MoreCreating a new table in SAP HANA
New tables can be created using the two methods given below −Using SQL editorUsing GUI optionThe new table can be created using SQL Create Table statement –Create column Table Test1 ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );When you run this SQL query, you get a message like this:The statement 'Create column Table Test1 ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) )' successfully executed in 5 ms 136 μs (server processing time: 4 ms 432 μs) - Rows Affected: 0To create a table using GUI, you need to right-click on any schema name -> New ...
Read MoreOpening SAP HANA Cockpit from HANA Studio
SAP HANA Cockpit with Fiori-based Launchpad shows the content in the form of tiles arranged in groups. Using these tiles, you can access individual applications and can also access app-specific data for immediate review.You can also perform a drill on these tiles to see the detailed information about specific applications.Following roles are required to open and access tile-based SAP HANA Cockpit − sap.hana.admin.roles:: Monitoring or sap.hana.admin.roles:: AdministratorYou can also open SAP HANA Cockpit via HANA Studio. Navigate on HANA system -> Configuration and Monitoring -> Open SAP HANA Cockpit.You can also open HANA Cockpit in an offline mode using a ...
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 MoreComponent Name in SAP HANA architecture
The following table lists all the key server components in HANA, the corresponding services, and OS process details.
Read MoreIndex server in SAP HANA system
Index server contains SQL/MDX processor to handle query statements for the database. When SQL or MDX is fired for SAP HANA system, an Index Server takes care of all these requests and processes them. All HANA processing takes place in Index Server.Index Server contains Data engines to handle all SQL/MDX statements that come to HANA database system. It also has Persistence Layer that is responsible for durability of HANA system and ensures HANA system is restored to most recent state when there is a restart of system failure.Index Server also has Session and Transaction Manager, which manage transactions and keep ...
Read MoreChecking topology of SAP HANA
The topology of SAP HANA system is maintained by Name Server. This is used to manage all the running components and data stored in each component.
Read MoreManual compression of a table in SAP HANA
It is also possible to compress a table in SAP HANA system manually by executing the following SQL statement.UPDATE "table_name" WITH PARAMETERS ('OPTIMIZE_COMPRESSION' = 'YES')This results in deciding whether a compression is required or an existing compression can be optimized. In this scenario, HANA system uses most suitable compression algorithm.When you run the above SQL command, compression status remains the same. You can also force the database to reevaluate compression using the following SQL status UPDATE "AA_HANA11"."SHOP_FACTS" WITH PARAMETERS ('OPTIMIZE_COMPRESSION' = 'FORCE')
Read More