Sunday, 29 November 2020

How to Generate a Email Notification when PM Order/Workorder is Technical completed?

Introduction

This blog will cover the condition where you can generate a Notification to Appropriate Authority which can be a Buyer/Procurement Department , Accounts Payable Department/ Finance Department etc, that a Plant Maintenance Order/Workorder has been Technically Completed(TECO).

Friday, 27 November 2020

Agile Data Modeling with SAP BW/4 HANA

Intro

SAP BW means inflexible and expensive monolith? That doesn’t have to be! With SAP BW/4 HANA, the development can be much more iterative than before.

So the following applies(?): SAP BW/4 HANA = leaner, faster … cheaper? It depends on your architecture!

With this post I would like to give you an impression of why SAP BW/4 HANA (finally) enables data models that react flexibly to changes!

Thursday, 26 November 2020

Tuning SAP IQ NLS in SAP BW on HANA and BW/4HANA

Introduction

In any SAP BW on HANA and BW/4HANA implementations, customers use an NLS (Near Line Store) solution to offload and archive data from the main system.  The offering from SAP as well as a few partners uses SAP IQ as the database for the NLS solution.  Invariably, situations arise when performance against data in the NLS system just seems slower than it should be.

The focus of this blog is to point you in the different directions that can be at the root cause of any performance issues.  As always, we must be prepared to change our expectations.  On countless occasions, I have had customers demand that the NLS system perform at the same level as the HANA system.  That is just not realistic and should never be expected.  SAP HANA operates on data that is in-memory and was designed to be an in-memory platform.  SAP IQ is a general purpose database that was designed for disk based storage, albeit highly optimized.

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.

Monday, 23 November 2020

Understanding the development process of calculation view in HANA 2.0 XSA environment using Web IDE

In this blog I will discuss about the development lifecycle process and steps of develop an calculation view in HANA 2.0 XSA environment using Web IDE.

In HANA 1.0 till SPS12 we have developed Calculation view with the catalog object tables from a schema also the operation available for development like Join, Union is very less.

In HANA 2.0 XSA environment using web IDE we will get more operation option like NonEqui Join, Graph, Rank, Rank, Hierarchy Function, Anonymization etc. which are not  available in HANA studio. Those option any body can easily adopt and use in their view development. I will not discuss this in my blog.

Friday, 20 November 2020

Compliant Data Access – A key Self-Service Requirement in 2020

Sensitive & Compliant Data Access – A key Self-Service Requirement in 2020

Enabled in SAP Data Warehouse Cloud through SAP HANA data anonymization

A growing number of people is making use of the latest technologies. Its power and increasing accessibility are shown in personal apps that ultimately generate data. For companies that build solutions on new technologies and retrieve information about their users, it is key to use methodologies that allow handling sensitive data with care. In order to derive insights from data, adherence to data privacy laws and regulations needs to be ensured. These considerations are necessary not only with regards to external customer or supplier data but also when working with internal data as we did in the case outlined in this blog article.

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.

Friday, 13 November 2020

Migrating SAP HANA to the Cloud: AWS, Azure, and GCP

SAP HANA Tutorial and Material, SAP ABAP Certification, SAP ABAP Learning, SAP HANA Exam Prep

What Is SAP HANA?


SAP HANA is an in-memory system for managing relational databases. Because HANA is based on a columnar structure, and stores all data in memory, data can be retrieved with very high performance compared to traditional RDBMS systems. SAP HANA is commonly used for next generation applications, business intelligence, and analytics.

Thursday, 12 November 2020

Create your trial SAP HANA cloud instance in sap cloud foundry

SAP HANA Cloud Instance setup

To get started with SAP HANA Cloud, you need to create your trial instance. Because you are using a trial account, you will only be able to create one instance with a predefined size, which you see now on the screen. However, the process to create the instance is very similar to what you will see later if you choose to have a production instance of SAP HANA Cloud.

Wednesday, 11 November 2020

Flexible Master Data Associations with SAP BW / 4HANA: Opportunities and Limits

Intro

Changed Requirements for modern Data Warehouse Systems mean that aspects such as Simplicity, Flexibility and Agility are becomming more important and therefore should be considered in the architecture and modeling of such systems.

With its data warehouse product, SAP BW4 / HANA, SAP offers the possibility of implementing such modern architectures beyond a rigid and outdated Layered Scalable Architecture (LSA). SAP recommends an architecture that is based on the LSA ++. This new layer approach is particularly characterized by the focus on virtual objects. Virtualization means that fewer copies of data are required between layers of architecture, making their design simpler, smaller and faster. The data warehouse architecture should be designed as lean and simple as possible.