{"id":54211,"date":"2019-05-11T11:41:56","date_gmt":"2019-05-11T06:11:56","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=54211"},"modified":"2021-12-04T13:09:55","modified_gmt":"2021-12-04T07:39:55","slug":"connect-dashboard-designer-to-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/","title":{"rendered":"Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards"},"content":{"rendered":"

This tutorial will focus on learning the process to connect Dashboard Designer to SAP HANA. Dashboard Designer connects to the SAP HANA database through a relational connection and an intermediate data layer known as Universe<\/strong>.<\/p>\n

We will provide you with some easy steps to create dashboards using Dashboard Designer.<\/p>\n

Let’s look have a look at the Dashboard Designer concept.<\/p>\n

What is Dashboard Designer?<\/h3>\n

Dashboard designer is a tool for designing dashboards. It provides users with pre-designed dashboard templates which can be utilized in creating static or dynamic charts and visualizations as a part of the dashboard. Dashboard designer also connects to data sources via universes.<\/p>\n

The universes are created using IDT tool. In the next section of this tutorial, we will learn how to use data from SAP HANA available as universes in Dashboard designer to create dashboards.<\/p>\n

Connection to the Universe layer from Dashboard Designer<\/h3>\n

Firstly, we will see the steps to connect Dashboard Designer to SAP HANA.<\/p>\n

Steps to Connect dashboard designer to SAP HANA<\/h4>\n

In this section, we will learn how to create an OLAP connection to connect Dashboard designer to SAP HANA.<\/p>\n

Step 1:<\/strong> Open the Dashboard Designer<\/strong> tool in your system.<\/p>\n

Step 2:<\/strong> From the left panel, select the Query Browser<\/strong> and click on Add Query<\/strong> option.<\/p>\n

Step 3: Log On to BusinessObjects Enterprise<\/strong><\/p>\n

The next dialog box asks us for login details<\/strong> to login into the BO repository.<\/strong><\/p>\n

Enter login details such as System name, User name, Password, Authentication<\/strong>.<\/p>\n

You can also select the authentical mode from the drop-down list. The options in the list are Enterprise, LDAP, Oracle EBS, SAP, Windows AD,<\/em> etc. Then, click on OK.<\/strong><\/p>\n

Step 4: Add Query<\/strong><\/p>\n

After connecting to the SAP HANA system via a Universe layer, select Universe<\/strong> as the data source option in the next window. The other option available is Bex but it is of no use as of now. Click on Next<\/strong>.<\/p>\n

Step 5: Select a Universe<\/strong><\/p>\n

Next will appear the list of universes<\/strong> available in the selected BO repository. Expand the Universes folder and select your preferred universe from the list and click Next<\/strong>.<\/p>\n

Step 6: Build Query<\/strong><\/p>\n

In the next window, you will see all the measures and dimensions from the universe you selected on the left panel.<\/p>\n

Select the measures and dimensions you want and add them to the Result Objects<\/strong> section. Click on the Refresh<\/strong> button in the Data Preview<\/strong> section (bottom-most section with the name Result Set). This will show a data preview table having all the fields you selected. Click on Next<\/strong>.<\/p>\n

Step 7: Preview Query Result<\/strong><\/p>\n

The next window will also show you a full view of the table of the query result. From here you can set up the number of maximum rows<\/strong> that you can see at once. Click on Next.<\/strong><\/p>\n

Step 8: Usage options<\/strong><\/p>\n

The last window is the Usage Option<\/strong> dialog where you set some usage related options such as the name of the query<\/strong>.<\/p>\n

Refreshing options<\/em> such as,<\/p>\n

    \n
  • Refresh Before Components Are Loaded<\/li>\n
  • Refresh Every (set time)<\/li>\n
  • Refresh on Trigger (set trigger options)<\/li>\n<\/ul>\n

    Load status options<\/em> such as,<\/p>\n

      \n
    • Loading Message<\/li>\n
    • Idle Message<\/li>\n
    • Insert In<\/li>\n
    • Enable Load Cursor<\/li>\n
    • Disable Mouse Input on Load<\/li>\n
    • Hide Error Message Window<\/li>\n<\/ul>\n

      Click on Ok<\/strong> once you have made changes as per your liking.<\/p>\n

      Step 9:<\/strong> You can view the newly created query in the Query Browser.\u00a0<\/strong>The details on the newly created query (i.e. a universe to connect to SAP HANA) are shown on the left pane of the Dashboard designer window.<\/p>\n

      Steps to Create dashboards through SAP Dashboard Designer<\/h4>\n

      You can create dashboards using the connection created with SAP HANA in dashboard designer. Let us learn how to develop a dashboard in Dashboard Designer using the HANA query we created in the section above.<\/p>\n

      Step 1:<\/strong> We can find our query<\/strong> on the Query Browser.<\/strong><\/p>\n

      Enter the fields into the spreadsheet by clicking on the field name and then clicking on Insert in Spreadsheet.<\/strong><\/p>\n

      Step 2:<\/strong> Next, to add the visual components into the dashboard, click on the Components<\/strong> tab (on the leftmost vertical bar). You can select from the given options of visual components<\/strong> like the pie chart, line chart, etc. Just drag and drop the component to the blank space on the screen.<\/p>\n

      Step 3:<\/strong> Let’s suppose that we have added a pie chart component to visualize the data from the universe. You can do some manipulations in the settings<\/strong> tab (given on the right).\u00a0 There are four tabs for pie chart settings; General, Insertion, Behaviour, Appearance.<\/p>\n

      In the General<\/strong> tab, you can enter the pie chart title, subtitle, data values, data in row<\/em> or data in columns, labels<\/em> and set the Inner Radius<\/em>.<\/p>\n

      From the Insertion<\/strong> tab, you can manipulate data insertion operations, interaction options, selection actions, and appearance settings.<\/em><\/p>\n

      You can apply sorting conditions, dynamic visibility,<\/em> etc from the Behavior<\/strong> tab.<\/p>\n

      The formatting like layout, color, text, series <\/em>of the chart is done from the Appearance<\/strong> tab.<\/p>\n

      Step 4:<\/strong> After making desired changes in the chart, click on the Preview<\/strong> button on the top bar.<\/p>\n

      The preview of the pie chart we created will be displayed on the blank space.<\/p>\n

      Step 5:<\/strong> Similarly, you can create the dashboard using a wide range of options like charts, containers, selectors, maps, text,<\/em> etc.<\/p>\n

      Summary<\/h3>\n

      This concludes our tutorial on the process to connect Dashboard Designer to SAP HANA. We learned how to use data from SAP HANA through an intermediate layer called Universe.<\/p>\n

      We hope you found the explanation helpful. Drop your comments in the comment section below if you have any suggestions or queries.<\/p>\n","protected":false},"excerpt":{"rendered":"

      This tutorial will focus on learning the process to connect Dashboard Designer to SAP HANA. Dashboard Designer connects to the SAP HANA database through a relational connection and an intermediate data layer known as...<\/p>\n","protected":false},"author":6,"featured_media":54251,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19521,19522],"class_list":["post-54211","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-connect-dashboard-designer-to-sap-hana","tag-create-dashboards-by-dashboard-designer"],"yoast_head":"\nConnect Dashboard Designer to SAP HANA & Create Stunning Dashboards - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn the process to connect Dashboard Designer to SAP HANA and create dashboards using the OLAP connection and HANA query. Why to wait? Explore now!\" \/>\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\/connect-dashboard-designer-to-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn the process to connect Dashboard Designer to SAP HANA and create dashboards using the OLAP connection and HANA query. Why to wait? Explore now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-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-11T06:11:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-04T07:39:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/How-to-Connect-Dashboard-Designer-to-SAP-HANA-Create-Dashboards.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards - DataFlair","description":"Learn the process to connect Dashboard Designer to SAP HANA and create dashboards using the OLAP connection and HANA query. Why to wait? Explore now!","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\/connect-dashboard-designer-to-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards - DataFlair","og_description":"Learn the process to connect Dashboard Designer to SAP HANA and create dashboards using the OLAP connection and HANA query. Why to wait? Explore now!","og_url":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-05-11T06:11:56+00:00","article_modified_time":"2021-12-04T07:39:55+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/How-to-Connect-Dashboard-Designer-to-SAP-HANA-Create-Dashboards.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards","datePublished":"2019-05-11T06:11:56+00:00","dateModified":"2021-12-04T07:39:55+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/"},"wordCount":930,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/How-to-Connect-Dashboard-Designer-to-SAP-HANA-Create-Dashboards.jpg","keywords":["Connect Dashboard designer to SAP HANA","Create Dashboards by Dashboard Designer"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/","name":"Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/How-to-Connect-Dashboard-Designer-to-SAP-HANA-Create-Dashboards.jpg","datePublished":"2019-05-11T06:11:56+00:00","dateModified":"2021-12-04T07:39:55+00:00","description":"Learn the process to connect Dashboard Designer to SAP HANA and create dashboards using the OLAP connection and HANA query. Why to wait? Explore now!","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/How-to-Connect-Dashboard-Designer-to-SAP-HANA-Create-Dashboards.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/How-to-Connect-Dashboard-Designer-to-SAP-HANA-Create-Dashboards.jpg","width":1200,"height":628,"caption":"How to Connect Dashboard Designer to SAP HANA & Create Dashboards"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/connect-dashboard-designer-to-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":"Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards"}]},{"@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\/54211","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=54211"}],"version-history":[{"count":11,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/54211\/revisions"}],"predecessor-version":[{"id":104916,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/54211\/revisions\/104916"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/54251"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=54211"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=54211"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=54211"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}