1 / 24

SAP HANA Exam Preparation

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. C_HANATEC_1 SAP Certified Technology Associate – SAP HANA 1.0.

etta
Download Presentation

SAP HANA Exam Preparation

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAP HANA Exam Preparation Harold Colglazier November 12, 2012

  2. Agenda • SAP HANA Learning Path • SAP HANA available documentation • Certification Key Facts • SAP Hana Use Cases CO-PA • Additional Tips

  3. SAP HANA Learning Path C_HANATEC_1 SAP Certified Technology Associate – SAP HANA 1.0 SAP HANA – Installation & Administration SAP HANA – Introduction C_HANAIMP_1 SAP Certified Application Associate – SAP HANA 1.0 • SAP HANA – Implementation and Modeling SAP PORTAL Resources SAP NS2 Resources HA100R Introduction to SAP HANA SAP HANA Studying for Certification HA300R Implementation and Modeling HA100 Introduction to SAP HANA Flipbook HA100 Introduction to SAP HANA Elearning Link HA300 Implementation and Modeling

  4. SAP HANA Documentation SAP HANA Appliance Software Support Package Stack 04

  5. Further InformationSAP 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)

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

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

  8. Key Facts of the Certification Level:  Associate Software Release:  SAP HANA 1.0 Passing Score:64%

  9. Key Facts of the Certification- Competency 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.

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

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

  12. Experience from other Consultants who have passed the test Review e-learning courses for Application consultant HA100 and HA300 courses will certainly get you most of the way. 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 ;) Modeling/Reporting/Data provisioning were the heaviest. Security/Business Content were light and easy. Optimization was light but tricky.

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

  14. Understand HANA Use Cases, CO-PA

  15. Additional Tips- Data Provisioning

  16. Additional Tips- Data Provisioning

  17. Additional Tips- Data Provisioning

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

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

  20. Thank you

More Related