Tuesday, January 10, 2017

HA 200 unit 5 Architecture and Scenarios

• Identify the components for memory management and persistence in the SAP HANA database architecture

Daemon- Starts all other processes and keeps them running
• Index server- The main database process- Data loads, queries, calculations, and so on- Provides the embedded statistics service• Name server- Knows DB Landscape- Knows data distribution
• Preprocessor- Feeds unstructured data (for example, text documents) into SAP HANA
• Compile Server- Performs the compilation of stored procedures and programs
• XS-Engine- Web service component, sometimes termed “application server”
• SAP Web Dispatcher- Entry point for HTTP(s) requests
• SAP start service- Responsible for starting and stopping the other services

statistics service:
·         collects and evaluates information about status, performance, and resource consumption from all components belonging to the system
internal monitoring infrastructure
·         monitor the status of the system and its services and consumption of system resources
Statistics server
·         The statistics server runs as a separate server process. It is an enhanced index server with a monitoring extension on top.
Statistics service
·         The statistics service does not run as a separate server process (statisticsserver). It is implemented as an embedded service in the master index server

External Interfaces
·         SQL, MDX, and Web interfaces allow clients to connect and communicate with the SAP HANA database
Request Processing / Execution Control
·         Depending on the interface and the statement different components for processing can be invoked, for example, SQL Script implementations are executed within the so-called Calculation Engine.

Relational Engines
·         The table data in SAP HANA is kept in two different relational stores:
·         Row Store and Column Store
·         Each of these stores shows substantial differences with regard to the main memory management
Storage Engine and Disk Storage
·         achieve consistency and persist changes durably
·         a Storage Engine with Page Management and Logger is used. This ensures that the database can be restored to the most recent committed state after a restart and that transactions are either completely executed or completely undone.
·         Disk Storage is divided in Data Volumes and Log Volumes.
·         changes need to be written to the log area before a successful commit of a transaction (synchronous writing)
·         the data area contains the complete main memory content at a specific point in time and is written asynchronously.

Persistence

Data:
·         SQL data and undo log information
·         Additional HANA information, such as modeling data
·         Kept in-memory to ensure max performance
·         Write process is asynchronously
Log:
·         Information about data changes (redo log)
·         Directly saved to persistent storage when transaction is committed
·         Cyclical overwrite (only after backup)
Savepoint:
·         Changed data and undo log is written from memory to persistent storage
·         Automatic
·         At least every 5 minutes (customizable)

·         Data changes such as insert, delete, and update are saved on disk immediately in the logs (synchronously). This is required to make a transaction durable. It is not necessary to persist the complete data, but the transaction log can be used to replay changes after a crash or database restart.
·         In customizable intervals (standard: every five minutes) a new savepoint is created, that is, all of the pages that were changed are refreshed in the data area of the persistence.


• Describe the SAP HANA memory usage and allocation behavior


Data Volumes
·         Located in file systems
·         Growing until disk or LUN is full
·         Logical volume Manager: needed on OS level to extend the file system
·         Growing with number of data volumes
·         PageSizes (4kb, 16k, … 16MB) which are arranged in superblocks of 64MB

Ext3:
·         Limitation is 2TB
SAP HANA:
·         Automatically creates additional files if existing files in a data volume located in an ext3 file system reach the 2 TB limit
·         Allows usage of ext3 file system with larger memory implementation per host (especially ERP single host systems)
·          No implication to backup, recovery, and so on.
·         Monitoring:SELECT * FROM PUBLIC.M VOLUME FILES

Shadow Paging Concept
·         write operations write to new physical pages and the previous savepoint version is still kept in shadow pages
·         if a system crashes during a savepoint operation, it can still be restored from the last savepoint.

Savepoint Phases:
·         Very short
·         Acquire lock to prevent modification of pages
·         Determine log position
·         Remember open transactions
·         Copy modified pages and trigger write
·         Increase savepoint version
·         Release lock

