{"id":12156,"date":"2021-10-05T15:25:56","date_gmt":"2021-10-05T13:25:56","guid":{"rendered":"https:\/\/www.rapidviews.io\/blog\/uncategorized\/les-datamarts-sur-sap-hana"},"modified":"2025-03-27T16:35:11","modified_gmt":"2025-03-27T15:35:11","slug":"datamarts-on-sap-hana","status":"publish","type":"post","link":"https:\/\/dev.rapidviews.io\/en\/blog\/datamart\/datamarts-on-sap-hana","title":{"rendered":"Datamarts on SAP HANA"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"12156\" class=\"elementor elementor-12156 elementor-12045\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6d5571b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6d5571b2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-73da3cd1\" data-id=\"73da3cd1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7d35526d elementor-widget elementor-widget-heading\" data-id=\"7d35526d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Introduction<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-325589e9 elementor-widget elementor-widget-text-editor\" data-id=\"325589e9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><b>Calculation views<\/b> offer many possibilities in terms of modelling on <a href=\"https:\/\/www.sap.com\/france\/products\/hana.html\" target=\"_blank\" rel=\"noopener\">SAP HANA<\/a>. Several types of views can be developed (Attribute or Dimension, Analytical, Calculation or Fact, Script, Datamart).<\/p><p>In this article we will talk about a type of view that is widely used within BI data models: <b>Datamarts<\/b>.<\/p><p>Datamarts are data counters, based on a star schema (a type of modelling very frequently used in BI) allowing a fact view to be joined to <b>dimensions<\/b>. They are usually the top layer of the information model and are the views used by the <b>reporting<\/b> tools.<\/p><p>These datamarts can then be used by all reporting tools with a <b>HANA connector<\/b> (SAP BO, SAP Analytics Cloud, Power BI, Tableau, etc.).<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75753ad5 elementor-widget elementor-widget-image\" data-id=\"75753ad5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"253\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/modele-sap-hana-datamarts-1024x324.png\" class=\"attachment-large size-large wp-image-12067\" alt=\"Mod\u00e8le SAP HANA Datamarts\" srcset=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/modele-sap-hana-datamarts-1024x324.png 1024w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/modele-sap-hana-datamarts-300x95.png 300w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/modele-sap-hana-datamarts-768x243.png 768w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/modele-sap-hana-datamarts.png 1408w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-52e8ea0e elementor-widget elementor-widget-text-editor\" data-id=\"52e8ea0e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Before building a <b>datamart<\/b>, it is essential to understand the difference between a <b>factual view<\/b> and a <b>dimensional view<\/b>, as each has its own specific place in the datamart.<\/p><p>The distinction between these two types of views is based on the type of data they expose.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5eac54c0 elementor-widget elementor-widget-heading\" data-id=\"5eac54c0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Factual view<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc55ca5 elementor-widget elementor-widget-text-editor\" data-id=\"cc55ca5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A factual view illustrates a quantifiable activity over time. Among the data reported, we find indicators (aggregable data), such as quantities, amounts, or volumes. The indicators are intended to measure an activity, often on a daily basis. Indeed, the source tables at the base of the factual view model are fed very regularly by the system.<\/p><p>For example, it is possible to build a factual view from tables containing customer invoices or production orders. What these tables have in common is that they contain <b>temporal and quantitative data\u00a0<\/b>: invoice amounts, quantities produced, etc.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-62166a1 elementor-widget elementor-widget-heading\" data-id=\"62166a1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Dimensions<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3852c228 elementor-widget elementor-widget-text-editor\" data-id=\"3852c228\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The essence of a dimensional view is to provide analysis axes. It does not contain any quantitative data, but only <b>attribute fields<\/b>. The dimension can contain <b>master data<\/b> or <b>labels<\/b>.<\/p><p>We can take the case of a dimension dedicated to customers. This view can contain all the information related to customers, such as their name, location (country, region, city), bank data, the name of the sales representatives, the hierarchy, etc.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-64fb3356 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"64fb3356\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-wider\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3fa09e17\" data-id=\"3fa09e17\" data-element_type=\"column\" data-e-type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5cb8776f elementor-widget-divider--view-line_text elementor-widget-divider--element-align-right elementor-widget elementor-widget-divider\" data-id=\"5cb8776f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t\t<span class=\"elementor-divider__text elementor-divider__element\">\n\t\t\t\tStay connected !\t\t\t\t<\/span>\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-630b09a1 elementor-widget elementor-widget-heading\" data-id=\"630b09a1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Subscribe to the Rapid Views Newsletter !<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d9fe7d9 elementor-widget elementor-widget-text-editor\" data-id=\"1d9fe7d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><span style=\"color: #ffffff;\">Stay up to date with our latest blog posts, upcoming webinars and news!<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c4818b9 elementor-button-align-stretch elementor-widget elementor-widget-form\" data-id=\"1c4818b9\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;button_width&quot;:&quot;20&quot;,&quot;step_next_label&quot;:&quot;Suivant&quot;,&quot;step_previous_label&quot;:&quot;Pr\\u00e9c\\u00e9dent&quot;,&quot;step_type&quot;:&quot;number_text&quot;,&quot;step_icon_shape&quot;:&quot;circle&quot;}\" data-widget_type=\"form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<form class=\"elementor-form\" method=\"post\" name=\"Inscription Newsletter (EN)\" aria-label=\"Inscription Newsletter (EN)\">\n\t\t\t<input type=\"hidden\" name=\"post_id\" value=\"12156\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"1c4818b9\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"Datamarts on SAP HANA\" \/>\n\n\t\t\t\t\t\t\t<input type=\"hidden\" name=\"queried_id\" value=\"12156\"\/>\n\t\t\t\n\t\t\t<div class=\"elementor-form-fields-wrapper elementor-labels-\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-type-email elementor-field-group elementor-column elementor-field-group-email elementor-col-40 elementor-field-required\">\n\t\t\t\t\t\t\t\t\t\t\t\t<label for=\"form-field-email\" class=\"elementor-field-label elementor-screen-only\">\n\t\t\t\t\t\t\t\tYour e-mail address\t\t\t\t\t\t\t<\/label>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<input size=\"1\" type=\"email\" name=\"form_fields[email]\" id=\"form-field-email\" class=\"elementor-field elementor-size-xs  elementor-field-textual\" placeholder=\"Your e-mail address\" required=\"required\">\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t<div class=\"elementor-field-group elementor-column elementor-field-type-submit elementor-col-20 e-form__buttons\">\n\t\t\t\t\t<button class=\"elementor-button elementor-size-sm\" type=\"submit\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-button-text\">Register<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/button>\n\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t<\/form>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1f1e380f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1f1e380f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-400f5826\" data-id=\"400f5826\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5a53d088 elementor-widget elementor-widget-heading\" data-id=\"5a53d088\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Datamart<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-17296ea5 elementor-widget elementor-widget-text-editor\" data-id=\"17296ea5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>To link a factual view to the dimensional views following good relational modelling practice, a star schema should be used. This is called a datamart.<\/p><p>In HANA Studio, only calculation views have the &#8220;Star Join&#8221; feature, which is used to model a star schema. <b>Attribute views<\/b> and <b>analytic views<\/b> do not.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab051f8 elementor-widget elementor-widget-heading\" data-id=\"ab051f8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Use cases on HANA Studio<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de0056b elementor-widget elementor-widget-text-editor\" data-id=\"de0056b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>In this example, if we want to view the amounts invoiced by customer city and by items manufactured by the factories, then we need to :<\/p><ul><li>Develop a factual view based on the invoice tables<\/li><li>Then create two dimensions that will carry the attributes we need :<ul><li>A customer dimension for the customer city<\/li><li>A material dimension for the manufacturing plant<\/li><\/ul><\/li><\/ul><p>With HANA Studio, the <b>calculation views<\/b> are configured differently depending on the type of view you want to create (dimensions, fact views or datamart).<\/p><p>A dimensional view should not contain quantitative data, and should be set to &#8220;Data Category = DIMENSION&#8221; in the view properties:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6769c5c elementor-widget elementor-widget-image\" data-id=\"6769c5c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"450\" height=\"300\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/vue-dimensionelle-sap-hana-datamarts-1.png\" class=\"attachment-full size-full wp-image-57567\" alt=\"Vue d\u00e9taill\u00e9e d\u2019une mod\u00e9lisation dimensionnelle dans un datamart SAP HANA, montrant les liens entre diff\u00e9rentes dimensions et faits.\" srcset=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/vue-dimensionelle-sap-hana-datamarts-1.png 450w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/vue-dimensionelle-sap-hana-datamarts-1-300x200.png 300w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-052171d elementor-widget elementor-widget-text-editor\" data-id=\"052171d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The factual view must be set to &#8220;Data Category = CUBE&#8221;.<\/p><p>It is possible to configure the Data Category in the view creation window :<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8c618d elementor-widget elementor-widget-image\" data-id=\"a8c618d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"400\" height=\"400\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/data-category-datamarts.png\" class=\"attachment-full size-full wp-image-57565\" alt=\"Image technique illustrant un exemple de mod\u00e9lisation ou de test de flux analytique dans SAP HANA (contenu \u00e0 pr\u00e9ciser selon contexte final).\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5bd0ca8 elementor-widget elementor-widget-text-editor\" data-id=\"5bd0ca8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>For a datamart, the <strong>Data Category<\/strong> must also be set to CUBE.<\/p>\n<p>Unlike the factual view, the datamart contains a <strong>Star Join<\/strong>. To add it, check &#8220;With Star Join&#8221; when creating the view.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7307e82 elementor-widget elementor-widget-image\" data-id=\"7307e82\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"400\" height=\"400\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/star-join-sap-hana-datamarts-1.png\" class=\"attachment-full size-full wp-image-57563\" alt=\"Sch\u00e9ma repr\u00e9sentant un Star Join SAP HANA avec liens entre table de faits centrale et tables de dimensions, utilis\u00e9 pour les datamarts.\" srcset=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/star-join-sap-hana-datamarts-1.png 400w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/star-join-sap-hana-datamarts-1-300x300.png 300w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/star-join-sap-hana-datamarts-1-150x150.png 150w\" sizes=\"(max-width: 400px) 100vw, 400px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-54844bd elementor-widget elementor-widget-text-editor\" data-id=\"54844bd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The factual view is integrated into a Projection in the Star Join input. Its content is then defined by dragging and dropping from the list of available factual views.<\/p><p>The dimensions are dropped directly into the Star Join, by dragging and dropping from the list of available dimension views:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d0fa7e9 elementor-widget elementor-widget-image\" data-id=\"d0fa7e9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"350\" height=\"250\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/star-join-2-sap-hana-datamarts-1.png\" class=\"attachment-full size-full wp-image-57561\" alt=\"Exemple de Star Join SAP HANA montrant la relation entre une table de faits et plusieurs dimensions dans un datamart analytique.\" srcset=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/star-join-2-sap-hana-datamarts-1.png 350w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/star-join-2-sap-hana-datamarts-1-300x214.png 300w\" sizes=\"(max-width: 350px) 100vw, 350px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8de85b2 elementor-widget elementor-widget-text-editor\" data-id=\"8de85b2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Lastly, the joins between the different fact and dimension views are created in the <b>graphical interface<\/b>. It is necessary to ensure that all the necessary join keys are available in the fact view.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6c69584 elementor-widget elementor-widget-image\" data-id=\"6c69584\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"600\" height=\"600\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/interface-graphique-sap-hana-datamarts-1.png\" class=\"attachment-full size-full wp-image-57559\" alt=\"Interface graphique illustrant la structure des datamarts SAP HANA, avec mod\u00e9lisation des objets analytiques et des relations de donn\u00e9es.\" srcset=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/interface-graphique-sap-hana-datamarts-1.png 600w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/interface-graphique-sap-hana-datamarts-1-300x300.png 300w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/interface-graphique-sap-hana-datamarts-1-150x150.png 150w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a8d1684 elementor-widget elementor-widget-heading\" data-id=\"a8d1684\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Use cases on Power BI<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c1eeb29 elementor-widget elementor-widget-text-editor\" data-id=\"c1eeb29\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The <b>calculation views<\/b> are compatible with many reporting tools (Power BI, Tableau, SAP BO, etc.).<\/p><p>Let&#8217;s take the example of <b>Power BI<\/b> to show the datamart developed in the previous section.<\/p><p>Power BI offers a connection to a HANA database, with the possibility of connecting using either an import mode (data stored in cache) or a direct query mode (data in real time).<\/p><p>Once the connection is made with the <b>HANA<\/b> database, the list of data marts is available in Power BI, and we can then choose a visual from the palette offered by Power BI.<\/p><p>Here is an example of a &#8220;map&#8221; visual<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d08e52b elementor-widget elementor-widget-image\" data-id=\"d08e52b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1100\" height=\"627\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/visuel-carte-sap-hana-datamarts.png\" class=\"attachment-full size-full wp-image-12085\" alt=\"Visuel carte SAP HANA Datamarts\" srcset=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/visuel-carte-sap-hana-datamarts.png 1100w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/visuel-carte-sap-hana-datamarts-300x171.png 300w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/visuel-carte-sap-hana-datamarts-1024x584.png 1024w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/visuel-carte-sap-hana-datamarts-768x438.png 768w\" sizes=\"(max-width: 1100px) 100vw, 1100px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5a41d33 elementor-widget elementor-widget-text-editor\" data-id=\"5a41d33\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A bar chart<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-392b119 elementor-widget elementor-widget-image\" data-id=\"392b119\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"870\" height=\"296\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/diagramme-barre-sap-hana-datamarts.png\" class=\"attachment-full size-full wp-image-12088\" alt=\"Diagramme barre SAP HANA Datamarts\" srcset=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/diagramme-barre-sap-hana-datamarts.png 870w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/diagramme-barre-sap-hana-datamarts-300x102.png 300w, https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/diagramme-barre-sap-hana-datamarts-768x261.png 768w\" sizes=\"(max-width: 870px) 100vw, 870px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9d5a58c elementor-widget elementor-widget-text-editor\" data-id=\"9d5a58c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The invoice amounts come from the factual view, while the customer name comes from the dimension. These two views joined in the datamart by the customer number allow the data to be analysed.<\/p><p>All this complexity is hidden from Power BI users, as it is handled by the <b>datamart<\/b>, fact and dimension views in <b>HANA<\/b>. Users of the reporting tool have access to a data counter (the datamart) with the full semantic layer allowing them to create their own analyses.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-293b17c1 elementor-widget elementor-widget-heading\" data-id=\"293b17c1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-large\">Conclusion<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-58462a35 elementor-widget elementor-widget-text-editor\" data-id=\"58462a35\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Thanks to the functionalities of the HANA platform, the different types of views and the &#8220;<b>Star Join<\/b>&#8221; options, we can create datamarts in HANA, also called data counters, which make SAP data readable and easily exploitable in reporting tools.<\/p><p>The data marts are created with the &#8220;<b>best practices<\/b>&#8221; of a BI system and allow users to make the most of the data made available, and to exploit it in their operational and <b>BI reporting<\/b>.<\/p><p>In addition, all these HANA data marts are compatible with most of the reporting tools on the market; these data marts can therefore be used identically with the same data in one or more reporting tools (SAP WebIntelligence, SAP Analytics Cloud, Power Bi, Tableau Software, Excel, &#8230;)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Calculation views offer many possibilities in terms of modelling on SAP HANA. Several types of views can be developed (Attribute or Dimension, Analytical, Calculation or Fact, Script, Datamart). <\/p>\n","protected":false},"author":5,"featured_media":59485,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[576],"tags":[],"class_list":["post-12156","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-datamart"],"_links":{"self":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/12156","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/comments?post=12156"}],"version-history":[{"count":0,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/12156\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media\/59485"}],"wp:attachment":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media?parent=12156"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/categories?post=12156"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/tags?post=12156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}