1 / 59

Session 4: The HANA Curriculum and Demos

Session 4: The HANA Curriculum and Demos. Dr. Bjarne Berg Associate professor Computer Science Lenoir-Rhyne University. Introduction.

thelma
Download Presentation

Session 4: The HANA Curriculum and Demos

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Session 4: The HANA Curriculum and Demos Dr. Bjarne Berg Associate professor Computer Science Lenoir-Rhyne University

  2. Introduction This last session is more technical as we explore what ETL options HANA has, what applications exists and review some core exercises students in the SAP University Alliance completes as part of their curriculum. We also see demos of BO Explorer on SAP HANA and a demo of the new BusinessObjects BI 4.1 tool suite and integrated BI environment on-top of HANA We end with an overview of where you can get more information about HANA and have a quick round with questions and answers.

  3. Session Agenda • Introduction • HANA Overview • SAP University Alliance: Student Exercise and Demo: BO Explorer on HANA • Overview of Extract, Transform and Load (ETL) into HANA • SAP University Alliance: Student Exercise – Step-by-Step • Demo: BI 4.1 (new) on HANA • Where to Find More Information • Questions and Answers

  4. HANA – The Detailed Architecture

  5. Modeling in SAP HANA

  6. HANA Applications Overview and Discussion

  7. Views in SAP HANA Attribute views • Represent master data (attributes,texts, hierarchies) • Provide reusable dimensions for analytic and calculation views Analytic views • Join facts with relevant attribute dimensions Calculation views • Address more complexrequirements than analytic views • Can include both tables and views

  8. Session Agenda • Introduction • HANA Overview • SAP University Alliance: Student Exercise and Demo: BO Explorer on HANA • Overview of Extract, Transform and Load (ETL) into HANA • SAP University Alliance: Student Exercise – Step-by-Step • Demo: BI 4.1 (new) on HANA • Where to Find More Information • Questions and Answers

  9. Exercise #1 Using SAP HANA and BO Explorer In this first exercise, the students access SAP HANA through an Information Space

  10. Some of the Different BusinessObjects BI tools that can access HANA

  11. BO Explorer on SAP HANA

  12. BO Explorer on HANA Demo

  13. Session Agenda • Introduction • HANA Overview • SAP University Alliance: Student Exercise and Demo: BO Explorer on HANA • Overview of Extract, Transform and Load (ETL) into HANA • SAP University Alliance: Student Exercise – Step-by-Step • Demo: BI 4.1 (new) on HANA • Where to Find More Information • Questions and Answers

  14. Data Provisioning

  15. Trigger Based Replication SAP LT Replication Server Source System SAP HANA DBconnection RFCconnection SAP LT Replication Server • Trigger-based concept that only considers the tables relevant for data replication • Allows real-time (and scheduled) data replication from SAP ERP Systems and non-SAP systems (SAP supported databases only) into HANA • Based on the SLO (System Landscape Optimization) technology

  16. ETL Based replication with DataServices

  17. DataServices – The work environment

  18. Data flows Vs. Workflows Source Target Data flows • Extract, transform and load data (ETL process) • Determines the flow of data – from the source to the target • Similar to SAP BW transformations with data source and data target Workflows • Optional objects • Organize data flows • Define the decision-making process to execute data flows and organizes data flows • Similar to SAP BW process chains for automation of complex schedules

  19. Definitions and Metadata Datastores: • Provide the logical connection to a database (must be specified for each source and target database) • Are used to import metadata for source and target databases • Are used to read data from source tables and load data to target tables Metadata includes: • Database tables: Table name, Column names, Column data types, Primary key columns, Table attributes • RDBMS functions • Application-specific data structures Connection metadata is defined in the object library as Datastores(for tables) and file formats (for flat files)

  20. Importing Metadata from HANA Table‘s metadata Import datastore tables Import the metadata of the database tables (e.g. master data and transaction data tables), which should be populated at the end of the ETL process Examples: • Customer attributes table (master data) • Sales data table (transaction data)

  21. Creating a Dataflow

  22. Query mapping and transformations The query transform enables you to select data from a source, filter or reformat the data and move it to the target You need to create a relationship between the input and output schemas for the data to move from the source to the target

  23. BW ETL Vs. DataServices ETL with HANA

  24. Session Agenda • Introduction • HANA Overview • SAP University Alliance: Student Exercise and Demo: BO Explorer on HANA • Overview of Extract, Transform and Load (ETL) into HANA • SAP University Alliance: Student Exercise – Step-by-Step • Demo: BI 4.1 (new) on HANA • Where to Find More Information • Questions and Answers

  25. Student Case Study Example In this HANA case study, the students load data to SAP HANA Then they create attribute and analytical views Finally, they deploy it to BO Explorer

  26. Creating a new Datastores in BOBJ DataServices

  27. Importing table definition

  28. Result

  29. Linking to Flat file

  30. Defining flat file

  31. Result Student’s do the same for Products and sales flat files

  32. Creating a Project and adding Dataflow

  33. Linking to flat file and make it a source

  34. Mapping flat file Source to Target table in HANA

  35. Executing the job and Monitoring Progress

  36. Result inside HANA viewed using HANA Studio

  37. Creating an Attribute View

  38. Adding table joins to more Customer Information

  39. Applying a Filter to an Attribute View

  40. Deciding what Users Should See and assign Key Attribute

  41. Validate and Activate a View

  42. Creating an Analytical View

  43. Data Foundations and Logical Joins

  44. Adding a Calculated Field to an Analytical View

  45. Multi-Currency Handling

  46. The Resulting Analytical View

  47. Deploying Analytical View in BO Explorer

  48. Building an Information Space

  49. The Result in BO Explorer

  50. Session Agenda • Introduction • HANA Overview • SAP University Alliance: Student Exercise and Demo: BO Explorer on HANA • Overview of Extract, Transform and Load (ETL) into HANA • SAP University Alliance: Student Exercise – Step-by-Step • Demo: BI 4.1 (new) on HANA • Where to Find More Information • Questions and Answers

More Related