Redo (log) entries
·         Written synchronously
·         Changed data in data volume is periodically copied to disk in a savepoint operation
Savepoint operation:
·         Db flush all changed data from memory to the data volumes
Data in savepoint
·         represents a consistent state of the data on disk and remains so until the next savepoint operation has been completed
Savepoint triggers:
·         databackup, db shutdown/restart

 In-memory computing is secure
·         SAP database holds the bulk of its data in memory for maximum performance, but still uses persistent storage to provide a fallback in case of failure. The log is capturing all changes by database transactions (redo logs)
·         Data and undo log information (part of data) are automatically saved to disk at regular savepoints
·         The log is also saved to disk continuously and synchronously after each COMMIT of a database transaction (waiting for end of disk write operation).
·         After a power failure, the database can be restarted like a disk-based database:- System is normally restarted (“lazy” reloading of tables to keep the restart time short)- System returns to its last consistent state (by replaying the redo log since the last savepoint
·         allows restoring the database to the last committed state.






Friday, January 6, 2017

HA100 Excel

Excel

******************************

Understand how MS Excel can query SAP HANA using an ODBO connection

Create a pivot tbl in MS excel using a Calculation View

BZN I.E.
Successfully deployed info models in SAP HANA Studio. You now want to see how these can be used from an end user perspective.
EXCEL not a typical client tool used, provides a simple/practical way for a modeler to troubleshoot how created information models will work for the end user.

**************************************


Understand how MS Excel Can Query SAP HANA using an ODBO connection?
MDX Reporting is available via Excel Pivot tables
  • Advantages
    • quick and dirty cross-tab style reporting via Excel
  • Disadvantage
    • report definition available locally
    • performance limitations of the desktop
  • Reporting on SAP HANA -Native Excel -pivot tbls(ODBO)
    • ODBO driver is available via the advanced option of the data connection wizard
  • Standard MS Pivot tbl interface
    • checks measures, drag and drop rows/columns

Create a pivot table using a Calculation View


Excel Pivot Tbls(ODBO/MDX Access

  1. Initiate the Excel data connection wizard
    1. Data Ribbon --> other Sources --> Data Connection Wizard
  2. Select other/advanced drivers then click Next
  3. SAP HANA MDX provider  -->next
  4. Connection Tab --> Test Connection
    1. Host, Instance Number, User, PW, Language
  5. Choose a pkg --> cube(analytic or calculation view)
    1. Select pck, select calc view, next
  6. Connect/save
  7. Accept the pivot tbl report properties -->connect
  8. Empty pivot tbl, 
    1. List of fields available in the PivotTable Field List

SAP Replication Server H100

Replication Server:  log based database replication tool.

Replication Server Benefits:
List supported primary and replicate RDBMS:
Describe the Architecture of SAP Replication Server:
Understand how to connect SAP Replication Server with an SAP HANA system:

Replication Server Benefits:

SAP Sybase Replication Server:  sophisticated transaction data movement product that moves and synchronizes data across the enterprise

It does this by non-intrusively handling data at the source and target


  • Log-based replication process
    • non-intrusive
    • very high performance
  • improve recovery, resumption times and minimize downtime
    • bi-directional replication

Thursday, January 5, 2017

Unit 3 Lesson 1: H200: SAP HANA Lifecycle Management Tools

Unit 2: H200: System concepts

Unit 2: Lesson 2


*****************************************************************************
OVERVIEW: This lesson describes the Linux operating system requirements that have to be fulfilled before you can start the installation of an SAP HANA system. This lesson does not replace the “SAP HANA Server Installation and Update Guide" for SPS11 and the SAP HANA installation SAP Notes.

******************************************************************************
USE CASE:
*****Linux OS requirements before installing SAP HANA*****

*********************************************************************************

1)      Explain the SAP HANA system concepts and system types
2)      Clarify the SAP HANA system concepts and system types
3)      Explain the required file system structure and directories and their recommended sizes

1)      Explain the SAP HANA system concepts and system types

·         Single-Host System
·         system is running entirely on one host and the server needs to handle the full query load




·         Multi-Host System (More than one host)
·         Can be configured as active worker hosts or idle standby hosts
·         Means load can be balanced between different hosts.




2)      Clarify the SAP HANA system concepts and system types


