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
63 articles
Use of different files in SAP HANA Cockpit for offline administration
Start, Restart, Stop System Operations: To perform start/stop/restart of HANA systemDiagnosis Files: This is used to access log, trace and other diagnosis files.Troubleshoot Unresponsive System: You can use this to trigger the collection of transactional information and displays this information for troubleshooting performance issues.SAP HANA Documentation - SAP HANA Offline Administration: You can open SAP HANA documentation that describes those administration tasks that you can perform using the SAP HANA cockpit for offline administrationSAP HANA Cockpit: This option is used to open SAP HANA cockpit where you can access all applications for the online administration of SAP HANA system.
Read MoreAdvantages of using Calculation View without Star Join
When you use Calculation view with Star Join, you have the following benefits:It simplifies the design process.You need not create Analytical views and Attribute Views and directly Fact tables can be used as Projections.3NF is possible with Star Join.
Read MoreApplying Variable on calculated column in SAP HANA Modeling view
Yes, you can set a variable on top of “Calculated column”. In the bottom box, you need to select the column on which you want to set a Variable.Click on Add and from the drop-down, you can select “Calculated column” as below:
Read MorePerformance 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 MoreShow creator name in SAP WEBI report
WEBI provides you a lot of functions which you can let you perform a wide range of operations ranging from fetching data to doing some complex calculations. You can get the entire list at help.sap.com.For your requirement you can use from the following functions:DocumentOwner()DocumentAuthor()These will not give you directly the name but the id’s which can be used further to get the name.You will have to utilize the User Attribute Management to get your task done. Create a new variable which you need to populate with the user attribute value basically the name.
Read MoreAdd Authentication details in the AJAX request in SAPUI5
Basically you need to exploit the beforeSend function of JQuery AJAX to sort out your requirement.Here is a basic code snippet −function AddToHeader(xhr) { var pwd = // get the password; xhr.setRequestHeader("Authorization", "Basic " + btoa(user + ":" + pwd)); } $.ajax({ type: "GET", url: , dataType: "JSON", beforeSend: function(xhr) { AddToHeader (xhr); } }).done(function(data) { /* do success logic */ }You can add further details to the header as explained in the AddToHeader method.
Read More