{"id":53892,"date":"2019-05-17T15:03:38","date_gmt":"2019-05-17T09:33:38","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=53892"},"modified":"2021-12-04T13:08:11","modified_gmt":"2021-12-04T07:38:11","slug":"create-olap-connection-in-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/","title":{"rendered":"Steps to Create OLAP Connection in SAP HANA – You can’t Afford to Miss Out!"},"content":{"rendered":"

After understanding the relational connection in SAP HANA<\/strong>, we will learn about creating OLAP connections in SAP HANA. First, we will understand what is OLAP connection and then learn the process of\u00a0creating a new OLAP connection in SAP HANA.<\/p>\n

Let’s begin with the tutorial.<\/p>\n

OLAP Connection in SAP HANA<\/h3>\n

The OLAP connection connects the user directly to the SAP HANA business layer to fetch data tables and information views for reporting. The business users from various reporting tools can establish a direct connection to the SAP HANA system and access data views and models instantly.<\/p>\n

Reporting tools in SAP HANA such as SAP Lumira, SAP Design Studio, Business Explorer, Crystal reports, Analysis for OLAP use OLAP connection to connect to SAP HANA. As OLAP connections are direct connections, there is no need for creating an\u00a0intermediate universe layer.<\/p>\n

How to Create an OLAP connection in SAP HANA?<\/h3>\n

In this tutorial, we will learn to create an OLAP connection in SAP HANA using the Information Design Tool (IDT)<\/strong> interface.<\/p>\n

\"Steps<\/a><\/p>\n

Given below are the steps for establishing an OLAP connection:<\/p>\n

Step 1:<\/strong> Initiating a new connection<\/strong><\/p>\n

Right-click on the project name. Click on New<\/strong>, then select OLAP Connection<\/strong>.<\/p>\n

Step 2: Naming your OLAP connection<\/strong><\/p>\n

Then, enter a name for the connection in Resource Name<\/strong> column. You can also add a description for the connection in the Description<\/strong> box. Click Next>\u00a0<\/strong>to continue.<\/p>\n

Step 3: Selecting the connection driver<\/strong><\/p>\n

Select the connection driver as SAP HANA Client\u00a0<\/strong>from the list of OLAP drivers. You can also select whether you want the list to be Hierarchical list or a flat list. After that, click Next>. <\/strong><\/p>\n

Step 4: Entering connection parameters<\/strong><\/p>\n

Enter the parameters for the connection. You can select the Authentication mode<\/strong> from three options.<\/p>\n

    \n
  1. Specified user name and password<\/li>\n
  2. Business Objects credential mapping<\/li>\n
  3. Single Sign-On<\/li>\n<\/ol>\n

    Other columns that you have to fill are are Hostname, Instance Number, User Name, Password, Language, Auto Reconnect, Use SSL and Fetch Size. Then, click Next>.<\/strong><\/p>\n

    Step 5: Specifying a cube<\/strong><\/p>\n

    You can point at a specific cube to which you want to connect directly, or you can select the \u201cDo not specify a cube in the connection\u201d<\/strong> option.<\/p>\n

    Select a database cube from the list given below if you are specifying a cube in the connection. Click on Finish<\/strong> once you have made the selection.<\/b><\/p>\n

    Step 6: Confirming the connection<\/strong><\/p>\n

    An OLAP connection with extension\u00a0.cnx<\/strong> will be created.\u00a0You can see the name of the connection in the Local Project tab under your project name. To confirm a successful connection, you can click on Test Connection<\/strong>. A “Test Successful”<\/strong> message will appear.<\/p>\n

    Step 7: Check the Connection details<\/strong><\/p>\n

    You can also see the connection details on the General Information<\/strong> tab.\u00a0It will show information regarding the connection such as:<\/p>\n

      \n
    • Network layer value<\/li>\n
    • Database name<\/li>\n
    • Catalog<\/li>\n
    • Cube<\/li>\n
    • Authentication mode<\/li>\n
    • Hostname<\/li>\n
    • Instance Number<\/li>\n
    • User Name<\/li>\n
    • Password<\/li>\n
    • Language<\/li>\n
    • Auto-Reconnect<\/li>\n
    • Use SSL<\/li>\n
    • Fetch size<\/li>\n<\/ul>\n

      Step 8: Publishing the connection<\/strong><\/p>\n

      Now, we can publish this connection on the BO repository so that users from different reporting tools can use this connection later. To publish a connection, right-click on the connection name from the Local Projects<\/strong> tab and select Publish Connection to a Repository.<\/strong><\/p>\n

      Step 9: Selecting the repository<\/strong><\/p>\n

      The system will select the session with our connection automatically. If you wish to make any changes, you can edit it.<\/p>\n

      Select the repository<\/strong> from the list of connections in the next dialog box.\u00a0 Then click on Finish<\/strong> to complete the process.<\/p>\n

      Step 10: Confirming connection publishing<\/strong><\/p>\n

      Then, a prompt will appear saying “The connection was published successfully”, confirming successful publishing of connection into the selected repository.<\/p>\n

      You can select the secured OLAP connection stored with\u00a0.cns extension to fetch data tables and information views.<\/p>\n

      Summary<\/h3>\n

      This concludes our tutorial on OLAP connection in SAP HANA. Here, we learned how to create an OLAP connection using the Information Design Tool. We hope the explanation was helpful.<\/p>\n

      In the upcoming tutorials, we will learn about the connections of different reporting tools with SAP HANA.<\/p>\n

      Have any queries related to OLAP Connection in SAP HANA? Feel free to ask in the comments section.<\/p>\n","protected":false},"excerpt":{"rendered":"

      After understanding the relational connection in SAP HANA, we will learn about creating OLAP connections in SAP HANA. First, we will understand what is OLAP connection and then learn the process of\u00a0creating a new...<\/p>\n","protected":false},"author":6,"featured_media":56315,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19477,19476],"class_list":["post-53892","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-create-olap-connection","tag-olap-connection-in-sap-hana"],"yoast_head":"\nSteps to Create OLAP Connection in SAP HANA - You can't Afford to Miss Out! - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn about OLAP Connection in SAP HANA and steps to create OLAP connection to SAP HANA database using Information Design Tool. An Effortless Process!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Steps to Create OLAP Connection in SAP HANA - You can't Afford to Miss Out! - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn about OLAP Connection in SAP HANA and steps to create OLAP connection to SAP HANA database using Information Design Tool. An Effortless Process!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-17T09:33:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-04T07:38:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-OLAP-Connection-in-SAP-HANA-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Steps to Create OLAP Connection in SAP HANA - You can't Afford to Miss Out! - DataFlair","description":"Learn about OLAP Connection in SAP HANA and steps to create OLAP connection to SAP HANA database using Information Design Tool. An Effortless Process!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"Steps to Create OLAP Connection in SAP HANA - You can't Afford to Miss Out! - DataFlair","og_description":"Learn about OLAP Connection in SAP HANA and steps to create OLAP connection to SAP HANA database using Information Design Tool. An Effortless Process!","og_url":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-05-17T09:33:38+00:00","article_modified_time":"2021-12-04T07:38:11+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-OLAP-Connection-in-SAP-HANA-1.png","type":"image\/png"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Steps to Create OLAP Connection in SAP HANA – You can’t Afford to Miss Out!","datePublished":"2019-05-17T09:33:38+00:00","dateModified":"2021-12-04T07:38:11+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/"},"wordCount":699,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-OLAP-Connection-in-SAP-HANA-1.png","keywords":["Create OLAP Connection","OLAP Connection in SAP HANA"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/","name":"Steps to Create OLAP Connection in SAP HANA - You can't Afford to Miss Out! - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-OLAP-Connection-in-SAP-HANA-1.png","datePublished":"2019-05-17T09:33:38+00:00","dateModified":"2021-12-04T07:38:11+00:00","description":"Learn about OLAP Connection in SAP HANA and steps to create OLAP connection to SAP HANA database using Information Design Tool. An Effortless Process!","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-OLAP-Connection-in-SAP-HANA-1.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Steps-to-Create-OLAP-Connection-in-SAP-HANA-1.png","width":802,"height":420,"caption":"Steps to Create OLAP Connection in SAP HANA"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/create-olap-connection-in-sap-hana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"Steps to Create OLAP Connection in SAP HANA – You can’t Afford to Miss Out!"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53892","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=53892"}],"version-history":[{"count":19,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53892\/revisions"}],"predecessor-version":[{"id":104909,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53892\/revisions\/104909"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/56315"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=53892"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=53892"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=53892"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}