Thursday 19 January 2017

HALM Usage and Troubleshooting

What is HALM?

HALM stands for HANA Application Lifecycle Management, this image from the documentation explains the product lifecycle using HALM:

HALM Usage and Troubleshooting

Wednesday 18 January 2017

How to Prepare for C_HANAIMP_12 Certification on SAP HANAIMP 12

All that you need to know about SAP C_HANAIMP_12

SAP launched HANAIMP 12 primarily based on in-memory expertise with which customers can analyze giant volumes of informations and data in flip of seconds. This post is about the certifications which can be obtained with on SAP HANAIMP 12. SAP certification builds on the fundamental knowledge gained through related SAP C_HANAIMP 12 coaching and ideally refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects. SAP has made available only one Associate Consultant certification with code: C_HANAIMP_12. This exam primarily verifies that the candidate possesses the knowledge in the area of the SAP HANAIMP 12 for the profile of an SAP HANAIMP 12 consultant. Make sure you are able to gain complete understanding and firm knowledge on SAP HANAIMP 12 certification syllabus. That includes SyllabusTopic for excellence in certification exam. Learn and explore everything about the SAP HANAIMP 12 for the profile of an SAP HANAIMP 12 consultant Things that you should be aware of for C_HANAIMP_12
Get complete detail on The "SAP Certified Application Associate - SAP HANA (Edition 2016 - SPS12)" certification exam certification syllabus Below I have gathered all the data accessible to the very best of my knowledge related to the certification exam:
  1. How many questions are there in the exam?
      A: 80
  1. What is the duration of exam?

SAP HANA Tools-Modeler and Web IDE (New and Changed) – SAP HANA Platform 2.0 SP00

As of SAP HANA Platform 2.0 SP00, the following new features and changes are available in SAP Web IDE and integrated SAP HANA tools.

SAP Web IDE for SAP HANA is a browser-based integrated development environment (IDE) for the development of SAP HANA-based applications comprised of web-based or mobile UIs, business logic, and extensive SAP HANA data models. SAP Web IDE works in conjunction with the SAP HANA deployment infrastructure (HDI), the Application Lifecycle Management tools (ALM), the XS Advanced runtime platform, and various SAP HANA tools.

Saturday 14 January 2017

C_HANATEC_11 Certification Guide

All that you need to know about SAP C_HANATEC_11
SAP launched HANA Technology primarily based on in-memory expertise with which customers can analyze huge volumes of information and data in flip of seconds. This post is about the certifications which can be obtained with on SAP HANA Technology. SAP certification builds on the fundamental knowledge gained through related SAP HANA Technology coaching and ideally refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects.
SAP has made available only one Associate Consultant certification with code: C_HANATEC_11This exam primarily verifies that the candidate possesses the knowledge in the area of the SAP HANA Technology for the profile of an SAP HANA Technology consultant.
Make sure you are able to gain complete understanding and firm knowledge on SAP HANA Technology certification syllabus. That includes topics like System Architecture, Users and Authorization, Security etc.

Thursday 12 January 2017

Did you know you can add Spatial Reference Systems to HANA?

By default, HANA has 4 preconfigured Spatial Reference Systems (SRS).  Two of the preconfigured ones most used are 4326 (WGS 84 Spheroidal) and 1000004326 (WGS 84 Planar). However, there are over 3000 other spatial reference systems and many of our customers utilize some of them.  So how do you add additional ones?

Synonyms in HANA XS Advanced, Configuration, Templating, Service Replacement

In the previous post I showed the complete end-to-end scenario of using synonyms in XS Advanced. In this post I will show, how more flexibility can be achieved.

The flexibility options do not really depend on whether accessing a classical schema or a generated HDI Container. Everything that is different was explained in the previous post. I will therefore only use a classical schema OR an HDI container as target, not both. And I will focus on the things that are different with flexible synonym targets.

Wednesday 11 January 2017

Synonyms in HANA XS Advanced, Accessing Objects in an External Schema

In the previous post I introduced synonyms in XS Advanced (XSA) and created a very simple synonym. Now I will create synonyms pointing to objects I defined by myself.
Accessing Objects in a Classical Schema

I assume, that the external schema I want to access is already existing. The example schema EPM_DEV can be created by using repo https://github.com/CGilde/syn-prov-classic. I also assume, there is already a project with a db module existing in the XSA Web IDE. We will insert the synonyms into this project. A git repo for the project with the complete coding can be found at https://github.com/CGilde/syn-hdi-classic-1.

Tuesday 10 January 2017

Synonyms in HANA XS Advanced, Introduction

Why Synonyms?

A complex HANA data warehouse might use several DB schemas in which tables, views and other
DB objects reside. E.g., there might be a replicated ERP schema managed by SLT, a Netweaver/BW schema managed by the Netweaver Stack, and a “native” HANA schema, all residing in the same HANA instance and all of them consumed by the same data warehouse application.

Saturday 7 January 2017

How to – Import SFLIGHT sample data into HANA from a local computer

As you discovered few seconds ago, HANA doesn’t come with any preloaded sample data.

So, before starting to play with your brand new system, you need to find and load some data.

Luckily SAP provides for free its flight data model (you can download it here unluckillly the previous link doesn’t work anymore; I will try to fix this issue asap) – it’s a good starting point since it contains a sufficient amount of data and a limited number of tables.

Friday 6 January 2017

Let’s Build an Analytical Card for a Fiori Overview Page (with a HANA Backend)

The Proposed Process

Step 1: Identify the need
Step 2: Design
Step 3: Back-end development
Step 4: Front-end configuration (or really development at this point)

Wednesday 4 January 2017

Installing Hana Server (SP12) and XS Advanced Runtime Components

The main purpose of this blog post is to list the steps required to provision a Hana SP12 System as a development server, along with XS Advanced runtime components such as the Database Catalog Tool (HRTT) and WebIDE.

Note – In this blog post we will be using command line tools for the installation. However, the last few steps should be applicable to even if you used the GUI.

Constant Selection in SAP HANA Using Dynamic Join

In SAP BW, there is this concept of “Constant Selection” where you can mark a selection in the Query Designer as constant. This means that navigation and filtering will have no effect on the selection at runtime.

In SAP HANA, there is no feature that directly supports this functionality. We have to model it ourselves. One way to implement it is through “self joins” and “dynamic joins”.

Tuesday 3 January 2017

Does your CFO need a real time geolocation report?

In a constantly evolving world, CEOs and CFOs must adapt continuously to their new market dimension. Having access to real time reporting gives a serious advantage on its competitors. Thus, CFOs can obtain the necessary information to have a real-time picture of their finance.
Real time reconciliation introduced by SAP Simple Finance solution increases the confidence index of financial reporting. In a more and more competitive world, CFOs can detect earlier business lines profitability decrease and take appropriate decision.