首页 > SAP > HANA > How to create Attribute Views in SAP HANA Studio
2019
08-27

How to create Attribute Views in SAP HANA Studio

Hello everyone, in this SAP HANA Modeling tutorial we will learn how to create Attribute Views in SAP HANA Studio.

1.Prerequisites

You should have installed SAP HANA Studio in your local machine.
You should have connected to HANA system with your HANA DB Credentials.

2.Step-By-Step Procedure

1. Navigate to Window → Open Perspective → SAP HANA Modeler to change the perspective of your HANA Studio to SAP HANA Modeler (OR) Select the SAP HANA Modeler perspective in the perspective shortcut which is at the top right corner of your SAP HANA Studio.

How to create Attribute Views in SAP HANA Studio - 第1张  | 优通SAP
SAP HANA Modeler Perspective

OR

How to create Attribute Views in SAP HANA Studio - 第2张  | 优通SAP
SAP HANA Modeler in HANA Studio

2. You will see four main folders  Catalog, Content, Provisioning and Security in your HANA System.Expand the Content folder and create and New Package.

How to create Attribute Views in SAP HANA Studio - 第3张  | 优通SAP
New Package in SAP HANA Studio

3. In the New Package Window, enter Name and Description and click on OK.

How to create Attribute Views in SAP HANA Studio - 第4张  | 优通SAP
New Package Window

4. Right click on the package we created in the previous step and choose New → Attribute View.

How to create Attribute Views in SAP HANA Studio - 第5张  | 优通SAP
Attribute View

5. In the New Information View window, enter Name, Label and click on Finish.

How to create Attribute Views in SAP HANA Studio - 第6张  | 优通SAP
New Information View

6. A new HANA modeling view editor opens like below.

How to create Attribute Views in SAP HANA Studio - 第7张  | 优通SAP
SAP HANA Modeling Editor

7. In the graphical editor of the HANA view editor, click on Add Objects. To see How to create Attribute Views in SAP HANA Studio - 第8张  | 优通SAP you need to hover on Data Foundation node.

How to create Attribute Views in SAP HANA Studio - 第9张  | 优通SAP
Add Objects to Attribute View

8. In this tutorial we are going to create Attribute View against Employee table in EPM data model.Tables used in this example are SNWD_EMPLOYEE and SNWD_AD. In the Find popup window search for these table and add them to the Data Foundation.

How to create Attribute Views in SAP HANA Studio - 第10张  | 优通SAP
Add Tables to the Data Foundation

9. Repeat the Step-8 to add SNWD_AD table as well.

10. Now you can see both or tables were added and can see that like below screen.

How to create Attribute Views in SAP HANA Studio - 第11张  | 优通SAP
HANA Modeling Editor

11. SNWD_EMPLOYEES table employee information and SNWD_AD stores the address of the employee. PR_ADDRESS_GUID is the field we can use to connect these two tables.Select this field and drag and drop to the NODE_KEY field in the SNWD_AD like below.

How to create Attribute Views in SAP HANA Studio - 第12张  | 优通SAP

12. Now select the fields from these tables to show them in the output.
♦ Tip: To select the fields click on the circle which is left to the field until it turns to orange circle.

How to create Attribute Views in SAP HANA Studio - 第13张  | 优通SAP
Output Fields in Attribute View

13. Now make the EMPLOYEE_ID as key attribute in this Attribute View. Select the field in the Output section and change the Key property as True.

[adsenseyu1]

14. Save and active the Attribute View by clicking on the Save and Active How to create Attribute Views in SAP HANA Studio - 第14张  | 优通SAP button on the top.

15. Now click on Data Preview button How to create Attribute Views in SAP HANA Studio - 第15张  | 优通SAP to see the data in the Attribute View.

How to create Attribute Views in SAP HANA Studio - 第16张  | 优通SAP

Save.
Save and Active.
Data Preview.

3.Output of Attribute View

How to create Attribute Views in SAP HANA Studio - 第17张  | 优通SAP
Data in Attribute View

You have successfully created Attribute View in SAP HANA Studio.

Please stay tuned to us for more SAP HANA tutorials.Please feel free to comment and let us know your feedback. You feedback will keep us alive.

Thank you.

最后编辑:
作者:yangsen
有需要可在文章留言或者邮件yan252@163.com给我。

留下一个回复

你的email不会被公开。

4 × 5 =