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 12 of 58
Difference between Copy and Derived view in SAP HANA
Following are the key points about using Derived view in SAP HANAThe derived attribute view will be similar in all the characteristics as the base view (except the name) It is not possible to edit any semantic/data foundation design in the derived attribute view. When there is any change in the base view, the changes will be reflected in the derived attribute view too. This helps reduce extra efforts of replicating the changes in the derived view.When you want to define an Attribute view on the top of an existing object as copy, you can use Copy From option. This can be ...
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 MoreCreating 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 More