Download
session id bi 206 hana and dataservices demo and overview n.
Skip this Video
Loading SlideShow in 5 Seconds..
Session ID: BI-206 HANA and DataServices DEMO and Overview PowerPoint Presentation
Download Presentation
Session ID: BI-206 HANA and DataServices DEMO and Overview

Session ID: BI-206 HANA and DataServices DEMO and Overview

82 Vues Download Presentation
Télécharger la présentation

Session ID: BI-206 HANA and DataServices DEMO and Overview

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Session ID: BI-206HANA and DataServicesDEMO and Overview Dr. Bjarne Berg

  2. Looking Inside SAP HANA — In-Memory Computing Engine (IMCE) AAAA Persistence Layer Disk Storage Data Volumes Page Mgmt. Session Manager Logger Log Volumes Replication Server Load Controller Relational Engine -Row Store -Column Store Metadata Manager MDX SQL Parser Authorization Manager SQL Script Transaction Manager Calculation Engine BusinessObjects Data Services Inside the Computing Engine of SAP HANA we have many different components that manage the access and storage of the data. This include MDX and SQL access, as well as Load Controller (LC) and the Replication Server.

  3. SAP HANA — Sizing the Application A lot depends on actual compression rates, but here are some first stab quick “rule-of-thumb’ for size estimation • Working memory • RAM = (Source Data Footprint / 5) * 2 • SSD (Disk) • Disk persistence = 4 * RAM • Disk log = 1 * RAM • CPU: • 0.2 CPU cores / active user To do accurate sizing you should contact your service partner and the hardware vendor you are working with and plan to spend some time getting the numbers right.

  4. Decoder ‘Ring’ SAP BW & HANA - Terminology BWHANA Characteristics - Attributes Dimensions - Attribute Views Key Figures - Measures Virtual Provider - Calculation Views (sort of) InfoCubes - Analytic Views Security Object - Analytical Privileges Flat ‘leveled hierarchies’ – Several attributes Basic hierarchies - Normal parent-child relationships

  5. PSA Log files Aggregates Stats cubes Compression Delete old infoproviders Cleaning Up your BW System

  6. The vendors that provide SAP HANA solutions include Cisco, Dell, IBM, Intel, HP, and Fujitsu as of Jan 2012 SAP HANA generally consists of: The database and database clients HANA studio (P2 repository) Load controller and Sybase replication server The host agent and LM structure files Op. Sys. configuration, SAPCAR & SAP JVM The update manager for SAP HANA SAP HANA — Vendors and Appliance Options Fujitsu IBM System x3950 X5 Dell R910 HP DL 580 G7 Cisco UCS C460 M2

  7. Normal duration is 6-12 weeks depending on size and number of environments. Key decisions are: How many DSOs and InfoCubes to convert Risk avoidance and testing requirements High-availability requirements Size of system(s) Conversions requirements (using SLT, LC and data services) Migration Vs. Clean install Moving BW to HANA

  8. Clean install vs. Migration of BW system Team for Install Team for Testing Deploying BusinessObjects Moving forward with BI-Self Service The Work

  9. SAP HANA — Loading the Application and Performance You can load the application based on the logs in the source system, ETL-based (Extract Transform and Load) loads, and SAP trigger-based replication ToolPurpose BusinessObjects Data Services 4.0 – ETL-based replication Sybase replication server &Load Controller – Log-based replication SAP Landscape Transformation (LT) – Trigger-based replication Log based replication is possible on IBM DB 2 LUW/UDB and planned for MSFT SQL Server Enterprise Edition, Oracle Enterprise Edition, and Sybase ASE (as of Dec. 2011) .

  10. Demo Overview

  11. Opening HANA Admin Demo Overview

  12. Adding New System in HANA Demo Overview

  13. Adding New System in HANA Demo Overview

  14. Creating HANA system connection Demo Overview

  15. Setup HANA Security Authentication Demo Overview

  16. Changing a HANA password Demo Overview

  17. Creating HANA Security questions Demo Overview

  18. Creating HANA Security questions Demo Overview

  19. Your HANA System in the Navigator Demo Overview

  20. Searching for a table in HANA Demo Overview

  21. The table definition inside HANA Demo Overview

  22. All HANA tables Demo Overview

  23. Open a HANA table Demo Overview

  24. Browsing data in a HANA table Demo Overview

  25. Opening HANA Admin Demo Overview

  26. HANA memory usage Demo Overview

  27. Opening a new HANA perspective Demo Overview

  28. Opening HANA Modeler Demo Overview

  29. The HANA Modeler Demo Overview

  30. Opening HANA Attribute views Demo Overview

  31. Opening HANA Attribute views Demo Overview

  32. Customer & Sales Attribute View Demo Overview

  33. Creating a New HANA Table Demo Overview

  34. Creating a New HANA Table Demo Overview

  35. Creating a New Products HANA Table Demo Overview

  36. Defining a new Sales HANA table Demo Overview

  37. Accessing Data Services to Load data to HANA Demo Overview

  38. Accessing Data Services to Load data to HANA Demo Overview

  39. Linking Data Services to HANA datastores Demo Overview

  40. Linking Data Services to HANA datastores Demo Overview

  41. Linking Data Services to HANA datastores Demo Overview

  42. Our new Data Services HANA repository Demo Overview

  43. Data Services HANA repository objects Demo Overview

  44. Importing HANA table definitions Demo Overview

  45. Importing HANA Customer table definition Demo Overview

  46. Importing HANA Sales table definition Demo Overview

  47. Linking data files to load to HANA Demo Overview

  48. Linking data files to load to HANA Demo Overview

  49. Defining file format for loading data to HANA Demo Overview

  50. Defining data file format for HANA data load Demo Overview