{"id":53034,"date":"2019-04-02T14:00:56","date_gmt":"2019-04-02T08:30:56","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=53034"},"modified":"2021-12-05T21:43:27","modified_gmt":"2021-12-05T16:13:27","slug":"sap-hana-attribute-view","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/","title":{"rendered":"SAP HANA Attribute View &#8211; Create Attribute View in 9 Easy Steps"},"content":{"rendered":"<p>Moving ahead in understating modeling with <strong>SAP HANA Information Modeler<\/strong>, let us start with learning about SAP HANA Attribute View. In this lesson, we will first understand the concept behind the attribute view, the process flow of creating the attribute view and types of attribute view.<\/p>\n<p>Along with the conceptual knowledge, we will also learn how to create attribute view in SAP HANA Modeler.<\/p>\n<p>Let us rewind a little and recall the significance of information modeling in SAP HANA. Information models or Views are logical frameworks or run-time objects which structures data from one-dimensional databases into multi-dimensional data structures for analytical purposes.<\/p>\n<p>The information views do not store data physically in SAP HANA. The logic of a view is stored in HANA and every time a reporting tool requests the view, the system fetches the data according to the blueprint of the view from the data source and presents it to the user.<\/p>\n<p>Let&#8217;s start this tutorial by learning the definition of Attribute View.<\/p>\n<h3>What is SAP HANA Attribute View?<\/h3>\n<p>The Attribute View in <strong>SAP HANA<\/strong> is a set of dimensions or master data which can be joined with the fact table in an Analytic View. An Attribute View can be created by taking data from one or more data tables. The attribute shows relationships between different attributes.<\/p>\n<p>The attributes can be <strong>Customers, Region, Product, Period etc.<\/strong> In an Attribute View, joins can be made between two master data tables, a text table, and a master data table, etc.<\/p>\n<h3>Types of Attribute View<\/h3>\n<p><strong>1. Standard Attribute Views:<\/strong> These views create by table fields among different column store tables by using joins in SAP HANA.<\/p>\n<p><strong>2. Derived Attribute Views:<\/strong> It is an Attribute View created using another existing Attribute View. It will open in read-only mode, we cannot edit the derived Attribute view. The only editable field in the created Attribute View is the description. It will act as a reference to the base Attribute view. Any modification to the base Attribute View will reflect in the created Attribute View.<\/p>\n<p><strong>3. Timed Attribute Views:<\/strong> Timed Attribute View stores the time-dependent data. It is created against calendar tables \u2013 M_FISCAL_CALENDAR (or) time tables \u2013 M_TIME_DIMENSION, M_TIME_DIMENSION_YEAR, M_TIME_DIMENSION_MONTH and M_TIME_DIMENSION_WEEK. All these tables stores in _SYS_BI schema.<\/p>\n<h3>Types of Joins<\/h3>\n<p>Tables from data sources join in different ways to create an Attribute View in SAP HANA. The join types are:<\/p>\n<ul>\n<li>Referential Join<\/li>\n<li>Inner Join<\/li>\n<li>Left Outer Join<\/li>\n<li>Right Outer Join<\/li>\n<li>Text Join<\/li>\n<\/ul>\n<p>Along with defining the join type of the Attribute View, the cardinality of tables is also important to specify. The cardinality can be 1:1, 1: N or N:1.<\/p>\n<h3>Types of Hierarchies<\/h3>\n<p>Along with cardinality, and join type, dimensions in Attribute View arranges in hierarchies. There are two types of hierarchies in which attributes in a set gets arrange; Level hierarchy and Parent-Child hierarchy.<\/p>\n<ul>\n<li>The level hierarchy follows a rigid pattern of root and child nodes where successive attributes can be accessed only in the order they were created.<\/li>\n<li>A parent-child hierarchy is like a tree structure where there are multiple sub-nodes of a root node which can further extend to an undecided length. Thus, the tree-like structure has unbalanced root nodes.<\/li>\n<\/ul>\n<h3>Creating an Attribute View in SAP HANA<\/h3>\n<p>Before we learn how to create the Attribute View in SAP HANA Modeler, let us understand the process flow in order to create a complete and proper Attribute View.<\/p>\n<ul>\n<li><strong>Enter details:<\/strong> Enter the technical name of the table and mention the table type.<\/li>\n<li><strong>Table selection:<\/strong> Select tables from the database schemas. You can select tables from more than one schema. If you select multiple tables, joins can create between them in this step.<\/li>\n<li><strong>Field selection:<\/strong> Define the key column and select the output column.<\/li>\n<li><strong>Advanced operations:<\/strong> You can carry out transformation processes on columns like creating calculated columns, creating hierarchies, etc.<\/li>\n<li><strong>Active and data preview:<\/strong> At last, you can activate the Attribute View after saving the selections made by you and go to Data Preview to preview the view created.<\/li>\n<\/ul>\n<h3>Attribute View Creation<\/h3>\n<p>Here are the steps to create an Attribute View in SAP HANA Modeler:<\/p>\n<p><strong>Step 1:<\/strong> Open packages in the Content folder in the SAP HANA Modeler.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Packages-in-the-Content-folder-Option.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53055\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Packages-in-the-Content-folder-Option.png\" alt=\"Attribute View - Packages in the Content folder Option\" width=\"1904\" height=\"1018\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Packages-in-the-Content-folder-Option.png 1904w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Packages-in-the-Content-folder-Option-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Packages-in-the-Content-folder-Option-300x160.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Packages-in-the-Content-folder-Option-768x411.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Packages-in-the-Content-folder-Option-1024x547.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Packages-in-the-Content-folder-Option-520x278.png 520w\" sizes=\"auto, (max-width: 1904px) 100vw, 1904px\" \/><\/a><strong>Step 2:<\/strong> Then, select an existing package or create a new package from the Content node.<\/p>\n<p>Right-click on the package name, go to New and select Attribute View option.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Create-a-new-package-from-the-Content-node-Option.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53056\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Create-a-new-package-from-the-Content-node-Option.png\" alt=\"Attribute View - Create a new package from the Content node Option\" width=\"1902\" height=\"1012\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Create-a-new-package-from-the-Content-node-Option.png 1902w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Create-a-new-package-from-the-Content-node-Option-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Create-a-new-package-from-the-Content-node-Option-300x160.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Create-a-new-package-from-the-Content-node-Option-768x409.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Create-a-new-package-from-the-Content-node-Option-1024x545.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Create-a-new-package-from-the-Content-node-Option-520x277.png 520w\" sizes=\"auto, (max-width: 1902px) 100vw, 1902px\" \/><\/a><\/p>\n<p><strong>Step 3:<\/strong> Enter the technical name of the view carefully, as it cannot be changed later. Also, you can enter a label name. From the Copy From option, you can select an existing Attribute View to act as a basis for the new one. Select a subtype and click on Finish.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Technical-Name-Option.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53057\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Technical-Name-Option.png\" alt=\"Attribute View - Technical Name Option\" width=\"1912\" height=\"1018\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Technical-Name-Option.png 1912w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Technical-Name-Option-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Technical-Name-Option-300x160.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Technical-Name-Option-768x409.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Technical-Name-Option-1024x545.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Technical-Name-Option-520x277.png 520w\" sizes=\"auto, (max-width: 1912px) 100vw, 1912px\" \/><\/a><\/p>\n<p><strong>Step 4:<\/strong> Then, a view editor will open. The Semantics section shows all the details that relate to the columns from the tables. And, you can create the Attribute View in the Data foundation section of SAP HANA Modeler.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Video-Editor.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53058\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Video-Editor.png\" alt=\"Attribute View - Video Editor\" width=\"1912\" height=\"1016\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Video-Editor.png 1912w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Video-Editor-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Video-Editor-300x159.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Video-Editor-768x408.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Video-Editor-1024x544.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Video-Editor-520x276.png 520w\" sizes=\"auto, (max-width: 1912px) 100vw, 1912px\" \/><\/a><strong>Step 5:<\/strong> After that, you can select the table from the schema in two ways. Either by finding the table under the schema name in Catalogue node and dragging-dropping the table on the editing pane. You can add tables from more than one schema and create joins between them.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-tables-from-schema.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53059\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-tables-from-schema.png\" alt=\"Attribute View - Add tables from schema\" width=\"1912\" height=\"1016\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-tables-from-schema.png 1912w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-tables-from-schema-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-tables-from-schema-300x159.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-tables-from-schema-768x408.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-tables-from-schema-1024x544.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-tables-from-schema-520x276.png 520w\" sizes=\"auto, (max-width: 1912px) 100vw, 1912px\" \/><\/a><\/p>\n<p>Or, by\u00a0clicking on the green plus sign next to the Data foundation section and searching the table by name.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Search-the-Table-Name-Option.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53060\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Search-the-Table-Name-Option.png\" alt=\"Attribute View - Search the Table Name Option\" width=\"1912\" height=\"992\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Search-the-Table-Name-Option.png 1912w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Search-the-Table-Name-Option-150x78.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Search-the-Table-Name-Option-300x156.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Search-the-Table-Name-Option-768x398.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Search-the-Table-Name-Option-1024x531.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Search-the-Table-Name-Option-520x270.png 520w\" sizes=\"auto, (max-width: 1912px) 100vw, 1912px\" \/><\/a><\/p>\n<p><strong>Step 6:<\/strong> Now, its time to select columns from the table to add into the Attribute View in SAP HANA Modeler. You can add columns into the view in two ways; either by right-clicking on the column name and selecting Add to Output.<\/p>\n<p>The column name will show in the right-most Output column and also on the Data foundation at the left. Or, you can simply click on the dot present in-front of the column name and it will turn orange indicating that it is added.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-Column-Option.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53061\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-Column-Option.png\" alt=\"Attribute View - Add Column Option\" width=\"1904\" height=\"1010\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-Column-Option.png 1904w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-Column-Option-150x80.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-Column-Option-300x159.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-Column-Option-768x407.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-Column-Option-1024x543.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Add-Column-Option-520x276.png 520w\" sizes=\"auto, (max-width: 1904px) 100vw, 1904px\" \/><\/a><strong>Step 7:<\/strong> If you wish to remove a column from the Output, right-click on the column name and click on Remove.<\/p>\n<p><strong>Step 8:<\/strong> Next, you can go to the Semantics section from where you have to select at least one column as the key attribute. From the properties section in SAP HANA Modeler, you can see the properties of the Attribute View.<\/p>\n<p>Also, you can set the Cache Invalidation Period which sets the time of data loading from the RAM to the cache. The data tables stay into the cache for that defined period. And, create hierarchies from the Hierarchy section.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Semantics-Section.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53062\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Semantics-Section.png\" alt=\"Attribute View - Semantics Section\" width=\"1896\" height=\"976\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Semantics-Section.png 1896w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Semantics-Section-150x77.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Semantics-Section-300x154.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Semantics-Section-768x395.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Semantics-Section-1024x527.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Semantics-Section-520x268.png 520w\" sizes=\"auto, (max-width: 1896px) 100vw, 1896px\" \/><\/a><strong>Step 9:<\/strong> Upon completing all the processes of adding columns and tables to create the Attribute View, save and activate the view by clicking on the green tick icon and green arrow given on the panel on top. Then go to the Data preview icon.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Data-preview-icon.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53064\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Data-preview-icon.png\" alt=\"Attribute View - Data preview icon\" width=\"471\" height=\"113\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Data-preview-icon.png 471w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Data-preview-icon-150x36.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Data-preview-icon-300x72.png 300w\" sizes=\"auto, (max-width: 471px) 100vw, 471px\" \/><\/a><\/p>\n<p><strong>Step 10:<\/strong> The data preview window contains three tabs; Analysis, Distinct values, and Raw data. The raw data section shows the data in tabular form.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/data-section-showing-data-in-tabular-form.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53066\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/data-section-showing-data-in-tabular-form.png\" alt=\"Attribute View - data section showing data in tabular form\" width=\"1900\" height=\"963\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/data-section-showing-data-in-tabular-form.png 1900w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/data-section-showing-data-in-tabular-form-150x76.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/data-section-showing-data-in-tabular-form-300x152.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/data-section-showing-data-in-tabular-form-768x389.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/data-section-showing-data-in-tabular-form-1024x519.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/data-section-showing-data-in-tabular-form-520x264.png 520w\" sizes=\"auto, (max-width: 1900px) 100vw, 1900px\" \/><\/a><\/p>\n<p>Lastly, you can do instant analysis using the data from the columns in the Analysis tab. Just drag-and-drop the columns in place of two axes and visualization create.<br \/>\n<a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Drag-and-drop-the-data-from-column.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53068\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Drag-and-drop-the-data-from-column.png\" alt=\"Attribute View - Drag and drop the data from column\" width=\"1914\" height=\"961\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Drag-and-drop-the-data-from-column.png 1914w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Drag-and-drop-the-data-from-column-150x75.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Drag-and-drop-the-data-from-column-300x151.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Drag-and-drop-the-data-from-column-768x386.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Drag-and-drop-the-data-from-column-1024x514.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Drag-and-drop-the-data-from-column-520x261.png 520w\" sizes=\"auto, (max-width: 1914px) 100vw, 1914px\" \/><\/a><\/p>\n<h3>Summary<\/h3>\n<p>Thus, in this lesson, we learned about the first, which the very basic information view in <strong>SAP HANA<\/strong>, that is, the Attribute View. We went through the Attribute View as a concept moving forward with learning how to create it in SAP HANA Modeler. In the lessons to come, we will learn about the other two views, namely Analytic View and Calculation View.<\/p>\n<p>Therefore, don&#8217;t forget to check the upcoming articles. If you have come across with any kind of queries related to SAP HANA Attribute View article, feel free to ask in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Moving ahead in understating modeling with SAP HANA Information Modeler, let us start with learning about SAP HANA Attribute View. In this lesson, we will first understand the concept behind the attribute view, the&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":53072,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19372,19370,19371],"class_list":["post-53034","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-creating-attribute-view","tag-sap-hana-attribute-view","tag-types-of-attribute-view"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SAP HANA Attribute View - Create Attribute View in 9 Easy Steps - DataFlair<\/title>\n<meta name=\"description\" content=\"SAP HANA Attribute View tutorial comprises the explanation of Attribute View, its types, hierarchies and steps to create an Attribute View.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP HANA Attribute View - Create Attribute View in 9 Easy Steps - DataFlair\" \/>\n<meta property=\"og:description\" content=\"SAP HANA Attribute View tutorial comprises the explanation of Attribute View, its types, hierarchies and steps to create an Attribute View.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-02T08:30:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-05T16:13:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Attribute-View.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAP HANA Attribute View - Create Attribute View in 9 Easy Steps - DataFlair","description":"SAP HANA Attribute View tutorial comprises the explanation of Attribute View, its types, hierarchies and steps to create an Attribute View.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/","og_locale":"en_US","og_type":"article","og_title":"SAP HANA Attribute View - Create Attribute View in 9 Easy Steps - DataFlair","og_description":"SAP HANA Attribute View tutorial comprises the explanation of Attribute View, its types, hierarchies and steps to create an Attribute View.","og_url":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-04-02T08:30:56+00:00","article_modified_time":"2021-12-05T16:13:27+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Attribute-View.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SAP HANA Attribute View &#8211; Create Attribute View in 9 Easy Steps","datePublished":"2019-04-02T08:30:56+00:00","dateModified":"2021-12-05T16:13:27+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/"},"wordCount":1276,"commentCount":3,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Attribute-View.jpg","keywords":["Creating Attribute View","SAP HANA Attribute View","Types of Attribute View"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/","url":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/","name":"SAP HANA Attribute View - Create Attribute View in 9 Easy Steps - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Attribute-View.jpg","datePublished":"2019-04-02T08:30:56+00:00","dateModified":"2021-12-05T16:13:27+00:00","description":"SAP HANA Attribute View tutorial comprises the explanation of Attribute View, its types, hierarchies and steps to create an Attribute View.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Attribute-View.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Attribute-View.jpg","width":1200,"height":628,"caption":"SAP HANA Attribute View"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-attribute-view\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"SAP HANA Attribute View &#8211; Create Attribute View in 9 Easy Steps"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53034","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=53034"}],"version-history":[{"count":14,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53034\/revisions"}],"predecessor-version":[{"id":105077,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53034\/revisions\/105077"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/53072"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=53034"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=53034"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=53034"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}