• 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 Cases8% – 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 Processing8% – 12%

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

Management and Administration of Models8% – 12%

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

Optimization of Models8% – 12%

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

SQL and SQLScript8% – 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.