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 Basis Articles
Page 29 of 50
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 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 MoreDifference between Copy and Derived view in SAP HANA
Following are the key points about using Derived view in SAP HANAThe derived attribute view will be similar in all the characteristics as the base view (except the name) It is not possible to edit any semantic/data foundation design in the derived attribute view. When there is any change in the base view, the changes will be reflected in the derived attribute view too. This helps reduce extra efforts of replicating the changes in the derived view.When you want to define an Attribute view on the top of an existing object as copy, you can use Copy From option. This can be ...
Read More