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
SAP HANA Articles
Page 47 of 58
Create User SQL in SAP HANA database
You can achieve this by running the below SQL query −>CREATE USER TEST password “Welcome1$$” VALID FROM ‘2017-12-05 11:00:00’ UNTIL ‘2018-12-08 12:00:00’; CREATE USER DUMMY password “Welcome1$$” VALID FROM NOW UNTIL FOREVER;Note that password passed in this SQL should meet password policy of SAP HANA system otherwise user creation will be failed.
Read MoreChecking existing password policy of SAP HANA system
You can check this information under New User in SAP HANA. The below snapshot shows the New User dialog in SAP HANA Studio and the password rule that is displayed when hovering over the password field.
Read MoreSetting password expire notification in SAP HANA
Parameter password_expire_warning_timeDefault Value 14 (days)Parameter definitionNotification is transmitted via the database client (ODBC or JDBC) and it is up to the client application to provide this information to the user.If you enter the value 0, the user does not receive notification that his or her password is due to expire.The system also monitors when user passwords are due to expire and issues a medium priority alert. This may be useful for technical database users since password expiration results in the user being locked, which may affect application availability. It is recommended that you disable the password lifetime check of technical ...
Read MoreUsing database view in SAP HANA
A view in a database is defined as Virtual table which derives its data from one or more columns of one table or multiple tables. A view can be created using tables of one or more database and is stored in database where it is created.You can find views in SAP HANA Studio under schema name −
Read MoreCalling an ABAP Function Module using Python script to put data in SAP HANA
You can refer this SAP blog how to use SAP NetWeaver library with Python.SAP Link
Read MorenQuery in Analytic view creating unexpected results in SAP HANA
You haven’t provided complete details what you are trying to achieve. Refer SAP OSS note 1993033 Wrong result for query on analytic viewDuring activation of an analytic view, column view is generated. However, there are some artifacts that cannot be calculated in this column view. In this case, one additional calculation view is generated on top of it. The generation of the calculation view has to be performed if the following elements are defined in the analytic view:Input parametersCalculated attributesUnit or currency conversionsIf at least one of these elements is defined in the analytic view, the activation creates one OLAP ...
Read MoreGenerating result of SAP transaction automatically
There are different approaches that you can follow −First approach would be that you schedule a job and send the result to a mailbox instead of printing it. Then you can use any programming code to read that email and export in desired format.Other approach would be to check available BAPI’s. These BAPI’s can be called from an external program but for this you need to use SAP ABAP.Checkout this SAP blog that tells how to generate a report in background and send result to user email id −SAP blogYou can define distribution list in T-Code − SO23
Read MoreSAP doesn't accept extension tags generated from wsdl for Web Services
Note that when you map XML schema to C#, it is recommended to map this to class inheritance. As per my understanding, you want to copy extended properties to generated classes however I don’t think you can find any tool to achieve this.I think this should be handled by transforming XML schema to a structure that you want and then use the schema to C# tool. One of the most common way to perform this is via XSLT.XSL (eXtensible Stylesheet Language) is a styling language for XML and it stands for XSL Transformations. XSLT provides the ability to transform XML ...
Read MoreGetting information in MS SharePoint workflow from SAP
There are many tools which offer this function for SharePoint. Try using BCS Business Connectivity Service and LINQ to get data from SAP to SharePoint list and then use that data in workflow.To write your own custom workflow, you can check this link:Custom Activity Workflow for implementing Item Level Security in SharePoint Designer 2007Workflow LinkTo create a Visual Studio 2008 Workflow Activity Library project, you need to follow below steps:First is to open Visual Studio 2008.Navigate to File menu, point to New, and then click Project.Next step is to navigate under the Workflow Project Type and select the Workflow Activity ...
Read MoreAlign items to center not working in SAPUI5
If you want a quick solution then you can use basic CSS properties like padding for left or right to align the content. Use relative percentages so that it works in both the views.Other way which looks ideal is that define a custom CSS. Then you need to add this custom CSS to manifest."resources": { "css": [ { "uri": "css/style.css" } ] }Set the concerned property like Margin: 0 auto; which will help you to set the contents to center.
Read More