{"id":18535,"date":"2023-06-02T16:35:14","date_gmt":"2023-06-02T14:35:14","guid":{"rendered":"https:\/\/dev.rapidviews.io\/blog\/uncategorized\/gestion-performance-sap-hana-studio"},"modified":"2025-03-27T14:25:16","modified_gmt":"2025-03-27T13:25:16","slug":"performance-management-sap-hana-studio","status":"publish","type":"post","link":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio","title":{"rendered":"Performance management in the SAP HANA Studio"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"18535\" class=\"elementor elementor-18535\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6fc6b0f7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6fc6b0f7\" 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-68116c7f\" data-id=\"68116c7f\" 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-5a8d3a69 elementor-widget elementor-widget-heading\" data-id=\"5a8d3a69\" 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-5fd673d2 elementor-widget elementor-widget-text-editor\" data-id=\"5fd673d2\" 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 href=\"https:\/\/www.sap.com\/products\/technology-platform\/hana\/what-is-sap-hana.html\" target=\"_blank\" rel=\"noopener\">SAP HANA<\/a>, for High-performance ANalytic Appliance, is designed to be a\u00a0<strong>high-performance database management system<\/strong>. The data transformation tools it offers within its interface and the architecture of the software make it relevant to its users. This article looks at the design and key features of the tool, which make it a leading orchestra conductor for data management.<\/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-7e3c98d elementor-widget elementor-widget-heading\" data-id=\"7e3c98d\" 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\">SAP HANA: optimised data management<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86acfae elementor-widget elementor-widget-text-editor\" data-id=\"86acfae\" 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><strong>SAP HANA<\/strong>\u00a0uses\u00a0<strong>in-memory storage<\/strong>, which consists of storing compressed data in RAM, making it possible to read and edit data and thus gain in efficiency compared with other disk-based systems. To store its data,\u00a0<strong>SAP HANA<\/strong>\u00a0has columnar storage instead of online storage. Explanations:<\/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-2f5d3209 elementor-widget elementor-widget-image\" data-id=\"2f5d3209\" 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:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/sap-hana-stockage-colonne.png\" title=\"\" alt=\"SAP HANA stockage colonne\" 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-49c17174 elementor-widget elementor-widget-text-editor\" data-id=\"49c17174\" 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<div class=\"elementor-element elementor-element-1f017b9 elementor-widget elementor-widget-text-editor\" data-id=\"1f017b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p>Stored online, the previous table would be stored as follows:<\/p><p><img decoding=\"async\" class=\"size-full wp-image-18489\" src=\"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/explication-stockage-en-ligne.png\" sizes=\"(max-width: 232px) 100vw, 232px\" srcset=\"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/explication-stockage-en-ligne.png 232w, https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/explication-stockage-en-ligne-228x36.png 228w\" alt=\"Explication du stockage en ligne\" width=\"232\" height=\"36\" \/><\/p><\/div><\/div><\/div><div class=\"elementor-element elementor-element-9952001 elementor-widget elementor-widget-text-editor\" data-id=\"9952001\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p>Once the data has been organised into columns, the attributes can be aggregated to further compress the data:<\/p><p><img decoding=\"async\" class=\"size-full wp-image-18486\" src=\"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/explication-stockage-en-colonne.png\" alt=\"Explication du stockage en colonne\" width=\"196\" height=\"34\" \/><\/p><\/div><\/div><\/div><div class=\"elementor-element elementor-element-400064d elementor-widget elementor-widget-text-editor\" data-id=\"400064d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p>This also allows sequential access, which is also very advantageous. As online storage is sometimes more suitable \u2013 the data is completely re-sorted when it is updated \u2013\u00a0<strong>SAP HANA<\/strong>\u00a0uses the most suitable storage method and transfers the data. When a table is created manually, it is possible to choose the type of storage for this table, bearing in mind that by default it is a table of columns.<\/p><p>In terms of managing calculations,\u00a0<strong>SAP HANA<\/strong>\u00a0operates them as far as possible at the data storage layer, freeing up the application layer to focus on its key processing functions.<\/p><\/div><\/div><\/div>\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-4c71efb0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4c71efb0\" 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-4b1c7bc2\" data-id=\"4b1c7bc2\" 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-44654e88 elementor-widget-divider--view-line_text elementor-widget-divider--element-align-right elementor-widget elementor-widget-divider\" data-id=\"44654e88\" 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-703935b1 elementor-widget elementor-widget-heading\" data-id=\"703935b1\" 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-21b79bf9 elementor-widget elementor-widget-text-editor\" data-id=\"21b79bf9\" 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-51745da5 elementor-button-align-stretch elementor-widget elementor-widget-form\" data-id=\"51745da5\" 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=\"18535\"\/>\n\t\t\t<input type=\"hidden\" name=\"form_id\" value=\"51745da5\"\/>\n\t\t\t<input type=\"hidden\" name=\"referer_title\" value=\"Performance management on the SAP HANA Studio\" \/>\n\n\t\t\t\t\t\t\t<input type=\"hidden\" name=\"queried_id\" value=\"18535\"\/>\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-3fa76c16 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3fa76c16\" 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-71f1145a\" data-id=\"71f1145a\" 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-64b0b71 elementor-widget elementor-widget-heading\" data-id=\"64b0b71\" 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\">Data analysis and performance\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c9cf37a elementor-widget elementor-widget-text-editor\" data-id=\"c9cf37a\" 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<div class=\"elementor-element elementor-element-1f017b9 elementor-widget elementor-widget-text-editor\" data-id=\"1f017b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-8f9e177 elementor-widget elementor-widget-text-editor\" data-id=\"8f9e177\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p><strong>SAP HANA<\/strong>\u00a0enables users to model analytical views. These consist of building a schematic data model that processes data persistently. Using this type of view as opposed to SQL queries has a number of advantages, particularly in terms of performance.<\/p><p><strong>SAP HANA\u2019s modelling<\/strong>\u00a0reduces the number of joins compared with a traditional SQL model: the modelling supports calculations based on the fields available in the same table, unlike SQL, which requires you to go through nested sub-queries. This makes data manipulation operations considerably lighter. Pre-calculating tables using data persistence also reduces the number of joins, and means that data that has already been aggregated can be injected, saving on RAM allocation.<\/p><\/div><\/div><\/div><\/div><\/div><\/div>\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-a252d47 elementor-widget elementor-widget-heading\" data-id=\"a252d47\" 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\">Best practices for building an optimised analytical view\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c9f94e3 elementor-widget elementor-widget-text-editor\" data-id=\"c9f94e3\" 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<div class=\"elementor-element elementor-element-1f017b9 elementor-widget elementor-widget-text-editor\" data-id=\"1f017b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-8f9e177 elementor-widget elementor-widget-text-editor\" data-id=\"8f9e177\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p><a href=\"https:\/\/www.sap.com\/index.html\" target=\"_blank\" rel=\"noopener\">SAP<\/a>\u00a0offers a number of recommendations for building a high-performance view.<\/p><p><img decoding=\"async\" class=\"size-full wp-image-18498\" src=\"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/performance-icone.png\" alt=\"Performance icone\" width=\"92\" height=\"51\" \/>\u00a0<strong>Setting cardinalities for joins<\/strong>: although not mandatory, this parameter is required to speed up the search. The cardinality indicates the number of rows in a table which corresponds to the number of rows in the joined table. The match is made on one or more (n) rows. To identify the cardinality between two tables, the user can use the keys of each table, which indicate a unique record. In general, a left join between a fact table and a dimension table has a cardinality of N to 1.<br \/>Illustration: in a join between a customer order table (header data) and a customer description table (name, address, etc.), each customer reference corresponds to a single line of description. Conversely, each description can be assigned to several lines in the order table, since the same customer will place several orders.<br \/>The advantage of entering cardinality in terms of performance therefore lies in the fact that when the customer name (right-hand table) is assigned to the customer reference (left-hand table), the tool knows that it can stop browsing the other lines in the table. If the cardinality was not indicated, it would have scanned the entire table, uselessly, as no other results would have been found. This operation would have been performed for each record in the left-hand table.<br \/>The cardinality is set in the join editor:<\/p><\/div><\/div><\/div><\/div><\/div><\/div>\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-48b34aa elementor-widget elementor-widget-image\" data-id=\"48b34aa\" 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:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/cardinalite-editeur-jointures.png\" title=\"\" alt=\"Cardinalite \u00e9diteur jointures\" 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-bae38d8 elementor-widget elementor-widget-text-editor\" data-id=\"bae38d8\" 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<div class=\"elementor-element elementor-element-1f017b9 elementor-widget elementor-widget-text-editor\" data-id=\"1f017b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-8f9e177 elementor-widget elementor-widget-text-editor\" data-id=\"8f9e177\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p><img decoding=\"async\" class=\"size-full wp-image-18498\" src=\"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/performance-icone.png\" alt=\"Performance icone\" width=\"92\" height=\"51\" \/><strong>\u00a0Key management<\/strong>: also a non-mandatory parameter, it is nevertheless essential to associate keys in the semantic layer of the analytical view in the interests of performance. SAP HANA automatically creates indexes on these key fields, which is relevant given that SAP HANA does not take into account the creation of indexes on analytical views. The key fields of a table or view are those that enable a single row to be identified.<br \/>To understand this concept, we can take the example of the sales order table again, but this time at item level. Each line will be unique as soon as the order reference\/item reference pair is read: the key fields are then identified.<br \/>A view\u2019s keys are set at the semantic level:<\/p><\/div><\/div><\/div><\/div><\/div><\/div>\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-2d0e18c elementor-widget elementor-widget-image\" data-id=\"2d0e18c\" 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:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/parametrage-cles-niveau-semantique.png\" title=\"\" alt=\"Parametrage cl\u00e9s niveau semantique\" 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-d46b072 elementor-widget elementor-widget-text-editor\" data-id=\"d46b072\" 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<div class=\"elementor-element elementor-element-1f017b9 elementor-widget elementor-widget-text-editor\" data-id=\"1f017b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-8f9e177 elementor-widget elementor-widget-text-editor\" data-id=\"8f9e177\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p><img decoding=\"async\" class=\"size-full wp-image-18498\" src=\"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/performance-icone.png\" alt=\"Performance icone\" width=\"92\" height=\"51\" \/>\u00a0<strong>Correct management of record quantities<\/strong>: it is vital to correctly manage the number of rows in the construction of a view. Two views modelled differently, but with the same input and output data, may require very different quantities of resources depending on how they are constructed. The designer must bear in mind that each modelling operation must be carried out on the smallest possible number of lines. This implies a number of recommendations:<br \/>Place filters as close as possible to the tables being queried<br \/>Encapsulate the tables in a projection to filter the data immediately<br \/>Perform calculations on the smallest possible number of records: in general, in a projection close to the semantics, after filters and aggregations.<br \/>Table joins should be performed as a priority on key or indexed columns to speed up the search.<\/p><p><img decoding=\"async\" class=\"size-full wp-image-18498\" src=\"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/performance-icone.png\" alt=\"Performance icone\" width=\"92\" height=\"51\" \/>\u00a0<strong>Reuse of existing views rather than creating a model for each requirement<\/strong>. Thanks to the persistence of analytical views on SAP HANA, calculations do not need to be performed again. It is also with this in mind that SAP HANA makes available the Star Join object, which consists of making dimension views (including attributes, which are views without measurements) gravitate around a factual view. In addition to the obvious time savings at the design stage, the performance gains are immense thanks to the persistence of the views.<br \/>It is therefore advisable to build dimension views to model frequently required attributes, even if there are only fields: for example, a VAT code and its description. The use of star joins is strongly recommended by the editor.<\/p><\/div><\/div><\/div><\/div><\/div><\/div>\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-14e5018 elementor-widget elementor-widget-heading\" data-id=\"14e5018\" 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\">Performance analysis\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d73f813 elementor-widget elementor-widget-text-editor\" data-id=\"d73f813\" 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<div class=\"elementor-element elementor-element-1f017b9 elementor-widget elementor-widget-text-editor\" data-id=\"1f017b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-8f9e177 elementor-widget elementor-widget-text-editor\" data-id=\"8f9e177\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p>SAP HANA offers a diagnostic and performance analysis tool to confirm the correct management of modelled views:\u00a0<strong>PlanViz<\/strong>. To use this tool, you need to switch to the\u00a0<strong>SAP HANA PlanViz<\/strong>\u00a0perspective.<\/p><p>To analyse a view, you need to query its data using the SQL script :<\/p><\/div><\/div><\/div><\/div><\/div><\/div>\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-2859060 elementor-widget elementor-widget-image\" data-id=\"2859060\" 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:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/analyse-donnees-script-sql.png\" title=\"\" alt=\"Analyse de donn\u00e9es script SQL\" 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-4b4887f elementor-widget elementor-widget-text-editor\" data-id=\"4b4887f\" 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<div class=\"elementor-element elementor-element-1f017b9 elementor-widget elementor-widget-text-editor\" data-id=\"1f017b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-8f9e177 elementor-widget elementor-widget-text-editor\" data-id=\"8f9e177\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-fdc65bc elementor-widget elementor-widget-text-editor\" data-id=\"fdc65bc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p>From the SQL console, right-click to run the performance analyser:<\/p><\/div><\/div><\/div><div class=\"elementor-element elementor-element-74ddc0f elementor-widget elementor-widget-image\" data-id=\"74ddc0f\" data-element_type=\"widget\" data-widget_type=\"image.default\"><div class=\"elementor-widget-container\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\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-67efee5 elementor-widget elementor-widget-image\" data-id=\"67efee5\" 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:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/analyseur-de-performance-sap-hana.png\" title=\"\" alt=\"Analyseur de performance 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-8b0e3e4 elementor-widget elementor-widget-text-editor\" data-id=\"8b0e3e4\" 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<div class=\"elementor-element elementor-element-1f017b9 elementor-widget elementor-widget-text-editor\" data-id=\"1f017b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-8f9e177 elementor-widget elementor-widget-text-editor\" data-id=\"8f9e177\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-bcb495d elementor-widget elementor-widget-text-editor\" data-id=\"bcb495d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-bcb495d elementor-widget elementor-widget-text-editor\" data-id=\"bcb495d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p>Performance information is then available at a global or detailed level, since it is possible to enter each operation detail:<\/p><\/div><\/div><\/div><div class=\"elementor-element elementor-element-05ad88d elementor-widget elementor-widget-image\" data-id=\"05ad88d\" data-element_type=\"widget\" data-widget_type=\"image.default\"><div class=\"elementor-widget-container\">\u00a0<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\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-558ee49 elementor-widget elementor-widget-image\" data-id=\"558ee49\" 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:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/information-performances-sap-hana.png\" title=\"\" alt=\"Information performances 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-6cab88b elementor-widget elementor-widget-text-editor\" data-id=\"6cab88b\" 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<div class=\"elementor-element elementor-element-1f017b9 elementor-widget elementor-widget-text-editor\" data-id=\"1f017b9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-8f9e177 elementor-widget elementor-widget-text-editor\" data-id=\"8f9e177\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><div class=\"elementor-element elementor-element-bcb495d elementor-widget elementor-widget-text-editor\" data-id=\"bcb495d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\"><div class=\"elementor-widget-container\"><div class=\"elementor-text-editor elementor-clearfix\"><p>Performance information is also provided in the \u2018timeline\u2019, \u2018operator list\u2019, \u2018tables used\u2019 and \u2018performance trace\u2019 tabs.<\/p><p>Warnings about the number of records can be set in the\u00a0<a href=\"https:\/\/www.decivision.com\/blog\/sap-hana\/decouverte-de-sap-hana-studio\" target=\"_blank\" rel=\"noopener\">SAP HANA studio<\/a>\u00a0preferences (SAP HANA &gt; Modeler &gt; Performance Analysis), as can the colour codes for operations (SAP HANA &gt; PlanViz &gt; Graph &gt; Appearance):<\/p><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div>\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-dc3bbe4 elementor-widget elementor-widget-image\" data-id=\"dc3bbe4\" 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:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/configuration-apparence-avertissements.png\" title=\"\" alt=\"Configuration apparence avertissements\" 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-dd973cc elementor-widget elementor-widget-heading\" data-id=\"dd973cc\" 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\">Conclusion<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f987d6a elementor-widget elementor-widget-text-editor\" data-id=\"6f987d6a\" 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><strong>SAP HANA<\/strong>\u00a0is an ideal tool for setting up a high-performance environment capable of efficiently processing very large volumes of data. The use of analytical views as an alternative to SQL queries is highly recommended in cases where performance is weakened. Good modelling practices are essential for obtaining a more efficient model.<\/p><p>The calculations and formulas available in the analytical view modelling engine are sometimes limited; to overcome the few blocking situations, the view designer may need to use function tables; these are also high-performance, because they are persistent, and above all, can be inserted into calculation views to take advantage of the benefits of analytical view modelling.<\/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-8bc3930 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8bc3930\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\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-f1f9204\" data-id=\"f1f9204\" 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-38e7d3a elementor-widget elementor-widget-heading\" data-id=\"38e7d3a\" 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\">L\u2019avis de l\u2019expert<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a9d9010 elementor-widget elementor-widget-text-editor\" data-id=\"a9d9010\" 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><strong>SAP HANA is a high-performance, efficient data management solution<\/strong>. Its in-memory architecture and columnar storage guarantee fast processing performance. It is important to use good modelling practices: one of the key but underused modelling features on\u00a0<strong>SAP HANA<\/strong>\u00a0is Star Join, which reduces joins and improves response times. Star Join has many advantages: thanks to the persistence of analytical views, calculations are optimised and performance remains constant even with large amounts of data.<\/p><p><strong>SAP HANA<\/strong>\u00a0stands out for its ability to deliver relevant results in record time. Its innovative approach enables users to take full advantage of their data and make decisions based on better-controlled information.<\/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>Discover how to optimise SAP HANA performance using the various modelling tools designed, the analysis tools available to the user, and the many optimisation levers for exploiting SAP or external data.<\/p>\n","protected":false},"author":13,"featured_media":59361,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[574],"tags":[],"class_list":["post-18535","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Performance management on the SAP HANA Studio<\/title>\n<meta name=\"description\" content=\"Discover how to optimise SAP HANA performance using the various modelling tools we&#039;ve designed!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Performance management in the SAP HANA Studio\" \/>\n<meta property=\"og:description\" content=\"Discover how to optimise SAP HANA performance using the various modelling tools we&#039;ve designed!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio\" \/>\n<meta property=\"og:site_name\" content=\"Rapid Views\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RapidViews.io\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-02T14:35:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-27T13:25:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2025\/03\/performance-management-sap-hana-studio-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"750\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Alexis REMY\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rapidviews_io\" \/>\n<meta name=\"twitter:site\" content=\"@rapidviews_io\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alexis REMY\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio\"},\"author\":{\"name\":\"Alexis REMY\",\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/#\\\/schema\\\/person\\\/b147e0c8874c5427bd76abf9fcad0fd9\"},\"headline\":\"Performance management in the SAP HANA Studio\",\"datePublished\":\"2023-06-02T14:35:14+00:00\",\"dateModified\":\"2025-03-27T13:25:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio\"},\"wordCount\":1355,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rapidviews.io\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/gestion-de-performance-sap-hana-studio.png\",\"articleSection\":[\"SAP HANA\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio\",\"url\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio\",\"name\":\"Performance management on the SAP HANA Studio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rapidviews.io\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/gestion-de-performance-sap-hana-studio.png\",\"datePublished\":\"2023-06-02T14:35:14+00:00\",\"dateModified\":\"2025-03-27T13:25:16+00:00\",\"description\":\"Discover how to optimise SAP HANA performance using the various modelling tools we've designed!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio#primaryimage\",\"url\":\"https:\\\/\\\/www.rapidviews.io\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/gestion-de-performance-sap-hana-studio.png\",\"contentUrl\":\"https:\\\/\\\/www.rapidviews.io\\\/wp-content\\\/uploads\\\/2023\\\/06\\\/gestion-de-performance-sap-hana-studio.png\",\"width\":1200,\"height\":750,\"caption\":\"Performance management in SAP HANA Studio, providing tools and methodologies to optimize resource and data management.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/sap-hana\\\/performance-management-sap-hana-studio#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rapidviews.io\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAP HANA\",\"item\":\"https:\\\/\\\/www.rapidviews.io\\\/blog\\\/category\\\/sap-hana\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Performance management in the SAP HANA Studio\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/\",\"name\":\"Rapid Views\",\"description\":\"R\u00e9volutionnez les Analytics avec les solutions RapidViews\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/#organization\"},\"alternateName\":\"Rapid Views\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/#organization\",\"name\":\"Rapid Views\",\"alternateName\":\"RapidViews\",\"url\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rapidviews.io\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/rapidviews-image.png\",\"contentUrl\":\"https:\\\/\\\/www.rapidviews.io\\\/wp-content\\\/uploads\\\/2025\\\/12\\\/rapidviews-image.png\",\"width\":1200,\"height\":675,\"caption\":\"Rapid Views\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RapidViews.io\\\/\",\"https:\\\/\\\/x.com\\\/rapidviews_io\",\"https:\\\/\\\/mastodon.social\\\/@RapidViews\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCe7zv2EXmw0rMsSATm9NVCg\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/rapid-views\",\"http:\\\/\\\/instagram.com\\\/rapidviews_io\\\/\"],\"description\":\"Rapid Views est un \u00e9diteur de logiciels dans le domaine de la Business Intelligence.\",\"email\":\"contact@rapidviews.io\",\"telephone\":\"05 54 54 20 06\",\"legalName\":\"Rapid Views\",\"foundingDate\":\"2020-01-01\",\"taxID\":\"880 873 278 00019\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/#\\\/schema\\\/person\\\/b147e0c8874c5427bd76abf9fcad0fd9\",\"name\":\"Alexis REMY\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/961d961c57cb95aaaeaff2435193c536d6696c9c7cb00bf4a4ef85952a6fdb0a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/961d961c57cb95aaaeaff2435193c536d6696c9c7cb00bf4a4ef85952a6fdb0a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/961d961c57cb95aaaeaff2435193c536d6696c9c7cb00bf4a4ef85952a6fdb0a?s=96&d=mm&r=g\",\"caption\":\"Alexis REMY\"},\"sameAs\":[\"https:\\\/\\\/www.rapidviews.io\"],\"url\":\"https:\\\/\\\/www.rapidviews.io\\\/en\\\/blog\\\/author\\\/alexis-remy\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Performance management on the SAP HANA Studio","description":"Discover how to optimise SAP HANA performance using the various modelling tools we've designed!","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:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio","og_locale":"en_US","og_type":"article","og_title":"Performance management in the SAP HANA Studio","og_description":"Discover how to optimise SAP HANA performance using the various modelling tools we've designed!","og_url":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio","og_site_name":"Rapid Views","article_publisher":"https:\/\/www.facebook.com\/RapidViews.io\/","article_published_time":"2023-06-02T14:35:14+00:00","article_modified_time":"2025-03-27T13:25:16+00:00","og_image":[{"width":1200,"height":750,"url":"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2025\/03\/performance-management-sap-hana-studio-1.png","type":"image\/png"}],"author":"Alexis REMY","twitter_card":"summary_large_image","twitter_creator":"@rapidviews_io","twitter_site":"@rapidviews_io","twitter_misc":{"Written by":"Alexis REMY","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio#article","isPartOf":{"@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio"},"author":{"name":"Alexis REMY","@id":"https:\/\/www.rapidviews.io\/en\/#\/schema\/person\/b147e0c8874c5427bd76abf9fcad0fd9"},"headline":"Performance management in the SAP HANA Studio","datePublished":"2023-06-02T14:35:14+00:00","dateModified":"2025-03-27T13:25:16+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio"},"wordCount":1355,"publisher":{"@id":"https:\/\/www.rapidviews.io\/en\/#organization"},"image":{"@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio#primaryimage"},"thumbnailUrl":"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/gestion-de-performance-sap-hana-studio.png","articleSection":["SAP HANA"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio","url":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio","name":"Performance management on the SAP HANA Studio","isPartOf":{"@id":"https:\/\/www.rapidviews.io\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio#primaryimage"},"image":{"@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio#primaryimage"},"thumbnailUrl":"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/gestion-de-performance-sap-hana-studio.png","datePublished":"2023-06-02T14:35:14+00:00","dateModified":"2025-03-27T13:25:16+00:00","description":"Discover how to optimise SAP HANA performance using the various modelling tools we've designed!","breadcrumb":{"@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio#primaryimage","url":"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/gestion-de-performance-sap-hana-studio.png","contentUrl":"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2023\/06\/gestion-de-performance-sap-hana-studio.png","width":1200,"height":750,"caption":"Performance management in SAP HANA Studio, providing tools and methodologies to optimize resource and data management."},{"@type":"BreadcrumbList","@id":"https:\/\/www.rapidviews.io\/en\/blog\/sap-hana\/performance-management-sap-hana-studio#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rapidviews.io\/"},{"@type":"ListItem","position":2,"name":"SAP HANA","item":"https:\/\/www.rapidviews.io\/blog\/category\/sap-hana"},{"@type":"ListItem","position":3,"name":"Performance management in the SAP HANA Studio"}]},{"@type":"WebSite","@id":"https:\/\/www.rapidviews.io\/en\/#website","url":"https:\/\/www.rapidviews.io\/en\/","name":"Rapid Views","description":"R\u00e9volutionnez les Analytics avec les solutions RapidViews","publisher":{"@id":"https:\/\/www.rapidviews.io\/en\/#organization"},"alternateName":"Rapid Views","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rapidviews.io\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rapidviews.io\/en\/#organization","name":"Rapid Views","alternateName":"RapidViews","url":"https:\/\/www.rapidviews.io\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rapidviews.io\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2025\/12\/rapidviews-image.png","contentUrl":"https:\/\/www.rapidviews.io\/wp-content\/uploads\/2025\/12\/rapidviews-image.png","width":1200,"height":675,"caption":"Rapid Views"},"image":{"@id":"https:\/\/www.rapidviews.io\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RapidViews.io\/","https:\/\/x.com\/rapidviews_io","https:\/\/mastodon.social\/@RapidViews","https:\/\/www.youtube.com\/channel\/UCe7zv2EXmw0rMsSATm9NVCg","https:\/\/www.linkedin.com\/company\/rapid-views","http:\/\/instagram.com\/rapidviews_io\/"],"description":"Rapid Views est un \u00e9diteur de logiciels dans le domaine de la Business Intelligence.","email":"contact@rapidviews.io","telephone":"05 54 54 20 06","legalName":"Rapid Views","foundingDate":"2020-01-01","taxID":"880 873 278 00019","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rapidviews.io\/en\/#\/schema\/person\/b147e0c8874c5427bd76abf9fcad0fd9","name":"Alexis REMY","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/961d961c57cb95aaaeaff2435193c536d6696c9c7cb00bf4a4ef85952a6fdb0a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/961d961c57cb95aaaeaff2435193c536d6696c9c7cb00bf4a4ef85952a6fdb0a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/961d961c57cb95aaaeaff2435193c536d6696c9c7cb00bf4a4ef85952a6fdb0a?s=96&d=mm&r=g","caption":"Alexis REMY"},"sameAs":["https:\/\/www.rapidviews.io"],"url":"https:\/\/www.rapidviews.io\/en\/blog\/author\/alexis-remy"}]}},"_links":{"self":[{"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/18535","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/comments?post=18535"}],"version-history":[{"count":13,"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/18535\/revisions"}],"predecessor-version":[{"id":57732,"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/18535\/revisions\/57732"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/media\/59361"}],"wp:attachment":[{"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/media?parent=18535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/categories?post=18535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rapidviews.io\/en\/wp-json\/wp\/v2\/tags?post=18535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}