{"id":54254,"date":"2019-05-16T17:20:17","date_gmt":"2019-05-16T11:50:17","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=54254"},"modified":"2021-12-04T13:08:37","modified_gmt":"2021-12-04T07:38:37","slug":"create-universe-in-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/","title":{"rendered":"How to Create Universe in SAP HANA using Information Design Tool in 10 Mins"},"content":{"rendered":"<p>Now, we are going to learn about the universes in SAP HANA. In previous tutorials of <strong>reporting in SAP HANA<\/strong>, we have come across the term <em>\u201cUniverse\u201d<\/em> many times.<\/p>\n<p>You must be wondering, what exactly is Universe? And why is it needed by reporting tools? We will answer all the questions and guide you to create a universe in SAP HANA using the Information Design Tool (IDT).<\/p>\n<h3>What is BusinessObjects Universe?<\/h3>\n<p>From earlier tutorials, we know that there are two ways in which the reporting tools can connect to SAP HANA. One way is a <strong>direct OLAP connection<\/strong> and another is an <strong>indirect relational connection<\/strong>.<\/p>\n<p>In the relational connection type, reporting tools fetch data from a universe layer instead of connecting directly to SAP HANA. Thus, SAP BusinessObjects Universe acts like a middle layer between reporting tools and SAP HANA.<\/p>\n<p>A universe contains data foundation layer which holds data tables with joins and conditions applied to them (much like information views). Business Reporting tools such as WebI, Crystal Reports for Enterprise and Dashboard designer use Universe as an intermediate layer to connect to SAP HANA.<\/p>\n<p>Although, in the current versions of Web Intelligence (WebI), the provision of connecting directly to SAP HANA has been introduced.<\/p>\n<h3>Benefits of Creating a Universe in SAP HANA<\/h3>\n<p>By using the universe layer to use data from SAP HANA, the user benefits in many ways:<\/p>\n<ul>\n<li>Offers higher output customization for business users.<\/li>\n<li>Can use query time prompts and variables.<\/li>\n<li>Data integration of data from HANA with data from other data sources by the virtue of embedded multisource technology.<\/li>\n<li>Enables data modeling in the Information Design Tool.<\/li>\n<\/ul>\n<h3>Steps to Create a Universe in SAP HANA using IDT<\/h3>\n<p>Follow the steps given in this section to learn how to create a universe in the Information Design Tool (IDT) of SAP HANA.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-56287\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1.jpg\" alt=\"Steps to Create Universe in SAP HANA\" width=\"802\" height=\"420\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1.jpg 802w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1-520x272.jpg 520w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/a><\/p>\n<h4>1. Connecting to SAP HANA<\/h4>\n<p>We\u2019ll have to create a new project before we start with making a universe.<\/p>\n<p><strong>Step 1.<\/strong>\u00a0On the <em>Information Design Tool<\/em> page, go to <strong>File<\/strong> and click on <strong>New<\/strong> and then click on <strong>Project<\/strong>.<\/p>\n<p><strong>Step 2.<\/strong> Name the project (<strong>Project Name<\/strong>), suppose we name it <em>Dtf_Demo_Connection<\/em>. Then, click on <strong>Finish<\/strong>. All the resources required for universe development will store under this project.\u00a0You can also change the location of this file from the <strong>Project Location<\/strong> column.<\/p>\n<p>Next, we need to establish a connection with SAP HANA. You can either make a relational connection (connecting to tables) or an OLAP connection (connecting to views). We have selected a relational connection.<\/p>\n<p><strong>Step 3.<\/strong> To create a relational connection, right-click on the name of your project &gt; <strong>New<\/strong> &gt; <strong>Relational Connection<\/strong>.<\/p>\n<p><strong>Step 4.<\/strong> Name the connection (<strong>Resource Name<\/strong>) and add a <strong>Description<\/strong> if you like. Click on <strong>Next&gt;<\/strong>.<\/p>\n<p><strong>Step 5.<\/strong> Select the HANA specific driver\u00a0from the <strong>Database Middleware Driver Selection<\/strong> dialog box. Click on <strong>Next&gt;<\/strong> to continue.<\/p>\n<p><strong>Parameters for SAP HANA Database Connection<\/strong><\/p>\n<p><strong>Step 6.<\/strong> Enter the connection details like<em> Authentication Mode, User Name, Password, Host Name, Instance Number,<\/em> etc. Click on <strong>Next<\/strong>.<\/p>\n<p><strong>Step 7.<\/strong> You can manipulate more connection settings in the next window such as <em>Connection Pool Mode, Pool Timeout, Array Fetch Size, Array Bind Size, Login Timeout, JDBC Driver Properties<\/em>. Then, click on <strong>Finish<\/strong>.<\/p>\n<p>Thus, the connection to SAP HANA will be successfully made. You can click on Test Connection to confirm the connection.<\/p>\n<h4>2. Creating the Data Foundation<\/h4>\n<p>To create a universe, we need to start with making a data foundation. The main universe is created here as we get to define tables, create joins and associations between tables, apply filter conditions, etc.<\/p>\n<p><strong>Step 8.<\/strong> In the Information Design Tool, right-click on the name of your connection (<em>Dtf_Demo_Connection<\/em>) and select <strong>New Data Foundation<\/strong>.<\/p>\n<p><strong>Step 9.<\/strong> Name the data foundation (Resource Name). For the sake of understanding, we will name the data foundation <em>\u201cDtf_Demo_DF\u201d<\/em>. Then click <strong>Finish<\/strong>.<\/p>\n<p><strong>Step 10.<\/strong> Now, you get to see all the tables that exist in the HANA database under the <strong>Connection<\/strong> tab on IDT. You can select a node and expand it to see the tables within it.<\/p>\n<p>To add tables into the universe, drag and drop the tables in the <strong>Master<\/strong> area on the right.<\/p>\n<p>Join two tables by pulling the cursor between two fields of the tables that you wish to join.<\/p>\n<p><strong>Step 11.<\/strong> You can edit the join properties by double-clicking on the join. You can set the join condition, create a shortcut join, outer join for the left or right table, view the expression and cardinality of the join.<\/p>\n<p><strong>Step 12.<\/strong> Click on the save icons on the bar (on IDT main page) to save the newly created data foundation.<\/p>\n<h4>3. Creating a Business Layer<\/h4>\n<p>Next step is to create a business layer on top of the data foundation we built.<\/p>\n<p><strong>Step 13.<\/strong> Right-click on the name of the data foundation (<em>Dtf_Demo_DF<\/em> in our case) and select<strong> New Business Layer<\/strong>.<\/p>\n<p><strong>Step 14.<\/strong> Then enter the name of the business layer. For instance, we give the name<em> \u201cDtf_Demo_BL\u201d<\/em>. Click on <strong>Finish<\/strong>.<\/p>\n<p>This will fetch all the classes and objects based upon the tables we selected in the data foundation (in the <strong>Business Layer<\/strong> section). You can select an object and view the <em>Name, Description, Field Type, Data Type, SQL Definition, Keys, Advanced Operations, Source Information,<\/em> etc and edit them.<\/p>\n<p>You can also manipulate the SQL script using <strong>SQL assistant<\/strong>.<\/p>\n<p>This way our business layer is ready.<\/p>\n<p><strong>Step 15.<\/strong> Now, before we save our business layer to BO repository, we need to secure our connection by publishing it on the repository.<\/p>\n<p>To publish the connection, right-click on the connection name (<em>Dtf_Demo_Connection.cnx<\/em>) and select <strong>Publish connection to a repository<\/strong>.<\/p>\n<p>Then, click on <strong>Finish<\/strong>.<\/p>\n<p>This will create a secure .cns (<em>Dtf_Demo_Connection.cns<\/em>) connection.<\/p>\n<p><strong>Step 16.<\/strong> Next, we\u2019ll change the connection of data foundation to the secure .cns connection.<\/p>\n<p><strong>Step 17.<\/strong> Now, finally, we will publish our business layer to a repository. To do this, right-click on the name of your business layer (<em>Dtf_Demo_BL<\/em>) then select <strong>Publish<\/strong> and then click on <strong>To a Repository<\/strong>.<\/p>\n<p>You can check the integrity as you like. Click <strong>Next&gt;<\/strong>.<\/p>\n<p><strong>Step 18.<\/strong> Select the folder in which you want to store it. Click on <strong>Finish<\/strong> and your universe is published successfully.<\/p>\n<h3>Summary<\/h3>\n<p>This concludes our lesson on SAP Business Objects Universes. Here we learned the basics of the universe and how to create a universe in IDT using data from SAP HANA.<\/p>\n<p>We hope you found the explanation helpful. In case of any queries or suggestion drop your comments in the comment section below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Now, we are going to learn about the universes in SAP HANA. In previous tutorials of reporting in SAP HANA, we have come across the term \u201cUniverse\u201d many times. You must be wondering, what&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":56287,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19731,19732,19733],"class_list":["post-54254","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-create-universe-in-sap-hana","tag-sap-businessobjects-universe","tag-sap-hana-universe-creation-benefits"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Create Universe in SAP HANA using Information Design Tool in 10 Mins - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn the process to create universe in SAP HANA using information design tool through a relational connection and universe creation benefits. 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\/create-universe-in-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create Universe in SAP HANA using Information Design Tool in 10 Mins - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn the process to create universe in SAP HANA using information design tool through a relational connection and universe creation benefits. Explore now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/create-universe-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-16T11:50:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-04T07:38:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1.jpg\" \/>\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\/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":"How to Create Universe in SAP HANA using Information Design Tool in 10 Mins - DataFlair","description":"Learn the process to create universe in SAP HANA using information design tool through a relational connection and universe creation benefits. 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\/create-universe-in-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"How to Create Universe in SAP HANA using Information Design Tool in 10 Mins - DataFlair","og_description":"Learn the process to create universe in SAP HANA using information design tool through a relational connection and universe creation benefits. Explore now!","og_url":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-05-16T11:50:17+00:00","article_modified_time":"2021-12-04T07:38:37+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1.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\/create-universe-in-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"How to Create Universe in SAP HANA using Information Design Tool in 10 Mins","datePublished":"2019-05-16T11:50:17+00:00","dateModified":"2021-12-04T07:38:37+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/"},"wordCount":1096,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1.jpg","keywords":["Create Universe in SAP HANA","SAP BusinessObjects Universe","SAP HANA Universe Creation Benefits"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/","name":"How to Create Universe in SAP HANA using Information Design Tool in 10 Mins - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1.jpg","datePublished":"2019-05-16T11:50:17+00:00","dateModified":"2021-12-04T07:38:37+00:00","description":"Learn the process to create universe in SAP HANA using information design tool through a relational connection and universe creation benefits. Explore now!","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/create-universe-in-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/05\/Steps-to-Create-Universe-in-SAP-HANA-1.jpg","width":802,"height":420,"caption":"Steps to Create Universe in SAP HANA"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/create-universe-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":"How to Create Universe in SAP HANA using Information Design Tool in 10 Mins"}]},{"@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\/54254","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=54254"}],"version-history":[{"count":14,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/54254\/revisions"}],"predecessor-version":[{"id":104911,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/54254\/revisions\/104911"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/56287"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=54254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=54254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=54254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}