A)      Host
a.       hardware and operating environment in which the SAP HANA database runs
                                                               i.      resources and services
1.       CPU, Memory, Network, and storage
b.       supported on:
                                                               i.      SUSE Linux Enterprise Server
                                                             ii.      Red Hat Enterprise Server
c.       storage for an installation does not have to be on the host
                                                               i.      can be in shared storage
d.       for multi-host SAP HANA systems
                                                               i.      shared storage or storage that is accessible on-demand from all hosts is required
B)      System
a.       One or more instances with the same SAP system ID and instance number
b.       System = SAP HANA database
c.       If SAP HANA system has more than one instance
                                                               i.      Distributed over several host
d.       SAP system ID
                                                               i.      Identifier for the SAP HANA system
C)      Instance
a.       set of SAP HANA system components that are installed on one host
b.       system can be distributed as several instances among several hosts, but each instance in a multi-host system must have the same instance number.

3)      Explain the required file system structure and directories and their recommended sizes

Standalone SAP HANA System with Single-SID and Multiple-SID installations
Hardware Rqrmts:
·         20GB Ram in total for software
·         15 GB for the basic software
·         5 GB for programs
·         Space for trace files
·         Addt’l storage for data and log volumes varies

SAP HANA NETWORK CONNECTION RQRMTS:
·         Dedicated server network communication of 10GBits/s between the SAP HANA landscape and the source system for efficient data replication

Important Directories and their Sizes:

PIC





·         SAP HANA system in a production environment must not share any infrastructure with another SAP HANA system
·         Hosts running more than one SAP HANA system (sometimes referred to as multi-SID installations) can only be used for
·         Non-production purposes:
·         Development
·         QA
·         Testing


·         production systems with high availability
·         possible to share some temporarily unused resources from the standby hosts.
·         as the standby resources are needed, they must become exclusively available for the production system and are no longer shared


Tuesday, January 3, 2017

Interview Questions

https://www.pinterest.com/saphanacentral/interview-qa/

https://www.pinterest.com/saphanacentral/

http://career.guru99.com/top-50-sql-question-answers/


http://www.w3schools.com/sql/

http://career.guru99.com/top-50-sql-question-answers/

H100 Lumira

Lumira

=Lumira Server:  Explore data: share with teammates
=Lumira Cloud:  Acquire data -> Build visualization -> explore the data -> and share with your teammates


=Lumira Desktop: Acquire data -> Enrich Data -> Build Visualizations -> Explore data -> Share with teammates


Acquire: 
-data from Excel, CSV, HANA, SQL, and BI universes (SAP BW BEx connectivity planned)
-Stored in columnar store for lightning fast experience
-Merge/Append datasets


Enrich:
-Combine multiple sources without scripting
-Cleanse, add calculations, custom groupings, etc.
-Enrich with geo and time hierarchies

Visualize + Explore
-Insight from structured and unstructured data
-Flexible and iterative workflow makes discovery insight engaging and powerful
-Filter/Exclude/Rank/Sort

Share:
-Share visualization by email
-Share datasets to Lumira Cloud and Server
-Publish as HANA view
-Save to BIP as Explorer Info Space

H100 BO Analysis for OLAP/BEX

BO Analysis for OLAP

·         Dedicated Ad-Hoc OLAP  client for Business users to analyze OLAP data
·         Interoperability between designer and ad-hoc client
·         Simultaneous connection to multiple queries from different data providers
·         Report off analytic views/calculation views
·         Web based applications

·         Save/open a workbook to/from the SAP BI platform server
·         Undo/Redo
·         Define style sets for crosstabs
·         Swap axes
·         Analyze data with the design panel
·         Filter members
·         Sort data by members and by measures
·         Insert Charts
·         Insert filter components
·         Convert crosstab cells to formula
·         Create Presentations
·         Pause/Refresh


Access Analytics and Calculation Views from Analysis Edition from OLAP via OLAP Connection defined inside the Central Management Console of BO Enterprise Server

BO Analysis, edition for OLAP = Multidimensional data analysis within a web-based environment


