session id bi 206 hana and dataservices demo and overview n.
Download
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

Loading in 2 Seconds...

play fullscreen
1 / 76

Session ID: BI-206 HANA and DataServices DEMO and Overview - PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on

Session ID: BI-206 HANA and DataServices DEMO and Overview. Dr. Bjarne Berg . Looking Inside SAP HANA — In-Memory Computing Engine (IMCE). AAAA. Persistence Layer. Disk Storage. Data Volumes. Page Mgmt. Session Manager. L ogger. Log Volumes. Replication Server. Load Controller.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

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


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - 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