Transcript SAP HANA 1.0

SAP HANA Exam Preparation
Harold Colglazier November 12, 2012
Agenda
 SAP HANA Learning Path
 SAP HANA available documentation
 Certification Key Facts
 SAP Hana Use Cases CO-PA
 Additional Tips
SAP HANA Learning Path
SAP HANA –
Introduction
SAP HANA –
Installation &
Administration
C_HANATEC_1 SAP
Certified Technology
Associate – SAP HANA 1.0
SAP HANA –
Implementation
and Modeling
C_HANAIMP_1 SAP
Certified Application
Associate – SAP HANA 1.0
SAP PORTAL Resources
SAP NS2 Resources
HA100R Introduction to SAP HANA
SAP HANA Studying for Certification
HA100 Introduction to SAP
HANA Flipbook
Elearning Link
HA300R Implementation and
Modeling
HA100 Introduction to SAP HANA
HA300 Implementation and Modeling
SAP HANA Documentation
SAP HANA Appliance Software
Support Package Stack 04
Further Information
SAP HANA (external)
•
•
•
•
•
•
•
•
•
•
SAP HANA Solutions – Applications
SAP HANA Help Portal
Experience SAP HANA
Community Network – SAP HANA
SAP CN wiki for SAP Products
Virtual SAP TechEd
SAP HANA Development Center
SAP HANA Reference Document
SAP HANA Database Administration
SAP HANA Services Community (SAP Portal)
SAP Learning Plan for SAP HANA
Application Consultant
SAP HANA Academy:
•
This learning plan is intended for Application consultants who have to Load, Model and Report on SAP
HANA. Before starting this learning plan, it is strongly recommended that you complete the HANA
Overview Training.
•
SAP HANA Academy From the Experience SAP HANA site, a collection of 30+ How To Videos are available
on key topics such as HANA loading, modeling, reporting, administration, security and mobility. 6 hrs+
•
This HANA RKT learning map for Application Consultants provides access to PDF files that covers the
fundamentals of SAP HANA. Topics include: Architecture, Data Provisioning, Modeling, Reporting, User
Management and CO-PA Scenario.
•
HANA RKT Learning Maps and delta training for HANA SP04.
•
Introduction Concept of the Trigger based Replication; Installation of the LT Replication Server; Replication
Configuration
•
This session provides an overview on SAP HANA studio, the application that is used for data modeling as
well as administration. Covered topics are: look and feel, user administration, data modeling, system
troubleshooting, SQL console.
•
The session will show the basic concept how a HANA database can utilized for accelerating programs in
the ERP environment by accessing data from a connected HANA database containing replicated ERP-tables
and views. It will also cover the strengths and weaknesses of HANA when called in that context, and
contains a demo on SE16H, the table content display enhanced for HANA. It is addressing colleagues who
focus on ABAP programming and are interested to learn how to work with a HANA database
Key Facts of the Certification
Target audience: Partner consultants, SAP consultants and customers that engage in SAP
HANA projects in modeling and implementation roles.
Delivery options: Pearson VUE
Certification title: “SAP Certified Application Associate - SAP HANA 1.0”
Booking code: C_HANAIMP_1
Exam structure: 3 hours multiple-choice exam with 80 items
Key Facts of the Certification
Level: Associate
Software Release: SAP HANA 1.0
Passing Score: 64%
Key Facts of the CertificationCompetency Area
The following list helps you to identify the competency areas covered in this test. The
percentage indicates the portion of the test dedicated to a particular competency
area.
Topic
Weight
Business Content
< 8%
Data Modeling
> 12%
Data Provisioning
>12%
Optimization
8-12%
Reporting
8-12%
Security and Authorization
<8%
How to schedule the Test
Schedule the test through the Pearson VUE website :
http://www.pearsonvue.com/sap/
Create an account and call pearsonvue when registering to take exam
Use the Pearson VUE promotional code for 2012 : SAPC2012
To waive the associated testing fees.
Sample questions
Sample question for the test can be found in the link below and also in the following
link:
SAP HANA Certification Exam preparation
Experience from other Consultants
who have passed the test
1. Review e-learning courses for Application consultant
2. HA100 and HA300 courses will certainly get you most of the way.
3. There were few questions that would require some practical experience (at least
completing the CO-PA scenario helps) and very few required out of box thinking ;)
4. Modeling/Reporting/Data provisioning were the heaviest.
5. Security/Business Content were light and easy.
6. Optimization was light but tricky.
Additional Tips- Over view & Business
Content
•Different components of HANA database ( Studio is not part of the database)
•Perspectives in HANA Studio
•Advantages of HANA
•Faster than ERP/OLTP & OLAP in one system/Real-time analytics etc.
•System Setup
•Sequence of steps; System setup/Data Provisioning/Modeling/Consumption
•Understand Accelerator high level concepts
•Advantages (pre-built content, faster implementation etc.)
•What accelerator is recommended for a given scenario (for e.g. to measure
profitability, CO-PA accelerator for HANA would be recommended)
•BW on HANA
•What is needed to have BW run on HANA? (Migrate database; convert to HANA
object types etc.) Remember that BWA is no longer needed.
Understand HANA Use Cases, CO-PA
XML Model Generation tool helps avoid all of this (from
HANA 1.0 RKT material)
© 2011 SAP AG. All rights reserved.
Presentation contains current status of discussion and can be subject to change w/o notice.
Confidential
5
XML Model Generation tool helps avoid all of this too!
(from HANA 1.0 RKT material)
© 2011 SAP AG. All rights reserved.
Presentation contains current status of discussion and can be subject to change w/o notice.
Confidential
6
Structure of the CO-PA model in HANA
Calculation View for Plan & Actuals
Analytic View for Actuals
f(x) (not part of XML generation)
Analytic View for Plan data
Actuals line items CE1xxxx
Plan line items CE2xxxx
Keys:
-Object no.
-Customer
-Product
-Sales Org
-...
Keys:
-Object no.
-Customer
-Product
-Sales Org
-...
Persisted key figures:
-Gross sales
-Sales deductions
-Variable cost
-..
Persisted key figures:
-Gross sales
-Sales deductions
-Variable cost
-..
Calculated key figures:
-Contribution Margin
-Net Sales
-...
© 2011 SAP AG. All rights reserved.
Master data
Master data and
and texts
texts
e.g. for
product
Attribute Views
Calculated key figures:
-Contribution Margin
-Net Sales
-...
Presentation contains current status of discussion and can be subject to change w/o notice.
Confidential
9
Additional Tips- Data Provisioning
Additional Tips- Data Provisioning
Additional Tips- Data Provisioning
Additional Tips- HANA Data Modeling
Hierarchies
•Steps in defining hierarchy/Accessible methods
Attribute Views
•Calendars for time views
•Derived attribute views
Analytical Views
•Minimum required to create one
•Input sources
•Joins
•Text join cardinality
Calculation views
When is it required
Types of nodes in Graphical option
Recommendations in script editor for calc view as far as selecting data
Analytical Privileges
•Steps required
Additional Tips- HANA Data Modeling
Modeling
Recommendations for good modeling
For e.g. CE Functions vs SQL; Scenarios that require data intensive logic sent to
database instead of at reporting layer; Recommendations in SQL Script etc.
Various scenarios and recommended techniques
For e.g. Need to filter data for a year. Where is the recommended place to do this?
Reporting/Analytical View/Data foundation etc.
Recommend reading development guide available. Last chapter has good modeling
techniques and best practices
Thank you