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 Articles
Page 39 of 91
Finding 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 MoreCreating a mandatory variable in SAP HANA View
Yes, this is possible. When you create variable in HANA, you have an option to make it as a mandate. Also from the drop down, you can make Selection type as Range or Interval
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 column properties in an Attribute view in SAP HANA
This can be easily checked in Details pane. You need to select column name for which you want to check Properties of a column → right click → Properties
Read More