Found 694 Articles for SAP HANA

When you use export option from main menu, it also exports the list of systems and their properties (name, description, host name, instance, and so on) is exported as an XML file to the specified location.

Yes, it is possible to export a list of your SAP HANA systems from the SAP HANA studio as an XML file and then it can be imported to another instance of the SAP HANA studio or use it as a system archive to which other users can link.This can be performed by following below steps −From the main menu, select File Export... .Expand the SAP HANA folder and choose Landscape.Choose Next.Select the systems you want to export and enter a target file location.Choose Finish

To allow users who work in the SAP HANA studio to connect efficiently to multiple SAP HANA systems, you can manage a list of all systems in a centrally-accessible archive. Users can then simply link to this archive.

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.

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.

>Create View View_name as Select Col1,Col2 From Table_name;In the above SQL statement, you are creating a view that contains Col1 and Col2 from the table.Table Name − Emp_InfoExampleIdEmplNameEmpluserEmplpasswordJoining_Date1Employee 1Emp1Emp1Pwd9/11/20162 Employee 2Emp2 Emp2Pwd   16/08/20153Employee 3Emp3Emp3Pwd15/09/20164Employee 4Emp4   Emp4Pwd  3/07/20145Employee 5Emp5Emp5Pwd10/09/20126Employee 6Emp6  Emp6Pwd   1/10/2013                                                                                               To create a view, which contains only 3 columns you have to write->Create View View_EmpInfo As Select Id, EmplName,Joining_Date  From Emp_Info;This view can be used by users to get Id, EmplName, and Joining_date. 

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.

Consider the following example −Example            Id            Empl. NameEmpl.userEmpl.passwordJoining Date1 Employee 1  Emp1Emp1Pwd      9/11/20162 Employee 2Emp2Emp2Pwd16/08/20153Employee 3 Emp3Emp3Pwd  15/09/20164Employee 4Emp4  Emp4Pwd3/07/20145Employee 5  Emp5    Emp5Pwd 10/09/20126 Employee 6Emp6  Emp6Pwd  1/10/2013         Consider a scenario when a developer needs to analyze some data of Employee Table with the above fields. Using database view, an administrator can create a virtual table which only contains information about Employee Id, Employee name, and date of joining and give permission to developer to use that view.

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 −

Roles tab is used to view the existing roles in HANA system and you can also create a new role in HANA system to add to user’s profile as per requirement.