Showing posts with label SAP Web IDE. Show all posts
Showing posts with label SAP Web IDE. Show all posts

Monday, 8 January 2024

HANA Prod tables access in Dev for CV nodes data preview

SAP HANA XS Advanced application developments are done using Web IDE for HANA and it is installed in Dev instance and not in QA/prod instance. It is because we don’t want any changes directly deployed in Prod. In that case, we can’t troubleshoot the CV nodes data preview in Prod.

So we can configure the process below to access Dev and Prod tables interchangeably when required.

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

It’s recommended to use Shared local Container/Schema details within the development team while working on the same project or Dependent Data model. The procedure outlined below explains how to access objects from another local container by modifying the YAML file in HANA XSA:

1. If you are the owner of the Source local container/schema (Cont_1), you need to provide access to another developer who intends to consume the object. Use the SQL script provided below to grant access:

Wednesday, 5 April 2023

Calculation View Features of SAP HANA 2.0 SPS07

With the release of SAP Web IDE SPS07 and HANA 2.0 SPS07, new features in the area of calculation view modeling will become available that had only been released in SAP HANA Cloud before.

Below is a short description of newly released features. For examples of the individual features have a look at the respective project “SPS07_Selected_Calculation_View_Modeling_Features” that can be found here.

Comments in Expressions


Use comments in expressions to better document the intention behind expressions. This will help during later refactoring and improve collaborative working.

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

Housekeeping of HDI containers in developer workspaces

Introduction

When ever a developer is doing local build of a db module in WebIDE for HANA, it creates an HANA service instance that name looks like <USER><GUID><MODULE_NAME>.

You can see those HANA service instances via XSA Cockpit

SAP HANA, SAP HANA EXAM, SAP HANA Exam Preparation, SAP HANA Career, SAP HANA Study Materials, SAP HANA Skills, SAP HANA Job

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.

In the recent few months, there were several questions about HANA 2.0 upgrade in the forums. Some developers thought that, it is a big change and lot of things get changed with that. It is not true though in all cases. In this blog, I am writing about the options generally available while doing the upgrade project to 2.0.

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

You will learn how to set up the roles, synonyms and deployment configuration to access objects in a HANA Deployment Infrastructure (HDI) container from another HDI container.

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

SAP HANA cockpit 2.0 SP 11 introduces numerous new features and enhancements to existing features.

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

For a few of the items he wanted, like bg-deploy, I was able to point to existing content that hopefully will help. But for some of the items there certainly were lacking examples.  One of them he mentioned was Email from XSA (pure node and xsjs).

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.

Friday, 9 August 2019

SAP HANA XSA Controller API Interaction

Since the introduction of SAP HANA extended application services, advanced model (XSA), SAP has supported many new approaches to accessing the platform APIs.  XSA is based upon Cloud Foundry which provides its core functionality via a command line client and a REST enabled web API.  XSA has this same functionality, but most of the focus on platform admin and interaction tends to focus on the CLI interface or the browser-based administrative UI which SAP deliveries. However behind that web UI are essentially calls to the controller APIs. These same APIs can be called from and used in your own applications.  In this blog I’d like to share some experiences trying to use these APIs.  There are some common challenges anyone using them will face and perhaps this blog can be helpful in that regard.

Monday, 17 June 2019

Capture Change Data with the SDI Flowgraph Table Comparison

When batch-loading data from a source system into your Data Mart or Data Warehouse, you usually look for ways to reduce the to-be extracted data set to minimize extraction time and resource consumption. Ideally, there is a way to only extract changed records, for example, using a change date column. However, this does not always fly. For example, change date columns are not always reliable or deletions are not always tracked in the source table. An alternative would be to switch from batch to log or trigger replication on the source, but you don’t always have this luxury. So, now you have to load the entire source data set, but still you want to identify the change data, to only process delta’s in downstream data flows. How can you identify such change data using batch loading?