• The “SAP Certified Application Associate – SAP HANA SPS12 Modeling (Edition 2016)” certification exam verifies that the candidate possesses the required knowledge in the area of the SAP HANA for the profile of an SAP HANA application consultant. This delta certificate builds on the basic knowledge gained from related SAP HANA training and preferably refined by practical experience within an SAP HANA project team, whereby the consultant applies acquired knowledge in this specialist area practically in projects. This delta certification covers SPS09 to SPS12. C_HANAIMP151 OR C_HANAIMP_11 are pre-requisite exams for this delta certification.

Topic Areas

Please see below the list of topics that may be covered within this certification and the courses that cover them. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.

Information Views > 12%

Create cube type calculation views and define dimension type calculation views, develop calculation views of type star schema, describe scenarios when attribute and analytic views cannot be replaced by calculation views, and list the data sources that can be used in information models.

Modeling Functions > 12%

Create value help, based on hierarchies and define hierarchies with time dependency; filter using hierarchy nodes and derive input parameter values from scalar functions.

SAP HANA Architecture, Deployment Scenarios and Use Cases 8% – 12%

Compare XS classic with XS Advanced, HANA Studio with Web Workbench, and describe where Data Warehouse foundation fits with SAP HANA and how multi tenancy affects modeling.

Advanced Data Processing 8% – 12%

Implement text processing, spatial processing, predictive processing, and implement graph processing.

Management and Administration of Models 8% – 12%

Migrate information views, rename information models, display the lineage of objects in information models, and refactor parts of information models.

Optimization of Models 8% – 12%

Define pruning rules for unions, best practices for model creation, and work with performance mode within models.

SQL and SQLScript 8% – 12%

Access hierarchies via SQL, and compare table functions to script based calculation views and SQL with CE functions.

Virtual Data Models < 8%

Compare Core Data Services with native HANA modeling and describe Core Data Services.

Consumption of SAP HANA Models < 8%

Identify which BO reporting tools require universes for connection to HANA, describe how BW consumes information models, and identify which reporting tools can consume whsih type of hierarchies.

Key Concepts of HANA Data Provisioning < 8%

Describe SAP HANA Vora and compare data provisioning methods.

Security in SAP HANA Modeling < 8%

Implement SQL based analytic privileges and convert classic analytic priviliges to SQL based analytic privileges.

General Information

Exam Preparation

Each specific certification comes with its own set of preparation tactics. We define them as “Topic Areas” and they can be found on each exam description. You can find the number of questions, the duration of the exam, what areas you will be tested on, and recommended course work and content you can reference.

Please be aware that the professional- level certification also requires several years of practical on-the-job experience and addresses real-life scenarios.

For more nformation refer to our Take your SAP Certification Exams and our FAQs .

Safeguarding the Value of Certification

SAP Education has worked hard together with the Certification & Enablement Influence Council to enhance the value of certification and improve the exams. An increasing number of customers and partners are now looking towards certification as a reliable benchmark to safeguard their investments. Unfortunately, the increased demand for certification has brought with it a growing number of people who to try and attain SAP certification through unfair means. This ongoing issue has prompted SAP Education to place a new focus on test security. Please take a look at our  post  to understand what you can do to help to protect the credibility of your certification status.

Our Certification Test Security Guidelines will help you as test taker to understand the testing experience.

Cloud Security Guidelines  

Classroom Security Guidelines