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 Articles
Page 9 of 91
Adapters supported under Smart Data Access in SAP HANA
Below is the list of Adapters which are supported under Smart Data Access in SAP HANA −This comes while creating a new Remote Data Source.
Read MoreDifferent database objects inside Catalog folder in SAP HANA Studio
It includes −Column ViewsEPM ModelsEMP Query SourceFunctionsIndexesProceduresSequencesSynonymsTablesTriggersViews
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 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 MoreExporting a Delivery unit in SAP HANA using HANA Studio
In SAP HANA system, you have to assign packages to Delivery unit. Once packages are assigned to export DU, you can see the list of DU’s by using Export option −Go to File → Export → Delivery Unit → Select the Delivery UnitYou can also select export location:Export to ServerExport to ClientThis means that a Delivery unit can be exported to HANA Server location or to a Client location as shown in the below snapshot. It also shows you list of all packages that will exported with Delivery unit you have selected from drop down list.
Read MoreChecking number of rows in an internal table in SAP
You can use the LINES function to get the number of rows in an internal table.Use the following syntax to call the function:DESCRIBE TABLE LINES Once the function is executed the variable will hold the number of rows in the internal table.
Read MoreGetting an error while previewing swf file from XML data in SAP Dashboard Designer
There could be multiple reasons that this error comes up. Try below steps:Adobe Global Security Settings changesMade entries in windows host file andAdded SAP server as trusted site in IEThis purely seems to be a security setting issue in Adobe Flash Player. There are various SAP notes that you can search however I am not aware any relevant one.
Read More