HANA Attribute View

Introduction

Attribute Views are typically created for maintaining Master Data (Data which is not changing frequently Ex- employee Address or employee phone number etc ) in HANA system or we can also call it as a dimension in star schema modelling. It doesn’t store the data physically, however fetches the data from source in runtime whenever we execute this object in our system.

Creating Attribute View

1. Go to your HANA Studio and go to your Package where you want to create your Attribute View and Right click--> New-->Attribute View
   
2. Next Put all the Details Like View Name and Naming convention For Attribute View is AT_ViewName.
   SubType of Attribute View is:
   Standard- By Default it's Selected
   Time- if you want to create Time related View then choose this one.
   Derived- Parent of this view is another any Attribute View.
   
3. Click on Finish after this next screen will come and there with the plus(+) icon add one or more tables into Data Foundation Fields. After this select number of fields you want into the output.
   
4. Now Add the second table With the same way as above you added and join between them and check the join type
   .
5. Finally Check and Activate with the Head-lighted below 2 buttons
   
6. Now Final Step right click on View and click Data Preview and the click on Raw Data and see the Data
   
   
   
   
   For more Information Please mail me on sandeepcts1989@gmail.com