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 6 of 91
Benefits of using SAP HANA database views
Following benefits can be achieved using database views −To provide security −Using a view, you can select specific columns and assign access to the users. Users can only see the columns for which permissions are set on the view and not the underlying tables with full data.To hide Complexity −Consider a scenario where you need to join multiple tables using complex joins or calculations. All the coding can be put in database view and access can be provided.
Read MorePerforming different SAP logon check while connecting to HANA
When a user logins to the HANA system, the following steps are performed −Step 1 The system authenticates the user using the configured mechanism.Example − When User name/password authentication is being enforced, the provided user name and password are verified.Step 2The system verifies that the user's account is within its validity period.In the system view USERS, the columns VALID_FROM and VALID_UNTIL must contain effective values for the user in question.However, this is an optional parameter that a user administrator can set during user provisioning.Step 3The next step is system verifies that the user's account is active.This can be performed by checking ...
Read MoreSetting detailed error notification about failed login in SAP HANA
You can use parameter detailed_error_on_connect: Indicates the detail level of error information returned when a logon attempt fails.Parameter detailed_error_on_connectDefault Value falseAdditional Information When you set this parameter to false, only the information authentication failed is returned.When this parameter is set to true, the specific reason for failed logon is returned −Invalid user or passwordUser is lockedConnect try is outside validity periodUser is deactivated
Read MoreFinding a database view in SAP HANA database
This is created under the Current schema in your SQL editor. You can check schema name at the top −In the above snapshot, you can see the current schema name where the view is created. You need to find this schema under the Catalog folder in HANA Studio.
Read MoreExample of creating a database view in SAP HANA
Let us see the below table ARTICLE_LOOKUP, we will create a database view with first 4 columns and will hide Family_NAME and FAMILY_CODE.SQL statement- To create a view on the above table, write down the below SQL statementcreate view view_Articlelookup as select ARTICLE_ID,ARTICLE_LABEL,CATEGORY,SALE_PRICE from "AA_HANA11"."ARTICLE_LOOKUP";This will create a database view in the mentioned schema and you can check it in Views folder (schema name here-AA_HANA11). You can see a view with the name- view_Articlelookup and only 4 data columns are there.
Read MoreUse 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 MoreUsing Operators in Analytic Privilege in SAP HANA
You have the following Operators that can be used to define restrictions
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 MoreHiding 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 More