{"id":12479,"date":"2021-10-21T17:12:12","date_gmt":"2021-10-21T15:12:12","guid":{"rendered":"https:\/\/www.rapidviews.io\/?p=12479"},"modified":"2025-03-27T16:32:57","modified_gmt":"2025-03-27T15:32:57","slug":"sap-data-warehouse-cloud","status":"publish","type":"post","link":"https:\/\/dev.rapidviews.io\/en\/blog\/sap-data-warehouse-cloud\/sap-data-warehouse-cloud","title":{"rendered":"SAP Data Warehouse Cloud"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"12479\" class=\"elementor elementor-12479\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-60404a87 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"60404a87\" 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-32f402e1\" data-id=\"32f402e1\" 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-6393e3d elementor-widget elementor-widget-heading\" data-id=\"6393e3d\" 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\">Presentation<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aed8a66 elementor-widget elementor-widget-text-editor\" data-id=\"aed8a66\" 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>SAP Data Warehouse Cloud is available since the end of 2019. It is a SaaS application for building data warehouses with data processing functionalities and advanced semantic management. SAP DWC is based on <a href=\"https:\/\/www.sap.com\/france\/products\/hana.html\" target=\"_blank\" rel=\"noopener\">SAP HANA<\/a> and therefore benefits from In-Memory technology. This application succeeds in combining the process of data management with the openness to advanced analysis tools.<\/p><p>This data warehouse is designed for both business users and development teams.<\/p><p>For reporting, SAP Data Warehouse Cloud relies on <a href=\"https:\/\/www.sap.com\/france\/products\/cloud-analytics.html\" target=\"_blank\" rel=\"noopener\">SAP Analytics Cloud<\/a>, offering the possibility of a complete data warehouse in the cloud including modelling, consumption, data transformation and visualisation.<\/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-898f1c7 elementor-widget elementor-widget-heading\" data-id=\"898f1c7\" 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\">The different layers<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-274d6f5 elementor-widget elementor-widget-heading\" data-id=\"274d6f5\" 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-medium\">Data Builder<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b9bbc16 elementor-widget elementor-widget-text-editor\" data-id=\"b9bbc16\" 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 data modelling layer allows us to retrieve <strong>data<\/strong> from our system using the <strong>Data Flow Graph<\/strong>. Various operations on the data are already possible at this stage.<\/p><p>In addition, we find common panes in all <strong>SAP DWC<\/strong>, on the left, a panel for consulting existing tables or tables available via our connections. In the centre, we have the graphical part which allows us to model our models thanks to <strong>Drag And Drop<\/strong> actions.<\/p><p>Below this part, we have a <strong>Data Preview<\/strong> that will allow us to check the consistency of our data throughout the process. On the last panel on the right, we have access to the <strong>metadata<\/strong>: technical name, business name, description of the view, distribution between attributes and measures, last update date, deployment status.<\/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-2cdebbb elementor-widget elementor-widget-image\" data-id=\"2cdebbb\" 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\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/data-builder-flow-graph.png\" title=\"\" alt=\"Data builder flow graph\" loading=\"lazy\" \/>\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-5002bf3 elementor-widget elementor-widget-text-editor\" data-id=\"5002bf3\" 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>We can also create views in the <strong>Data Builder<\/strong>. These views are broken down into different types. We have the possibility of creating dimensions, factual views and finally &#8220;<strong>Analytical Datasets<\/strong>&#8221; which are the representation of our datamarts and which we use in our reporting tools.<\/p><p>In the creation of views, we use previously created tables or tables available directly via our connections. We apply <strong>modifications<\/strong> and <strong>transformations<\/strong> such as aggregations, filters, calculated columns or projections.<\/p><p>We can also apply joins or unions between our different tables. In addition to creating graphical views, we have the possibility to create <strong>SQL script views<\/strong>.<\/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-9633c3a elementor-widget elementor-widget-image\" data-id=\"9633c3a\" 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\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/vues-graphiques-scripts.png\" title=\"\" alt=\"Vues graphiques scripts\" loading=\"lazy\" \/>\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\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-50528577 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"50528577\" 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-42156ca2\" data-id=\"42156ca2\" 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-46c92fef elementor-widget-divider--view-line_text elementor-widget-divider--element-align-right elementor-widget elementor-widget-divider\" data-id=\"46c92fef\" 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-391270a elementor-widget elementor-widget-heading\" data-id=\"391270a\" 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-525fd58b elementor-widget elementor-widget-text-editor\" data-id=\"525fd58b\" 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-272f01e0 elementor-button-align-stretch elementor-widget elementor-widget-form\" data-id=\"272f01e0\" 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=\"12479\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"272f01e0\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"SAP Data Warehouse Cloud\" \/>\n\n\t\t\t\t\t\t\t<input type=\"hidden\" name=\"queried_id\" value=\"12479\"\/>\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-758ddb6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"758ddb6\" 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-f8527aa\" data-id=\"f8527aa\" 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-06815e1 elementor-widget elementor-widget-text-editor\" data-id=\"06815e1\" 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 E\/R Model is the last view that can be created using the <strong>Data Builder<\/strong>. The purpose of this view is to fill in the joins between the factual view and the dimensions and to have a visual aspect on them in addition to being able to consult the available <strong>semantic layer<\/strong>. We can quickly see which dimension is attached to this factual view in order to create our <a href=\"https:\/\/dev.rapidviews.io\/blog\/datamart\/les-datamarts-sur-sap-hana\" target=\"_blank\" rel=\"noopener\">datamart<\/a>.<\/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-ef36a4e elementor-widget elementor-widget-image\" data-id=\"ef36a4e\" 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\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/dimension-fait-creation-datamart.png\" title=\"\" alt=\"Dimension fait cr\u00e9ation datamart\" loading=\"lazy\" \/>\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-0df72cc elementor-widget elementor-widget-heading\" data-id=\"0df72cc\" 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-medium\">Business Builder<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4d08f3e elementor-widget elementor-widget-text-editor\" data-id=\"4d08f3e\" 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 Business Builder has a data advisory purpose and will be aimed at <strong>end users<\/strong>.<\/p><p>We need to recreate the tables in the <strong>Business Layer<\/strong> by indicating which table in the <strong>Data Builder<\/strong> we want to retrieve our data for the dimension.<\/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-89bb668 elementor-widget elementor-widget-image\" data-id=\"89bb668\" 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\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/business-layer-data-.png\" title=\"\" alt=\"Business Layer Data\" loading=\"lazy\" \/>\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-3d4742b elementor-widget elementor-widget-text-editor\" data-id=\"3d4742b\" 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>Different information about our dimension can be entered here in addition to the versioning that is available in the Business Builder. Different sub-menus &#8220;<strong>Attributes<\/strong>&#8220;, &#8220;<strong>Measures<\/strong>&#8221; and &#8220;<strong>Key Definition<\/strong>&#8221; allow us to fill in our data by assigning it to the functions of each. When creating a <strong>datamart<\/strong> in the <strong>Business Builder<\/strong>, we need to create our associations between our factual views and the dimensions.<\/p><p>In order to be able to adapt to business needs, we can create calculated fields, and even <strong>measures<\/strong> in this part. We can also create contexts in order to <strong>avoid conflicts<\/strong> between our data and to allow analysis of the data.<\/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-7d7b52d elementor-widget elementor-widget-image\" data-id=\"7d7b52d\" 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\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/data-consumption.png\" title=\"\" alt=\"Data consumption\" loading=\"lazy\" \/>\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-e1885b4 elementor-widget elementor-widget-text-editor\" data-id=\"e1885b4\" 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>We can then create a <strong>Data Consumption<\/strong> so that we can access our data in a more readable way. The addition of our <strong>measures<\/strong> and <strong>attributes<\/strong> is again required and the addition of the previously created dimensions is required. The <strong>Data Preview<\/strong> section then allows us to navigate through our data to analyse it.<\/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-6a54e38 elementor-widget elementor-widget-heading\" data-id=\"6a54e38\" 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-medium\">Connectors<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-838e37a elementor-widget elementor-widget-text-editor\" data-id=\"838e37a\" 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 data import, we have<strong> 27 connectors<\/strong> for SAP and non-SAP databases at our disposal, so here are some examples:<\/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-b793325 elementor-widget elementor-widget-image\" data-id=\"b793325\" 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\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/connecteurs-sap.png\" title=\"\" alt=\"Connecteurs SAP\" loading=\"lazy\" \/>\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-b8e8820 elementor-widget elementor-widget-text-editor\" data-id=\"b8e8820\" 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>These connectors allow us to access our data very easily without having to configure additional tools. However, if our <a href=\"https:\/\/www.sap.com\/france\/index.html\" target=\"_blank\" rel=\"noopener\">SAP<\/a> database does not appear in the list of connectors, we can always configure the SAP <strong>Data Provising Agent<\/strong> to act as a <strong>connector<\/strong> between our database and <strong>SAP DWC<\/strong>.<\/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-1c87666 elementor-widget elementor-widget-heading\" data-id=\"1c87666\" 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-medium\">Reporting<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be426e1 elementor-widget elementor-widget-text-editor\" data-id=\"be426e1\" 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 <strong>reporting<\/strong> part is the final result that will be made available to customers. We will then find on these tools all the <strong>semantic layer<\/strong> which will have been set up in SAP DWC. We will be able to use the attributes of our dimensions thanks to our previously created joins.<\/p><p>We can use the attributes of our dimensions thanks to the joins we created earlier, so we have a range of simple or cross <b>tables<\/b> and <b>graphs<\/b> at our disposal. We can apply filters and sorting to these visuals.<\/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-cc52fa2 elementor-widget elementor-widget-image\" data-id=\"cc52fa2\" 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\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/reporting-sap-dwc.png\" title=\"\" alt=\"Reporting SAP DWC\" loading=\"lazy\" \/>\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-80128b9 elementor-widget elementor-widget-text-editor\" data-id=\"80128b9\" 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 reporting part can be done on the SAP Analytics Cloud tool which has a <strong>direct connector<\/strong> with SAP DWC. However, the use of other tools remains possible via ODBC, which makes SAP DWC <strong>compatible<\/strong> with <strong>Microsoft Power BI<\/strong> or <strong>Tableau Software<\/strong> for example.<\/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-dee6096 elementor-widget elementor-widget-image\" data-id=\"dee6096\" 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\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/compatibilite-sap-dwc-power-bi.png\" title=\"\" alt=\"Compatibilit\u00e9 SAP DWC Power BI\" loading=\"lazy\" \/>\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-01e44a5 elementor-widget elementor-widget-text-editor\" data-id=\"01e44a5\" 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 create an ODBC connection, use ODBC Configuration for<strong> SAP HANA<\/strong> and specify the Host of the SAP DWC space and the port number. Afterwards, on the <strong>reporting<\/strong> tool, it is sufficient to select the ODBC connection we have just created. An identification is necessary with the <strong>SAP DWC<\/strong> identifiers. We will then have access to the data where the &#8220;<strong>Allow Consumption<\/strong>&#8221; option, present in the view properties, has been checked.<\/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-04fdb06 elementor-widget elementor-widget-image\" data-id=\"04fdb06\" 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\" src=\"https:\/\/dev.rapidviews.io\/wp-content\/uploads\/2021\/10\/configuration-sap-hana.png\" title=\"\" alt=\"Configuration SAP HANA\" loading=\"lazy\" \/>\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-bcca68f elementor-widget elementor-widget-heading\" data-id=\"bcca68f\" 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-2b37f82 elementor-widget elementor-widget-text-editor\" data-id=\"2b37f82\" 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>This new SAP Data Warehouse Cloud application allows us to perform <strong>complex tasks<\/strong> from any workstation. <strong>Mobility<\/strong> is a strength of this application. In addition, the speed and ease of use of the tool allows us to access <strong>results in record time<\/strong>.<\/p><p>SAP is permissive towards third-party tools with many connectors, which allows <strong>SAP Data Warehouse Cloud<\/strong> to have an even more open customer base.<\/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>SAP Data Warehouse Cloud is available since the end of 2019. It is a SaaS application for building data warehouses with data processing capabilities and advanced semantic management.<\/p>\n","protected":false},"author":10,"featured_media":44473,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[575],"tags":[],"class_list":["post-12479","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-data-warehouse-cloud"],"_links":{"self":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/12479","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/comments?post=12479"}],"version-history":[{"count":0,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/12479\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media\/44473"}],"wp:attachment":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media?parent=12479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/categories?post=12479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/tags?post=12479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}