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
-
Economics & Finance
Articles by SAP ABAP Expert
Page 4 of 12
Hiding a column in Data Preview in SAP HANA
In Analytic View, to hide few of columns you have to click on Semantics in scenario pane. There you can select the checkbox in front of column name that you want to hide.
Read MoreData Preview option in HANA Modeling view in SAP HANA
Once HANA Modeling view is activated, you can use Data Preview option to analyze the data in HANA Modeling view. To see Data Preview, you can right-click on View name → Data PreviewYou can also click on the icon as shown in below snapshot:
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 MoreTime taken by savepoint to perform backup in SAP HANA
M_SAVEPOINTS view stores Current and historical savepoint statistics. There is column DURATION which tells the total time taken by savepoint.You can extract the following information from the numbers in this view −CRITICAL_PHASE_DURATION shows the period of time during which the updaters were blocked in a savepoint. Normally, this should be in the milliseconds range, except for a global savepoint for data backup, which may take longer due to global synchronization across all nodes. If the critical phase duration is too long, there is probably some problem (e.g., I/O load is too high).DURATION shows the total time taken by a savepoint. ...
Read MorePath for file based data backups in SAP HANA
All the information is available under global.ini file which stores global configuration properties for each service in the landscape.These are the global properties most frequently used for extended storage configuration − Name Section Value Defaultbasepath_databackup persistence File path($DIR_INSTANCE)/backup/data
Read MoreDifference between enforced and unenforced license in SAP HANA
In SAP HANA, following permanent license type is supported −Unenforced License: When you use an unenforced license key in SAP HANA and consumption of HANA system exceeds the license amount of memory, it doesn’t effect the operation of SAP HANA database.Enforced License: When an Enforced license key is installed and consumption of HANA system exceeds the license amount of memory, HANA system gets locked. If this situation occurs, HANA system has to be restarted or a new license key should be requested and installed.
Read MoreDifferent Aggregation functions in SAP HANA
In a general scenario, it is advisable to store the table as Column store when you have to run complex OLAP queries. OLAP queries include complex calculations and different SQL aggregation functions are used in the query.Select Sum(Sales) from table_name where Column1=’ABC’; Aggregate Functions include −Sum() - returns the sum of the numeric values in a given columnMax() - returns the maximum of the numeric values in a given columnMin() - returns the minimum of the numeric values in a given columnAverage() - returns the average of the numeric values in a given columnPercent() - returns the percentage of the numeric ...
Read MoreChanging Ownership of schema in SAP HANA Database
I don’t think you can change ownership of schema in database. Easiest way to change ownership of schema is by exporting a schema, drop it from the database and then recreate the schema owned by the target user and import the objects back into the database.In recent version, you can create schema and set other users as an owner of the schema however you can’t change it later −Create SCHEMA TEST123 owned by Demo;In same way, you can collect the script for "Create procedure" from database and drop the procedures in the earlier user schema and then these can be ...
Read MoreChecking SAP HANA Schema owner name
To check schema owner, you need access on “SYS” schema. Open SAP HANA SQL console and run the following SQL query −SELECT * FROM "SYS"."SCHEMAS";
Read MoreChecking schema creation in SAP HANA database
To check this detail, you should have access on “SYS” schema. Run the following SQL query and it will fetch the following columns −SELECT * FROM "SYS"."SCHEMAS";Schema_NameSchema_OwnerHAS_PRIVILEGESCreate_Time
Read More