Monday, 8 January 2024
HANA Prod tables access in Dev for CV nodes data preview
Friday, 28 July 2023
Accessing Objects from Another Local Container in HANA XSA and Deploying Selected Artifacts Using PACKAGE.JSON in HANA DB: A Step-by-Step Guide
Wednesday, 5 April 2023
Calculation View Features of SAP HANA 2.0 SPS07
Comments in Expressions
Wednesday, 16 March 2022
SAP HANA XS Advanced Administration, Deployment and Operations
Many SAP Customers started using XS Advanced and there were several questions on how to deploy or where to deploy and what are the consideration for choosing any of those approached. Based on my experience with various customers I tried to address some key topics in this blog to consolidate information from various sources of documentations
1. Deployment Options
There are various ways of deploying the XS Advanced runtime. Before deploying the XSA many scenarios need to considered that will have impact on your landscape maintenance activity. For example the system refresh scenarios where you will need to refresh only a certain tenants instead of complete system this deployment plays a key role. I will go through the limitations in detail in backup restore section. In general, The following additional services run where XSA is deployed:
Monday, 17 January 2022
Helpful Techniques For Adapting Projects to Operate in a Different Environment (e.g., Move from on Premise to SAP HANA Cloud)
One benefit of using the HANA Deployment Infrastructure (HDI) is that a clear interface exists that lists the dependencies to objects outside of the respective HDI container. With this it becomes pretty simple to adapt a project that should run in a different environment, such as when moving a project that has been developed in an on premise XSA environment with SAP Web IDE for SAP HANA to SAP HANA Cloud.
Below several concepts are illustrated that help to adapt existing projects that refer to objects that are not contained in the project.
The main challenge you will face when moving your project to a different environment is that you cannot rely on resources that are not included in your project. For example, resources might only exist under a different name or schema. The new development concepts of SAP HANA, in particular the deployment with the SAP HANA Deployment Infrastructure (HDI), prepares you for this task by abstracting away dependencies to resources outside of your project. Dependencies in HDI come into your project via mainly two routes:
Friday, 24 December 2021
Wednesday, 15 December 2021
Manage XS Advanced via SQL
Introduction
The main tools for XS Advanced administration are the XS Command-Line Interface and the XS Advanced Cockpit.
For both of them, the prerequisites are to have an XS Advanced user with required role collections and also to be member of the organization/space you want to manage.
If you are using XSA only in the context of Data modeling (HDI Advanced Model) via WebIDE for HANA, you may face the situation that developers have XS Advanced users in development system but only basic database users in quality and production systems. For security reason, you may not want to provide them access to XSA Cockpit in Quality and Production systems.
Thursday, 10 June 2021
SAP HANA XS Advanced Administration, Deployment and Operations
1. Deployment Options
There are various ways of deploying the XS Advanced runtime. Before deploying the XSA many scenarios need to considered that will have impact on your landscape maintenance activity .For example the system refresh scenarios where you will need to refresh only a certain tenants instead of complete system this deployment plays a key role . I will go through the limitations in detail in backup restore section. In general, The following additional services run where XSA is deployed:
◉ xscontroller: Central management component of XSA. It has a view on all deployed and/or running applications, and persists configuration and status information in the database
Wednesday, 17 February 2021
Importing shapefiles into SAP HANA Cloud using the Wizard
In this blog post I will try and show you the easiest way to import shapefiles data into HANA Cloud, via the wizard.
There are alternative ways of importing spatial data, that can be used.
◉ Import shapefile via wizard
◉ Import CSV via wizard and convert to spatial data types
◉ Import CSV from Cloud Object Store (S3, GCS, ADL) and convert.
Wednesday, 25 November 2020
Set up real-time replication tasks with the SAP Web IDE and SAP Smart Data Integration
The SAP Web IDE provides so-called replication tasks to set up real-time replication. It provides a graphical UI to browse tables in your connected source systems, create virtual tables, create subscriptions for real-time replication, create data load partitioning strategies, and more. The replication tasks in Web IDE are part of the SAP Smart Data Integration (SDI) toolset, which comes integrated with the SAP HANA platform, both on-premise and in the cloud.
Wednesday, 18 November 2020
Create custom filters using SAP Analytics Cloud Analytics Designer and SAP HANA
Introduction
SAP Analytics Cloud’s story mode supports various filter concepts such as story filters, page filters, widget filters, input controls and linked analysis. SAC’s Analytic Application uses a different approach to implement filter capabilities in dashboards. In fact, the Analytics Designer (where Analytic Applications are created) is all about customization and flexibility.
SAC’s Analytics Designer provides filtering capabilities through programming APIs. A full documentation of SAC Analytics Designer APIs can be found here. This enables developers to create the desired filtering logic within a dashboard. Furthermore, with Analytics Designer APIs you can create your own filtering concepts! This blog post will guide you along one specific scenario to create such a custom filter.
Wednesday, 1 April 2020
SAP HANA Upgrade from 1.0 to 2.0, project options.
If it is just a database upgrade, then It is fairly a simple process which is taken care by basis/Admin team, leaving modelers/developers with no specific task to be done during this process.
Wednesday, 15 January 2020
Replicating Data from Oracle to HANA using SAP HANA Web IDE SDI
Overview
SAP Smart Data Integration provides real time, high speed data provisioning, bulk data movement, and federation. Replication task or flowgraph lets you set up batch or real-time data replication and transformation scenarios in an easy-to-use web application. Data Provisioning Agent hosts data provisioning adapters, enables data federation, replication, and transformation scenarios for on-premise or in-cloud deployments. Monitors for Data Provisioning Agents, remote subscriptions, and data loads are accessible from the SAP HANA cockpit.
Tuesday, 14 January 2020
Non Equi join in SAP HANA 2.0 Web IDE
Purpose:
Purpose of this blog is to demonstrate the use of “Non Equi join” in SAP HANA Modelling. SAP HANA 1.0 modelling does not support the Non Equi join between two data set, however in hana 2.0 SAP Web IDE modelling new feature added to support Non Equi join.
Saturday, 11 January 2020
Minus set operation in SAP HANA 2.0 Web IDE
Purpose:
Purpose of this blog is to demonstrate the use of “Minus” set operator in SAP HANA Modelling.
SAP HANA 1.0 modelling does not directly support the Minus operation between two data set, however in hana 2.0 SAP Web IDE modelling new feature added to support Minus operation between two data set.
Friday, 13 December 2019
SAP HANA XS Advanced - Cross-container access
Step 1: Create the target container as a resource
This tutorial uses the SAP HANA INteractive Education model as an example of a target HDI container. Create thistarget container by following the XSA-specific instructions found in the SHINE source code repository.
Tuesday, 22 October 2019
What’s New in SAP HANA Cockpit 2.0 SP 11
Highlighted below are five features that have been enhanced to improve the functionality and the user experience of the SAP HANA cockpit.
1. Enhanced Support for Native Storage Extension
Check out the new Buffer Cache Monitor of the SAP HANA Native Storage Extension to find out which tables, partitions, and columns are using most of the cache. This allows you to avoid negative impact on workloads by catching out-of-buffer alerts.
Friday, 16 August 2019
SAP HANA XSA Email Example
This is a particular example or exercise that is often requested but I’m personally reluctant to do. It gets complicated fast because of the dependency upon an external SMTP server and the individual setup and authentication steps needed for the various different providers.