{"id":52762,"date":"2019-03-29T11:24:37","date_gmt":"2019-03-29T05:54:37","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=52762"},"modified":"2021-12-05T21:45:48","modified_gmt":"2021-12-05T16:15:48","slug":"sap-hana-information-modeler","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/","title":{"rendered":"SAP HANA Information Modeler &#8211; Types of Information Views &amp; Engines"},"content":{"rendered":"<p>After\u00a0learning the <strong>basics of modeling in SAP HANA,<\/strong> we will move on to learn the concept of creating the business data models in the SAP HANA Studio Modeler. In this SAP HANA tutorial, we will learn about the information modeler and how to use it to create information views. We will learn about each information view in detail in the later tutorials.<\/p>\n<h3>What is SAP HANA Information Modeler?<\/h3>\n<p>Information Modeler of SAP HANA is a platform that lets you design information views or models on top of <strong>SAP HANA database<\/strong> using tables in it. Such models serve business logic and operation. They are created directly on top of the HANA database layer.<\/p>\n<p>The information modeler provides the interface and tools to select attributes and measures from the database tables. Thus, using the information modeler, a user can create multiple information views using the physical tables of transactional data that stores in the databases of SAP HANA.<\/p>\n<p>The information views are a logical representation of the data which we can further publish or consume for analytical purposes. Information modeling implements on the SAP HANA Modeler perspective of <strong>SAP HANA Studio<\/strong>.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler-Screen.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-52806\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler-Screen.png\" alt=\"SAP HANA Information Modeler Screen\" width=\"1364\" height=\"768\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler-Screen.png 1364w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler-Screen-150x84.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler-Screen-300x169.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler-Screen-768x432.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler-Screen-1024x577.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler-Screen-520x293.png 520w\" sizes=\"auto, (max-width: 1364px) 100vw, 1364px\" \/><\/a><\/p>\n<h3>Features of SAP HANA Information Modeler<\/h3>\n<p>Here are some important features of information modeler.<\/p>\n<p>1. Users can create information views only of the data in columnar orientation or columnar tables in the database. We read the columnar storage tables vertically, and data gets compresses in it. This makes data processing (read\/write operation) much quicker than the traditional row-based data tables.<\/p>\n<p>2. A user can create multiple views using the data in the databases. The database offers more than one type of perspective on the data.<\/p>\n<p>3. Analytical tools utilize information views like SAP Lumira or web-based (HTML or Java) reporting tools.<\/p>\n<p>4. We can also utilize information views in MS Excel connected for <strong>reporting in SAP HANA<\/strong>.<\/p>\n<p>5. The SAP HANA Information Modeler is the powerhouse of SAP HANA as it allows users to use SAP HANA to its complete potential.<\/p>\n<h3>Prerequisites for Creating Information Views<\/h3>\n<p>Let us discuss some prerequisites to create information views in SAP HANA Modeler.<\/p>\n<ul>\n<li>Only an authorized user can log in to the SAP HANA system and work on the information modeler to create views. You can either create a new user and schema or work with an old one.<\/li>\n<li>We create information views from the content folder. A user must have a user object privilege known as \u201cREPOSITORY_REST\u201d. It is only if users have this privilege can they access the content folder. Along with this, Package Privilege is also necessary to modify objects.<\/li>\n<li>A system privilege called \u201cCREATE SCHEMA\u201d is necessary for users to create schemas. We create tables and views within a schema.<\/li>\n<li>We also require Privileges to SYS_REPO.<\/li>\n<\/ul>\n<h3>Information Modeling Views<\/h3>\n<p>There are three Information Modeling Views:<\/p>\n<h4>i. Attribute View<\/h4>\n<p>Attribute view uses attributes, or the non-measurable, non-quantifiable data to design views and models according to the business logic. Thus, the data used in attribute view is referred to as \u2018Master data\u2019 as it is used as reference information in other views (analytic and calculation).<\/p>\n<p>The tables in attribute view do not contain any facts or measure. Entries like quantity sold, sales amount, profit incurred, transaction amount, etc. includes. We will analyze all these measures by different characteristics such as year, quarter, month, vendors, sales departments, product groups etc.<\/p>\n<p>These characteristics are thus called dimensions which we create in the attribute view.<\/p>\n<h4>ii. Analytic View<\/h4>\n<p>We can create star schemas, having a fact table or central transaction and multiple dimension tables linked to it via primary keys in the analytic view. The measures in only the central transaction table which we can group or join with multiple dimension tables as per the logic\u2019s requirement.<\/p>\n<p>The analytic view is the next layer or level of the model after the attribute view.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Calculation-Views-Analytic-Views-Attribute-Views.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-52818\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Calculation-Views-Analytic-Views-Attribute-Views.jpg\" alt=\"Calculation Views, Analytic Views &amp; Attribute Views\" width=\"447\" height=\"271\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Calculation-Views-Analytic-Views-Attribute-Views.jpg 447w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Calculation-Views-Analytic-Views-Attribute-Views-150x91.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Calculation-Views-Analytic-Views-Attribute-Views-300x182.jpg 300w\" sizes=\"auto, (max-width: 447px) 100vw, 447px\" \/><\/a><\/p>\n<h4>iii. Calculation View<\/h4>\n<p>Calculation view is a complex model which uses both attribute and analytic view elements in it to create complete business logic. Thus, it is the next level of modeling for more advanced transformations and logic if we are executing complex operations like combining two data sets.<\/p>\n<p>As we know, what came as a limitation in analytic view is that measure that we can only use from the transaction table. So, if we have transaction data from two tables, such as Sales and Finance, and we want to combine both in one data set, then we can only perform it in the calculation view.<\/p>\n<h3>Different Engines in SAP HANA<\/h3>\n<p>SAP HANA hosts different types of processing engines that process and execute the models created in SAP HANA\u00a0 Information Modeler. Each engine performs a specific function for a particular view in information modeling, which we will discuss in detail here.<\/p>\n<ul>\n<li><strong>Join Engine &#8211;<\/strong> The join engine is used every time when an attribute view is created or used, or a join condition is applied in a native <strong>SQL<\/strong> command. If a calculation applies in an attribute view, the join engine along with calculation engine works to create that attribute view.<\/li>\n<li><strong>OLAP Engine &#8211;<\/strong> The OLAP engine is for the creation of analytical views. It is used only when attributes are used in the analytical view and no calculation is done. If operations like calculations, counters, restricted measures are used then other engines like a calculation engine is used along with the OLAP engine.<\/li>\n<li><strong>Calculation Engine &#8211;<\/strong> The calculation engine is for calculation along with using in other views like analytical and attribute view whenever they apply calculation. The calculation engine might also need other engines to work with it such as OLAP and join engine.<\/li>\n<\/ul>\n<h3>Summary<\/h3>\n<p>Thus, this was our overview of the SAP HANA information modeler. In the coming tutorials, we will learn how to create the three information views; attribute view, analytical view and calculation view using SAP HANA Information Modeler tool.<\/p>\n<p>If you have any queries or feedback, you can enter in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>After\u00a0learning the basics of modeling in SAP HANA, we will move on to learn the concept of creating the business data models in the SAP HANA Studio Modeler. In this SAP HANA tutorial, we&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":52812,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19345,19344,19341],"class_list":["post-52762","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-different-engines-in-sap-hana","tag-information-modeling-views","tag-sap-hana-information-modeler"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SAP HANA Information Modeler - Types of Information Views &amp; Engines - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn SAP HANA Information Modeler, its features, prerequisites for creating information views, information modeling views and engines in SAP HANA.\" \/>\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-information-modeler\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAP HANA Information Modeler - Types of Information Views &amp; Engines - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn SAP HANA Information Modeler, its features, prerequisites for creating information views, information modeling views and engines in SAP HANA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/\" \/>\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-03-29T05:54:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-05T16:15:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler.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=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAP HANA Information Modeler - Types of Information Views &amp; Engines - DataFlair","description":"Learn SAP HANA Information Modeler, its features, prerequisites for creating information views, information modeling views and engines in SAP HANA.","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-information-modeler\/","og_locale":"en_US","og_type":"article","og_title":"SAP HANA Information Modeler - Types of Information Views &amp; Engines - DataFlair","og_description":"Learn SAP HANA Information Modeler, its features, prerequisites for creating information views, information modeling views and engines in SAP HANA.","og_url":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-03-29T05:54:37+00:00","article_modified_time":"2021-12-05T16:15:48+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler.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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SAP HANA Information Modeler &#8211; Types of Information Views &amp; Engines","datePublished":"2019-03-29T05:54:37+00:00","dateModified":"2021-12-05T16:15:48+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/"},"wordCount":997,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler.jpg","keywords":["Different Engines in SAP HANA","Information Modeling Views","SAP HANA Information Modeler"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/","url":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/","name":"SAP HANA Information Modeler - Types of Information Views &amp; Engines - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler.jpg","datePublished":"2019-03-29T05:54:37+00:00","dateModified":"2021-12-05T16:15:48+00:00","description":"Learn SAP HANA Information Modeler, its features, prerequisites for creating information views, information modeling views and engines in SAP HANA.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SAP-HANA-Information-Modeler.jpg","width":1200,"height":628,"caption":"SAP HANA Information Modeler"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sap-hana-information-modeler\/#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 Information Modeler &#8211; Types of Information Views &amp; Engines"}]},{"@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\/52762","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=52762"}],"version-history":[{"count":13,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/52762\/revisions"}],"predecessor-version":[{"id":105081,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/52762\/revisions\/105081"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/52812"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=52762"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=52762"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=52762"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}