------------------------------------------------------------------------------------------
Org has got a vast amount of data to explore the data and find patterns to which no set report exists
------------------------------------------------------------------------------------------

Explain when to use Bex on top of HANA
Explain how to configure SAP BO to use HANA
Create an Explorer Info SPace to Explore HANA data within Explorer


1)Explain when to use Bex on top of HANA
·         Key word search to find bzn info
·         Answers on the fly and investigates questions

·         Searches directly on pre-indexed data
·         No previous reports or metrics need to exist
·         Fast exploration
·         Searches across all data sources
·         Any universe accessible source
·         Any netWeaver BW Accelerator accessible source


2) Explain how to configure SAP BO to use HANA
Connection defined in IDT
View created from HANA Studio
BO Explorer = Search relevant information and direct exploration of data


3) Create an Explorer Info Space to Explore HANA data within Explorer


1) Start SAP BI LaunchPad
2) When prompted to logon to BI Launchpad, enter the following information
3) In the My Application menu, choose Explorer
4) Choose manage Spaces
5) Expand the folder SAP Hana appliance -> HDB
6) Select the Calculation View 
7) to create a new info space on this calculation view, choose new
8) in the properties tab, define the following properties
         Measure
        Attribute
9)To index the new Infospace, in the Action column choose index now
10)Back to the home tab, to update the list of info spaces, choose refresh list
11) open the info space:
12) ready to explore the data set

H100 SAP BO Tools available/descriptions

SAP BO: 5 BI requirements:

·         Reporting: Crystal Reports
·         Dashboards and Visualization:  Dashboards, DesignStudio
·         Interactive Analysis:  WebIntelligence
·         Advanced Analysis:  Analysis for MS office/for OLAP
·         Search and Exploration:  Explorer, Lumira



Source Systems and data sources needed to be connected:
1)      Reporting Client Deployment (desktop, Web, MS Office Integation)
2)      Reporting Client Technology (HTML5, Flash, mobile requirements)
3)      Reporting Client features (hierarchies, variables, calculations, graphical visualization, Export to PDF/XLS, etc.)
4)      Deployment reporting content (NetWeaver Porta, BO BI Platform, etc.)


SAP Crystal Reports for Enterprise:
1)      Consume attractive, personalized dashboards online or offline
a.       Access to personalized, flash-based dashboards
b.       Secure visualizations anywhere- portal, reports, PDF, MS Office documents
2)      Empower business users with interactive information
a.       Powerful “what-if” analysis with sliders and controllers
b.       Ability to drill-down into details
c.       Pre-built components, skins, maps, charts, gauges, and selectors

Dashboarding and Data Visualization -SAP BO dashboard design

1)      Empower business with easy to use reporting
a.       Intuitive, web-based interface with offline capabilities
b.       Multi-source access
c.       Interactivity with filtering, ranking, sorting, calculations
d.       Data lineage
2)      Lighten IT workload
a.       Self-service data access and reporting
b.       Controlled and secure access with tight BI platform integration
c.       Intuitive, business-centric view of info. With universes

Ad Hoc Querying and Reporting- SAP BO Webi
1)      Office based analysis and hierarchical navigation of RT data in HANA
a.       Business analyst interface, integrated in MSFT office, for analyzing data
b.       Hierarchical navigation of HANA views
c.       Calculations pushed into the HANA engine or in the local document
d.       Excel rendering and storage of data for sharing with colleagues
2)      Key capabilities on HANA
a.       Direct access to Hana views
b.       Support of variables
c.       Support of hierarchies
d.       Full HANA online experience
e.       SSO to HANA

SAP BO for MS Office

1)      Bring BI to all Business users
a.       Data exploration/visualization
b.       Fast response/simplicity/speed of search
c.       Easy and efficient to manage/scale

SAP BO Explorer

1)      Discovery and visualization of RT data
a.       BA interface for visualization and data exploration
b.       Automated/user defined enrichment of information
c.       Dynamic filtering of tables and visualizations
2)      Key capabilities on HANA
a.       Support of variables/level based hierarchies
b.       SSO to HANA

c.       Direct access to HANA views