{"id":53750,"date":"2019-04-17T11:26:13","date_gmt":"2019-04-17T05:56:13","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=53750"},"modified":"2021-12-05T21:30:12","modified_gmt":"2021-12-05T16:00:12","slug":"reporting-in-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/","title":{"rendered":"Reporting in SAP HANA &#8211; Learn 3 Major Layers of Reporting Framework"},"content":{"rendered":"<p>Now after learning about data extraction, data designing, and <strong>modeling in SAP HANA,<\/strong>\u00a0we will further move on to learn about reporting in SAP HANA.<\/p>\n<p>It means how the data models and information views are used by the end-users and analysts to analyze data and create reports. We have provided a comprehensive tutorial on how reporting is done in SAP HANA.<\/p>\n<h3>Introduction to SAP HANA Reporting<\/h3>\n<p><strong>SAP HANA is an efficient in-memory database<\/strong>\u00a0technology which provides its users with platforms to model and design data as per their business requirements.<\/p>\n<p>As an extension to the data extraction and modeling capabilities, <em>SAP HANA reporting tools serve as an essential platform to present the information in proper ways<\/em>.<\/p>\n<p>The reports created by the reporting tools using processed data from SAP HANA are used by business analysts, business managers, sales managers, and senior managers.<\/p>\n<p>The report enables the people in authority to draw meaningful insights and identify market trends to make strategies and bolster their business in the present as well as for the future.<\/p>\n<p>SAP HANA enables different kinds of reporting tools such as <strong>SAP Lumira, Design Studio, Analysis Office, Crystal Reports, Dashboards, Explorer, Web intelligence<\/strong> and even third-party apps like<strong> MS Excel<\/strong>. Users can use both historical as well as real-time data to create reports.<\/p>\n<h3>Connecting to the Reporting Sources<\/h3>\n<p>SAP HANA users or the users at the reporting end of the setup can\u00a0establish a connection to the other end in two ways:<\/p>\n<ul>\n<li><strong>First<\/strong> is the direct way where reporting tools can connect directly to the SAP HANA database. This direct connection is an OLAP type connection. The tools which connect directly to the SAP HANA system are Design Studio, SAP Lumira, Business Explorer, Analysis of MS Office, Crystal Reports, etc.<\/li>\n<li>The <strong>second<\/strong> way is an indirect way of connection. It is a relational connection that establishes by creating a universe using the<strong> Information Design Tool (IDT).<\/strong> The tools using this method of connection to connect to the SAP HANA database are Web intelligence tools, SAP Dashboards, Crystal reports for the enterprise.<\/li>\n<\/ul>\n<h3>Layers in Reporting Framework<\/h3>\n<p>The reporting framework is easy to understand when we divide it into three primary layers;<\/p>\n<ol>\n<li>Interaction languages<\/li>\n<li>Connecting drivers<\/li>\n<li>Reporting tools<\/li>\n<\/ol>\n<p>At the base of these three layers is the <em>core SAP HANA system database<\/em>.\u00a0 From there, users can fetch data to use it in the reporting tools. Let us learn about reporting architecture by understanding each layer in detail.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/SAP-HANA-Reporting-Framework-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-54535\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/SAP-HANA-Reporting-Framework-1.jpg\" alt=\"SAP HANA Reporting Framework\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/SAP-HANA-Reporting-Framework-1.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/SAP-HANA-Reporting-Framework-1-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/SAP-HANA-Reporting-Framework-1-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/SAP-HANA-Reporting-Framework-1-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/SAP-HANA-Reporting-Framework-1-1024x536.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/SAP-HANA-Reporting-Framework-1-520x272.jpg 520w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><\/p>\n<h4>1. Interaction Languages<\/h4>\n<p>This layer consists of all the query languages which are used in querying database tables and objects from the reporting tools during report execution. The languages used for this purpose in SAP HANA reporting are MDX, <strong>SQL<\/strong>, and SQL ODBC.<\/p>\n<ul>\n<li><strong>MDX:<\/strong> MDX language is <em>used to access multi-dimensional data objects<\/em> instead of relational objects from the SAP HANA database. <em>MDX stands for <\/em><strong>MultiDimensional Expressions<\/strong>. This language is used to query data from MS Excel in SAP HANA reporting. It is the only language that enables hierarchy accessing from SAP HANA system.<\/li>\n<li><strong>SQL:<\/strong> SQL is a <em>standard database language for accessing data from all kinds of platforms<\/em>. In SAP HANA reporting, all the reporting tools, which connect data through ODBC and JDBC connections use SQL as the query language.<\/li>\n<li><strong>SQL ODBC:<\/strong> The SQL ODBC connection accesses data from the reporting tools that connect to the SAP HANA system using a BICS connection. BICS stands for <strong>Business Intelligence Consumer Services<\/strong>.<\/li>\n<\/ul>\n<h4>2. Connecting Drivers<\/h4>\n<p>The connecting drivers act as a mediator between the SAP HANA database layer and the reporting tools. The drivers transport the language queries from the reporting tool to the database and take back the data.<\/p>\n<p>Every reporting tool connects to the database through a specific connecting driver. SAP HANA uses four main types of drivers as discussed below:<\/p>\n<ul>\n<li><strong>ODBO (OLE DB for OLAP):<\/strong> The ODBO driver is a driver by Microsoft for connecting MS Excel to the SAP HANA database. This driver is specifically for multi-dimensional reporting (multi-dimensional data stores), and it communicates through MDX language.<\/li>\n<li><strong>ODBC:<\/strong> The ODBC driver establishes relational database connections between reporting tools and SAP HANA database. Reporting tools like CR Report and Universe layer (IDE) use ODBC driver that communicates via SQL. ODBC stands for <strong>Open DataBase Connectivity<\/strong>.<\/li>\n<li><strong>JDBC:\u00a0<\/strong>JDBC stands for <strong>Java DataBase Connectivity<\/strong>. JDBC driver is a Java-based connection service. We also use it for relational reporting by tools like Explorer, UNIX using IDT, CR Report. JDBC drivers communicate with the database through SQL queries.<\/li>\n<li><strong>BICS:<\/strong> The BICS driver is SAP propriety connecting driver, which is used by those reporting tools that use SQLDB language as the interaction language with SAP database.<\/li>\n<\/ul>\n<h4>3. Reporting Tools<\/h4>\n<p>The topmost layer is the layer of reporting tools. It is the SAP Business Objects BI (4.0\/4.2\/4.3) reporting platform which serves several reporting applications. The business users analyze data and create reports to generate meaningful insights using these applications.<\/p>\n<p>The SAP BO platform consists of reporting applications such as <strong>SAP Lumira, Web Intelligence, SAP BO Explorer, SAP BO Dashboards, Crystal Reports, and SAP BO Universe.<\/strong><\/p>\n<h3>Summary<\/h3>\n<p>This tutorial focuses on the basics of reporting and the reporting architecture in\u00a0<strong>SAP HANA<\/strong>. In the upcoming tutorial, we will talk about the different reporting tools which are a part of the SAP Business Object BI client tools.<\/p>\n<p>So, are you clear with the concept of SAP HANA Reporting? If you have any queries, feel free to enter in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Now after learning about data extraction, data designing, and modeling in SAP HANA,\u00a0we will further move on to learn about reporting in SAP HANA. It means how the data models and information views are&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":54532,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19457,19456,19458],"class_list":["post-53750","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-reporting-framework-layers","tag-reporting-in-sap-hana","tag-sap-hana-reporting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Reporting in SAP HANA - Learn 3 Major Layers of Reporting Framework - DataFlair<\/title>\n<meta name=\"description\" content=\"Reporting in SAP HANA covers the process of connecting to reporting sources and three layers; interaction languages, connecting drivers &amp; reporting tools.\" \/>\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\/reporting-in-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Reporting in SAP HANA - Learn 3 Major Layers of Reporting Framework - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Reporting in SAP HANA covers the process of connecting to reporting sources and three layers; interaction languages, connecting drivers &amp; reporting tools.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/reporting-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-04-17T05:56:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-05T16:00:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Layers-in-Reporting-Framework-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"268\" \/>\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":"Reporting in SAP HANA - Learn 3 Major Layers of Reporting Framework - DataFlair","description":"Reporting in SAP HANA covers the process of connecting to reporting sources and three layers; interaction languages, connecting drivers & reporting tools.","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\/reporting-in-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"Reporting in SAP HANA - Learn 3 Major Layers of Reporting Framework - DataFlair","og_description":"Reporting in SAP HANA covers the process of connecting to reporting sources and three layers; interaction languages, connecting drivers & reporting tools.","og_url":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-04-17T05:56:13+00:00","article_modified_time":"2021-12-05T16:00:12+00:00","og_image":[{"width":512,"height":268,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Layers-in-Reporting-Framework-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\/reporting-in-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Reporting in SAP HANA &#8211; Learn 3 Major Layers of Reporting Framework","datePublished":"2019-04-17T05:56:13+00:00","dateModified":"2021-12-05T16:00:12+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/"},"wordCount":908,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Layers-in-Reporting-Framework-1.jpg","keywords":["Reporting Framework Layers","Reporting in SAP HANA","SAP HANA Reporting"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/","name":"Reporting in SAP HANA - Learn 3 Major Layers of Reporting Framework - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Layers-in-Reporting-Framework-1.jpg","datePublished":"2019-04-17T05:56:13+00:00","dateModified":"2021-12-05T16:00:12+00:00","description":"Reporting in SAP HANA covers the process of connecting to reporting sources and three layers; interaction languages, connecting drivers & reporting tools.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/reporting-in-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Layers-in-Reporting-Framework-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/04\/Layers-in-Reporting-Framework-1.jpg","width":512,"height":268,"caption":"Layers in SAP HANA Reporting Framework"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/reporting-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":"Reporting in SAP HANA &#8211; Learn 3 Major Layers of Reporting Framework"}]},{"@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\/53750","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=53750"}],"version-history":[{"count":23,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53750\/revisions"}],"predecessor-version":[{"id":105065,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53750\/revisions\/105065"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/54532"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=53750"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=53750"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=53750"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}