SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Topic Index
+
-
SAP HANA Overview
+
-
SAP HANA Architecture
+
-
SAP HANA Studio
+
-
Reporting in HANA
+
-
SAP HANA Text analysis
+
-
SAP BW on HANA
+
-
Miscellaneous
+
-
SAPUI5

Reporting in HANA: Overview

Once the modeling view (attribute view, analytic view and calculation view) is created in SAP HANA, you can see the output in HANA Studio.
Finally it will be non-technical end users (for example manager, sales executive, board members etc.) who will consume the modeling views to visualize different business scenarios.
Asking a non-technical user to use HANA Studio is not really practical. You also would not want to put the modeling software in the hands of all your users.

That's why we need separate reporting tools which can connect to SAP HANA, take the data from modeling views and show in a nice, easy to understand format.


Currently there are number of tools/applications which can be used for reporting in SAP HANA. SAP suggests using frontends of the SAP Business Objects BI Suite. Recommended frontend tools include SAP Business Objects Crystal Reports, Analysis Office, and Explorer.

Reporting on SAP HANA can be done in most of SAP' Business Objects BI Suite of applications, or in tools which can create and consume MDX queries and data.

Microsoft Excel can also be used for reporting on SAP HANA.
You can use Excel to connect to SAP HANA, access the modeling views and slice and dice the data to create meaningful reports.
Check Build Reports in Excel using SAP HANA Data

Note: You can think of SAP Business Objects BI Suite as a collection of different front-end tools provided by SAP. Most important of them are
  • SAP BusinessObjects Analysis
  • SAP BusinessObjects Explorer
  • SAP Lumira
  • SAP Business Objects Crystal Reports
  • SAP BusinessObjects Dashboards


Reporting on SAP HANA - Clients and Connectivity Options:

SAP HANA supports different connectivity options such as MDX, SQL, BICS etc. It provides JDBC and ODBC drivers which are standardized programming interfaces to access relational databases.

Below image shows the different connectivity options supported for frontend tools and SAP HANA.


    • ODBO - OLE DB for OLAP
        • Microsoft-driven specification for multidimensional (MDX) reporting
        • Requests are sent to the database via MDX (MultiDimensional eXpression language)
    • ODBC - Open DataBase Connectivity
        • Microsoft-driven specification for relational reporting
        • Database requests are made via SQL (Structured Query Language)
        • Heavily adopted in industry
        • No longer Microsoft-centric - Unix and Linux drivers exist
    • JDBC - Java DataBase Connectivity
        • Relational reporting drivers specified by the Java community. Popular on Unix platforms.
    • BICS - BI Consumer Services
        • SAP Proprietary interface that offers advantages for OLAP access over MDX on multidimensional reporting objects
        • Common driver technology used by SAP BusinessObjects Analysis, Office Edition for connectivity to SAP NetWeaver BW
    • SQLDBC is SAP native database SDK



Support us by sharing this article.



Explore More
Close X
Close X

4 thoughts on “Reporting on SAP HANA

  1. Sherry Todd-Green says:

    How can Hana Live reporting tools benefit the following roles? Please give a brief, easy to explain, real-life type examples for each role:

    1. CEO/Manager
    2. Data Cruncher/Analyst
    3. Operational Manager

    • Harish says:

      Well, HANA Live is not reporting tool, if you’ve SAP BW background there we’ve something called business content its set/bunch of pre-delivered objects which are in delivered version just by activating objects you can start using in your data-flows.

      Regards,
      Harish

  2. kapil says:

    Hi ,

    I am having 6 Years Experience in SAP ABAP as core developer and wants to go with SAP HANA.
    can you please suggest me the best way to start in SAP HANA as developer .

    • Admin says:

      Hello,

      If you are a fresher in SAP HANA, you may follow the url mentioned below to know about “Where to start ?” , “How to start? “, “Is it well demanding?”, “Can I learn SAP HANA?” and find the courses offered at free of cost.
      http://saphanatutorial.com/want-to-learn-sap-hana-where-to-start/

      We always recommend to start with the SAP HANA basic course which covers the fundamental concepts and overview.
      The course could be access by browsing the following url. It’s open to all, just browse through it.
      http://saphanatutorial.com/sap-hana-basic-course-1-1/

      [Note : We don’t offer any classroom based face-to-face or online one-to-one training services.]

      For any query including technical issues, email us at “admin@saphanatutorial.com”.

      Thanks,
      Admin

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy