Wednesday, 19 September 2018

How to import the ST05 trace file into HANA Studio and display as a graph

Some ABAPers might have already noticed this button “Graphical Explain” in tcode ST05 but do not know how to use it properly.

SAP HANA Studio, SAP HANA Certification, SAP HANA Tutorial and Material, SAP HANA Learning

Monday, 17 September 2018

Build database objects/services in HANA service using SAP WebIDE Full-Stack : Part 2

This blog is part of a blog series which shows to build HANA database artefacts using the SAP WebIDE Full-Stack and the new HANA service on Cloud Foundry.

Create Nodejs. Module


In this section, I am going to show how to create a nodejs module and add an OData service within it. This OData service will be used to expose the contents of the table/view modeled earlier.

Friday, 14 September 2018

Build database objects/services in HANA service using SAP WebIDE Full-Stack : Part 1

I walked through the steps to install and configure the HANA service on SAP Cloud Platform Cloud Foundry environment, In this blog series, I will focus on how to get started with building database objects using SAP WebIDE Full-Stack service. One of the main advantages of using SAP WebIDE is that you can now build a full-stack application (Database object, services with business logic and UI components etc). In this blog series, I am going to focus on how to create database objects and expose them as XSOData services. I have come across several requirements where data needs to be stored in SAP HANA service and needs to be exposed for other cloud platform services to consume. Hence, I will start by showing how to create DB artefacts and end by showing how to expose contents of a table using an OData service.

Wednesday, 12 September 2018

Sneak peek into HANA as a Service: Database artifacts and Calculation Views

If you are lucky to come to TechEd, I have plenty of instances to share for you to configure and deploy yourself. We will be using the Cloud Application Programming model to build a little something on top of them.

Monday, 10 September 2018

The SAP HANA JSON Document Store – Use Case Part-2

Example Use Case for the Document Store


Overview

In part one of this blog series the Document Store was introduced. The most interesting part about this is the possibility to interact with the relational world inside SAP HANA, e.g. joining a collection with a table. Since this is a very abstract feature, the following sections will introduce an example use case including SQL queries for a better and deeper understanding of the SAP HANA JSON Document Store.

Friday, 7 September 2018

Schedule HANA 2.0 backup using SAP HANA Cockpit 2.0 SPS 06

As we are aware that SAP HANA Cockpit is the new web based tool for SAP HANA Administration, recently I have been involved in BW/BPC HANA implementation migration project and I installed the latest SAP HANA Cockpit 2.0 SPS 06 patch 04 release to monitor and administer the non production and production HANA databases.

Wednesday, 5 September 2018

SLT Replication Logging and Replay To Retrieve Lost Data

We know SLT used for real-time replication to HANA but if we face below situations then SLT logging and replay is useful.

1. Table replication shows fine but some data fields not updated correctly(Due to product bug or any other reason) – example cases are flag fields where data changed multiple times in particular time.

Monday, 3 September 2018

Multiple SAML2 Identity Providers for HANA XS Artifact – How It Works

SAML 2 Single Sign-On (SSO) is usually a must-have for live HANA connections in SAP Analytics Cloud (SAC). In such a setup, the InA service, which is a HANA XS artifact, is configured with a SAML 2 Identity Provider (IdP), typically the same IdP as the one used by SAC. This IdP is often the corporate SAML 2 Identity Provider.