760 likes | 855 Views
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.
E N D
Session ID: BI-206HANA and DataServicesDEMO 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 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.
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.
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
PSA Log files Aggregates Stats cubes Compression Delete old infoproviders Cleaning Up your BW System
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
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
Clean install vs. Migration of BW system Team for Install Team for Testing Deploying BusinessObjects Moving forward with BI-Self Service The Work
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) .
Opening HANA Admin Demo Overview
Adding New System in HANA Demo Overview
Adding New System in HANA Demo Overview
Creating HANA system connection Demo Overview
Setup HANA Security Authentication Demo Overview
Changing a HANA password Demo Overview
Creating HANA Security questions Demo Overview
Creating HANA Security questions Demo Overview
Your HANA System in the Navigator Demo Overview
Searching for a table in HANA Demo Overview
The table definition inside HANA Demo Overview
All HANA tables Demo Overview
Open a HANA table Demo Overview
Browsing data in a HANA table Demo Overview
Opening HANA Admin Demo Overview
HANA memory usage Demo Overview
Opening a new HANA perspective Demo Overview
Opening HANA Modeler Demo Overview
The HANA Modeler Demo Overview
Opening HANA Attribute views Demo Overview
Opening HANA Attribute views Demo Overview
Customer & Sales Attribute View Demo Overview
Creating a New HANA Table Demo Overview
Creating a New HANA Table Demo Overview
Creating a New Products HANA Table Demo Overview
Defining a new Sales HANA table Demo Overview
Accessing Data Services to Load data to HANA Demo Overview
Accessing Data Services to Load data to HANA Demo Overview
Linking Data Services to HANA datastores Demo Overview
Linking Data Services to HANA datastores Demo Overview
Linking Data Services to HANA datastores Demo Overview
Our new Data Services HANA repository Demo Overview
Data Services HANA repository objects Demo Overview
Importing HANA table definitions Demo Overview
Importing HANA Customer table definition Demo Overview
Importing HANA Sales table definition Demo Overview
Linking data files to load to HANA Demo Overview
Linking data files to load to HANA Demo Overview
Defining file format for loading data to HANA Demo Overview
Defining data file format for HANA data load Demo Overview