The process of gathering data from numerous sources is an essential prerequisite for organizations to carry out advanced analytics, data science, and machine learning. However, ingesting and consolidating this data to establish a trustworthy, unified data repository is an arduous and expensive task. In this blog post, I will demonstrate the process of ingesting data from....
Dear customers, Out of the SAP Enterprise Support Academy program we’ve launched a new learning program on the topic of SAP HANA Cloud. This course provides an administrator’s introduction into SAP HANA Cloud. You’ll gain an understanding of the system architecture and be guided through some practical examples of the tools available for the administrator. Also, it demonstrates....
The recent announcements about SAP partnering with Microsoft to build enterprise-ready innovative solutions excited us about the future of SAP solutions. And the integration with Microsoft Azure Open AI to access language models securely got us to think about productive use cases that might fit SAP HANA Cloud/SAP Datasphere scenarios. Again, the use case we are discussing is....
In this blogpost I will walk through the steps which are now possible due to the recent enhancements in SAP HANA Cloud Machine Learning Python Client API and demonstrate how a Data Scientist working in Python can generate SAP HANA Machine Learning artifacts for a CAP project consumed by a developer. This helps building a....
Service Level Agreements (SLA) for SAP Cloud Services requires high level of quality, performance and availability provided to the customer. Thus, fast recovery after i.e. a failed software or SAP HANA version update is essential. We provide a generalized fallback solution for these upgrade-related issues, introducing a SAP HANA Cloud snapshot-service. But even for other use cases,....
Lets jump right in with an actual question I just gave to a Hana Cloud Database: The response I got back was correct : Ok so you’re guessing I used ChatGPT, so it’s either hallucinating and made a lucky guess, or perhaps I pre-loaded the data (context) into ChatGPT and it just summarised the results....
In my recent blog Data Wizardry – Unleashing Live Insights with OpenAI, LangChain & SAP HANA I introduced an exciting vision of the future—a world where you can effortlessly interact with databases using natural language and receive real-time results. The process involves LangChain, OpenAI, and Hana working together to unlock the potential of natural language based....
This blog will provide a simple overview of the process of fine tuning Large Language Models (LLMs) with Enterprise data to help it produce tailored HANA SQL statements. It’s a continuation of my previous 2 blogs: Data Wizardry – Unleashing Live Insights with OpenAI, LangChain & SAP HANA Demonstrates how questions on live Enterprise....
Using the SAP HANA Cloud Central Wizard, the SAP HANA Cloud Instance can be created. Start with assigning the instance to a Cloud Foundry Organization and Space, Choose the name and description for the instance. Choose a user and password to log on to the instance. Then, choose the DB size, CPU and disk Storage....
This series will focus on enabling you to utilize the features of SAP HANA Cloud and developing data models using it. Prerequisites : To begin on this learning journey, the first few steps would focus on preparing your modeling environment. Below mentioned tutorials will help you to setup your BTP account and enabling your Business....
Introduction : SAP BTP provides many services, SAP HANA Cloud Database is one of them. As each service provides one or more service plans, which could be thought of as a variant, similarly SAP HANA Cloud is offered in different configurations and sizes. The plan one chooses is known as entitlement and quotas represent how....
This blog is part of a series explaining the multi-model capabilities of SAP HANA Cloud /SAP Datasphere with one end-to-end scenario using Spotify data. Here are the links for the other blogs of this series Part 1 – Architecture Part 2 – Processing Semi-Structured data in SAP HANA Cloud Part 3 – Processing Semi-structured data in SAP Datasphere ....
This document will explore scenario where there is a need to integrate a cloud-based application with older version of SAP ECC or S/4 HANA where integration cannot be achieved using WebSocket RFC. Integration between SAP S/4 HANA Public Cloud and Central Finance (CFIN) system is a critical component that need to consolidate their financial data....
Data Anonymization in SAP HANA Anonymization methods available in the SAP HANA database allow you to gain statistically valid insights from your data while protecting the privacy of individuals. Why Anonymize? In a data-driven world, a growing amount of business data contains personal or sensitive information. If this data is to be used by applications....
I was recently involved in a project that was migrating to SAP Datasphere. One of the solutions had a complex stock allocation routine that required row by row processing that could not be achieved directly in Datasphere but could be done by utilising the SQL Open Schema Space to create a stored procedure with a....
Using CAP CDS (Cloud Application Programming – Core Data Service) one would expect that this is working with HANA Cloud out of the box. That is unfortunately not the case. But with a little switch things are getting better. In the beginning CAP CDS for HANA was generating HDBCDS. This was also seen as the....
Goal : With the help of SAP Automation Pilot, lets define a custom alert which runs a custom SQL command. As sample for this blog, we retrieve the list of HDI containers (unused > 90 days ) and send this list to the user via email using SAP Alert Notification Service. This blog serves two purposes: Writing....
Important Links SAP-samples GitHub Repository Hello and welcome to another blog post and step-by-step tutorial on the topic of building a multitenant SaaS application on SAP BTP using CAP. Following the joined blog post series (of Alper Dedeoglu and myself) on building a multitenant SaaS application in the Cloud Foundry environment, today’s journey is all about the SAP BTP, Kyma runtime. So, buckle up, it’s....
Part 1: Setting up Address Validation Service in BTP This Blog is a collaboration work between SAP Business Technology Platform (BTP) Team, SAP Data Quality Management Team and SAP SuccessFactors Employee Central – Localization Team. In this article we want to share our hands-on experience on a recent project experience and learning journey on how....
After recent upgrade in customer systems, it was observed that master data activation was failing. The reason behind this was modification made to the number range for the material type SERV in the customer system. The master data follows the SAP standard delivered value ranges. This document explains the SAP standard delivered internal and external....
Greetings and salutations, fellow CAP enthusiasts! We’re back with another episode of “Surviving and thriving with the SAP Cloud Application Programming Model” (#CAPTricks). Last time, we covered the wild and bumpy ride of getting your app up and running on your local machine, complete with all the twists and turns of talking to on-premise systems....
With the announcements in the SAP Data Unleashed, SAP introduced the successor of SAP Data Warehouse Cloud, SAP Datasphere – a powerful Business Technology Platform data service that addresses the Data to value strategy of every Enterprise organization to deliver seamless access to business data. Our Datasphere has been enriched with new features thereby delivering a unified service....
Extracting data in mass from SAP S/4HANA using custom CDS view has multiple use cases. In this blog, let’s look at the steps for creating a custom CDS (Core Data Service) view that is enabled for data extraction with associations, using the Custom CDS Views application. Prerequisite: – To open the Custom CDS View app, the....
After implementing the next tutorial BTP Onboarding: SAP HANA Cloud, as the best step by step tutorial that i found, i would like to share my experience in what i really did in a quick way since i created the HANA instance until i opened my SQL console at first time, so you will win a....
As SAP HANA Cloud is a modern database as a service (DBaaS), the end users can access SAP HANA Cloud from anywhere with public internet, whether that’s at home, in the office, or even at a third space like a coffee shop. When an organization wants to move to SAP HANA Cloud, the authentication method....
There are a number of wonderful blog posts here on the SAP Community talking about how you can get started with SAP HANA Cloud Document Store, and what you can do with it For this blog post, I wanted to meet absolute beginners where they are: Introducing the design considerations behind using the more familiar Relational (Row and Column) Stores Discussing....
こんにちは。SAP HANA ODBC Driverを利用してデータ通信の設定する際に、プロキシの情報ってどこで設定できるの？という疑問にお答えします。 今回は “Connect setting the SAP HANA ODBC Driver” の手順に沿って HANA ODBC Driverの設定し、Step 1の途中でproxy等の追加情報を設定する方法をご紹介します。 事前準備 “Connect setting the SAP HANA ODBC Driver” の事前準備 (Prerequisites)として書かれている下記3つのチュートリアルを完了する。 ①Choose an SAP HANA Database ②Install the SAP HANA Client ③Create a User, Tables and Import Data Using SAP HANA HDBSQL “Connect setting the SAP HANA ODBC Driver”....
This brief is to demonstrate how one can leverage selected SAP BTP Kyma runtime serverless features, namely how to use standard sap libraries to access secrets mounted as volumes how to use SAP HANA Cloud with functions using @sap/hana-client library and other standard SAP libraries Previously demonstrated topic was: how to override a base function image Requirements....
This is the how-to from the more business context post on Linked-in on how I calculated my Carbon Emissions from travelling using Garmin and Strava data. The Process is essentially: The data I am using for this V1 of the analysis comes from my Garmin watch (or used to be iphone), but essentially all the....
Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions related....
In the previous blog post, I introduced the topic of fiscal calendars in SAP Datasphere. The blog post also explained one way to generate such calendar, namely by leveraging an SAP source system fiscal calendar using an existing built-in procedure in SAP Datasphere. In this blog post I will introduce another way to generate a fiscal....
A new playlist about SAP Business Technology Platform (BTP) serverless functions has been made available on our YouTube channel. Video tutorials by Philip MUGGLESTONE for the SAP HANA Academy and Partner Ecosystem Success. In this article you will find the videos embedded with references and additional information. A prerequisite, as covered in the first video of this series, is....
Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions related....
As an Integration developer, sometimes you may use same sub-process or process multiple times and sometimes the same subprocess is required to use in another Integration process. For this kind of situations, we can handle via below approach. There may be multiple Integration processes in one single main Integration process (In one Artifact). Motivation:....
Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions related....
In many companies the business application system landscapes over time have become very large and extremely complex. This scale and complexity slows down innovation, because even a small change can have a huge impact on the whole system landscape. The impact could be business process related, so extensive testing in all affected systems is required.....
In this part , we will be discussing about deployments in SAP HANA Cloud . We will be explaining the following : Spotify Developer Access Set up & Configuration Understanding Spotify APIs – Testing from the site directly Scenario 1 – Python Scripts for Playlists , Audio features& Explanation JSON Documents....
In the first blog in this series, we looked at how the HANA platform’s capabilities reduce technical debt and complexity by eliminating the need for ETL when integrating your SAP S/4HANA and ArcGIS Enterprise systems. In talking to a number of utilities, they have described their frustration with a file based interface between the two most important....
Thomas Hammer last week wrote a blog introducing new features available with Q4 2022 release of SAP HANA Cloud. I would like to also mention some enhancements done for SQL query execution for 2022 overall. If you have been using the recent SAP HANA Cloud versions, you may have noticed improvements in execution time while using less memory....
In Earlier Versions of HANA, to improve performance of the Model/Calculation view, it was suggested to stage the data in some physical table using a procedure and then create the calculation view on top of that staging table. This help us to fetch huge amount of data quickly as there are no calculations involved.To Avoid....
Goal : This blog explains to add the service plans, assign the roles and create the instance for Automation Pilot in the Business Technology Platform (BTP). This blog focusses on usage of Automation Pilot with respect to SAP HANA Cloud. There are two approaches in order to add the service plan to your subaccount, the traditional approach....
Within the time frame of 2022 QRC4, several new calculation view features have been released in SAP HANA Cloud that can be used with SAP Business Application Studio. Some of these features are highlighted below. You can find examples that illustrate the individual features here. An overview of features of other releases can be found here. Filter....
If Google Vertex AI is part of your landscape, you might enjoy the option to use your familiar Google Cloud environment to trigger data processing in your SAP Data Warehouse Cloud / SAP HANA Cloud systems. Connect from Vertex AI (or other Google components) to the data in SAP Data Warehouse Cloud / SAP HANA Cloud and carry out data explorations,....
This blog provides the command to start and stop the SAP HANA Instance and also schedule to do the same in a timely manner. This blog aims to provide an approach on how one can automate the uptime of a SAP HANA Cloud instance which reduces operational costs. Scheduling the HANA Start/Stop sample shows how....
This blog provides the command to start and stop the SAP HANA Instance and also schedule to do the same in a timely manner. This blog aims to provide an approach on how one can automate the uptime of a SAP HANA Cloud instance which reduces operational costs. Scheduling the HANA Start/Stop sample shows how....
Do you need to report based on fiscal periods, and require KPI’s such as a rolling fiscal year, or fiscal Year to Date? Does your fiscal year deviate from a calendar year? If you are using SAP Datasphere with SAP Analytics Cloud or a 3rd party reporting tool, then this blog series will help you....
In this beginner blog post we are going to see how we can use #CHANGE_SET (Change Set Processing) in ABAP Restful Application Programming Model. Update multiple records at once using RAP Use Case: Change Set processing can be used when there is requirement to operate on multiple records with single Action example in list....
SAP Alert Notification service for SAP BTP offers a common API for providers to publish alerts and for consumers to subscribe to these alerts. It is designed to send automatically real-time notifications and alerts about events that may be of interest to the business and operations. Read more on SAP Alert Notification Service Purpose This blog....
The aim of this blog is to show how to do real-time replication from one SAP HANA Cloud instance to another. With applying of the latest development technologies, I will build an interesting scenario that will integrate between two cloud instances in such a way that when the data in the original table located in....
This brief is to demonstrate how one can leverage selected SAP BTP Kyma runtime serverless features. This instalment covers: how to override a base function image Requirements and Disclaimers: https://github.com/SAP-samples/kyma-runtime-extension-samples/tree/main/kyma-serverless#requirements-and-disclaimers Sample code: Power of serverless with SAP BTP, Kyma runtime code sample hana-cloud gist Putting it all together. SAP BTP, Kyma runtime is SAP’s fully....
In this blog post, you will learn ‘How to create User Provided Services’ in SAP HANA Cloud Business Application Studio. In recent years, after introduction of Business Application Studio(BAS) for HANA cloud modelling, developers are struggling to create a ‘User provided services’ to access the underlying tables persisted in any schema (post replication) or any....
Over the last few months, Sanraj Mitra, Shetty Vriddhi and myself have been working on a product inspection solution combining SAP solutions with external technologies. Product inspection is a key part of quality assurance where goods are assessed for compliance with the company’s standards. Due to the wide range of checklists for each product, this often is a complex procedure.....
SAP HANA Cloud provides several built-in algorithms to process data. Custom logic can be implemented in SQL script and executed in procedures or functions. Apart from that, procedures and can leverage more advanced capabilities from the so called Advanced Processing Engines (like the Machine Learning, Graph and Spatial engines). How can a procedure be exposed....
SAP HANA has well known Row and Document Stores, allowing us to store relational data in Tables and process that data using HANA’s various engines including graph and spatial SAP HANA actually offers a third store – the JSON Document Store. With the SAP HANA Cloud Document Store (DocStore), we can store JSON Documents in Collections within HANA itself, then process that data using the same SAP HANA engines....
Within SAP HANA Cloud, we have the ability to activate the JSON Document Store (covered here). In this blog post, we’re going to walk through some of the technical details around how we interact with the SAP HANA DocStore JSON Collections While the Column and Row Stores use Tables to store data, the Document Store uses a JSON Collection Just like Tables, our Collections are created within a given schema. There are no Document Store specific....
For SAP Business Technology Platform (BTP), the btp command-line interface (CLI) is the alternative to the SAP BTP Cockpit for all users who like to work in a terminal or want to automate operations using scripts. With the btp CLI you can execute both account management operations and service management operations. The btp CLI documentation provides details and there....
In December 2022 SAP held a machine learning competition called “I quit!” attended by 50 participants to showcase the machine learning capabilities of SAP HANA Cloud. The idea is to predict from a database of employees who is the most likely to be quitting his or her job in the short term, based on historical information of....
(January 2023: this material can now be found in the help at Map an SAP HANA Database to another Environment Context | SAP Help Portal, including command-line instructions) SAP Business Technology Platform (BTP) applications looking to store their data in SAP HANA Cloud typically do so using a HANA Cloud schema or HDI container, which is....
SAP BTP Developer onboarding for SAP HANA Cloud. Entitlements, provisioning, configure instance mappings and create HDI containers in the Cloud Foundry and Kyma environments. Tutorial video embedded with references and additional information. For the main article, see SAP BTP Developer Onboarding | Hands-on Video Tutorials Anything to add? Leave a comment below. Useful? Give us....
We all know the world is evolving. So is SAP. 🙂 In the era of SAP ECC, there used to be Workflow builder (Transaction Code – SWDD) which ties together all the workflow component and the approval cycle very tightly with all the building blocks. SAP HANA came up with yet better solution design for generalized....
Ever since I came across ChatGPT, I’m in complete awe. For those of you who don’t know what it is is, ChatGPT, which stands for Chat Generative Pre-trained Transformer, is a chatbot developed by OpenAI. ChatGPT is built on top of OpenAI’s GPT-3.5 family of large language models, and is fine-tuned with both supervised and reinforcement....
皆さん、こんにちは。今回はHANA CloudとSAP Analytics Cloud (以下、SAC) を使って、HANAのデータに行レベルでデータアクセス制限をかける方法についてご紹介します。 SACのユーザーとHANA Cloudのアクセスユーザーは別々に各システムで設定し、HANA Cloudでユーザーテーブルを作成しマッピング作業が必要なことに注意しましょう。 前提条件 ブログの手順に沿ってSACとのSSOを設定したユーザーを作成 データの入ったテーブル T1と、T1をSACから見るためのCalculation Viewとして、CV_T1_second を事前にHANA Cloudに作成。T1 は下記のようなテーブルです。IDは日本の都道府県コードが入っています。 手順 ①BASでHANA Cloudプロジェクトを作成 プロジェクトの作成方法についてはこちらのブログを参考にしてください。 ②ユーザーテーブルを作成 HANA Cloud Database Explorerを使って、ユーザーテーブル USERSを作成します。運用上の観点から、ユーザーテーブルはBASのプロジェクト作成時に自動生成されるHDIコンテナとは異なる HDIコンテナの中にUSERSテーブルを作成しすることにしました。BAS ProjectのHDIコンテナと異なる場所にあるテーブルのデータへアクセスする方法はこちらのチュートリアルを参考にしながら、ユーザーテーブルへアクセス権があるユーザーに対してのUser Provided Serviceを作成してください。 USERSテーブル ②プロシージャを作成 BASのテンプレートを使用してプロシージャ Test_row_HDI.hdbprocedure を作成し、下記のように変更します。３行目の権限がDEFINERになっているか確認してください。 PROCEDURE "Test_row_HDI"( OUT sql_expr NVARCHAR(50)) LANGUAGE SQLSCRIPT SQL SECURITY DEFINER --DEFAULT SCHEMA <default_schema_name> READS SQL DATA AS BEGIN SELECT....
Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions related....
Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions related....
Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions related....
Before Driving deep into Technical details . let me give some brief about why we need to do this ABAP Development Tool (ADT) is an Eclipse based tool provided by SAP, You will need ADT if you have to work on the ABAP CDS views. Even though,CDS views are emdedded into the ABAP Dictionary, there....
Good news for the SAP architect! Packt just published Architecting Solutions with SAP Business Technology Platform, an architectural guide to integrating, extending, and innovating enterprise solutions using SAP BTP (October, 2022). In this post, a brief review. === Like to get your book published too? For a road map, see SAP PRESS Authors Survival Guide |....
Before Driving deep into Technical details . let me give some brief about why we need to do this ABAP Development Tool (ADT) is an Eclipse based tool provided by SAP, You will need ADT if you have to work on the ABAP CDS views. Even though,CDS views are emdedded into the ABAP Dictionary, there....
Introduction Here I am just explaining the Importance of Groovy script in the Real time scenarios when we are dealing with Cloud Integration. Groovy scripting is an integral and important feature of SAP Cloud Platform Integration (CPI). The goals of this repository are: Providing templates when you are implementing a new script. Easily finding Groovy functions....
This will be a blog series, we will see how to build Nodejs-based applications using Multi-tenant capabilities offered by SAP Business Technology Platform(BTP) to build extensions. Context When developing tenant-aware applications in the Cloud Foundry environment, keep in mind the following general programming guidelines: Shared in-memory data that may be available to all tenants. Avoid....
We are using below standard SAP integration solutions SAP Data Intelligence Cloud, Integration and Data Management, SAP Data services. Enterprise Data Management Solutions SAP HANA Smart Data Integration(SDI) To integrate data from diverse systems (data integration) data orchestration services… etc We are using HANA Cloud Database Technical User for few integration scenarios What is....
Some of our asset intensive customers, like utilities, who are implementing ArcGIS on HANA with SAP ERP have asked me: how do the pieces fit together and where can I read about this in one place? While the value that the HANA platform brings to ArcGIS Enterprise is based on the same capabilities that HANA....
SAP HANA Cloud has recently been enriched with a new Automated Machine Learning (AutoML) approach. AutoML can be helpful for many different reasons, for example to give a data scientist a head-start into quickly finding a first machine learning model. Also, it is a great starting point to see what is possible with the data....
This is the second blog for my Blog series “Architecting Complex Real Life Business Scenario on SAP BTP with ease [ Targeting Multiple backend S/4HANA System utilizing Principal Propagation]. In my previous blog, we have discussed in detail from the Business Perspective, I would be discussing about detail Technical Architecture in this blog. Next blog is about the actual....
This Blog explains how you can leverage native SAP HANA development artifacts with CAP. In particular we look at the use of Calculation Views, inside Cloud Application Programming (CAP) Applications. This includes OData access to Calculation Views. Solution: Pre-requisites: Set Up SAP Business Application Studio for Development Launch the Business Application Studio (BAS) and choose Create Dev Space NOTE:....
本ブログでは、SAP S/4HANA(以下、「S/4」) と SAP HANA Cloud (以下、「HANA Cloud」) とのデータ連携の設定について解説します。 S/4とHANA Cloud の連携のシステム構成図は下記の通りです。 機能概要と設定手順解説 本Blogでは下記の動画にて設定方法をガイドします。 ※ 画面サイズを調整する場合は、再生時に画面右下に表示されるYouTubeロゴをクリックして別画面でご確認ください。 また、動画中に出てくる関連情報/補足情報を下記にまとめていますので併せてご確認ください。 関連情報 SAP HANA Smart Data Integration – SAP HANA Cloud との接続 SAP HANA Cloud, SAP HANA Database Data Access Guide – Supported Remote Sources SAP HANA Smart Data Integration – Installation and Configuration Guide – SAP ABAP....
Problem: SAP HANA Cloud uses BTP services and service keys. There might be the need to update the service-keys. Solution: Warning: This is advanced scripting and you could harm your configurations. Please test carefully with dedicated spaces before you are applying this to production instances. This includes also development environments/spaces. Writing a script that automates....
Marketing campaigns need to be relevant for the recipient, and worthwhile for the sender. It is not worth sending a promotional offer about a product or service if you know that your customer will buy it anyway. It is not worth calling a subscriber to persuade him to maintain his subscription if you know he....
There are a lot of things you can parameterise on JAVA connection as well as on the connections pool. Some of the parameters support the communication with database or the caching behaviour and others influence the management of connections. Each case is different and you have to bring some experience as well as experiments to....
本ブログでは、SAP Business Technology Platform (BTP) の Free Tier サービスでの SAP Data Warehouse Cloud (DWC) のインスタンス作成方法について解説します。 Free Tier は言葉の通り、無償で利用可能なBTPのサービスです。 ※ BTPのFree Tier の始め方はこちらのブログに分かり易くまとめられているので参考にして下さい(KATO Mino さん、ありがとうございます)。 何と言っても、SAP S/4HANAとのデータ連携を試すことができるので、まずは色々と悩む前に、色々と試して手応えを感じていただけたらと思います。その環境をそのまま有償版に切り替えることが可能で、検証/評価やPOCで作成した成果物をそのまま本番環境として利用することも可能です。 設定手順解説 本Blogでは、下記の動画にて設定方法をガイドします (動画時間:約8分)。 ※ 画面サイズを調整する場合は、再生時に画面右下に表示されるYouTubeロゴをクリックして別画面でご確認ください。 注意事項 Free Tier での DWCは、稼働環境のリソース制限 (メモリサイズ : 64GB, ストレージサイズ : 128GB) や連続利用期間の制限 (90日間)、使用可能な機能の制限(下記、関連情報参照)があります。 ※ 基本的な操作確認や機能確認には十分かと思います。 関連情報 Free TierではじめるSAP Data Warehouse Cloud BTP環境でのSAP Data Warehouse Cloud インスタンス作成....
In the 2022 QRC3 release of HANA Cloud, the data lake relational engine is releasing a major new feature that will change the TCO profile for the relational engine and provide improved performance in a variety of areas. What is this change? As you may know, the HANA Cloud, data lake relational engine was based....
SAP Data Warehouse Cloud (DWC) の基本操作について解説します。 本ブログの内容は、SAP Business Technology Platform (BTP) の Free Tier サービスを利用して解説しますが、もちろん、本番(有償)環境でも実行可能です。 サンプルのCSVデータを用意したので、DWCの本番環境/検証環境で操作を憶えつつ、自社のデータを使ってモデリングを進めていただけたらと思います。 本内容を試す場合はDWCの環境が必要です。下記のブログを参考にDWCのインスタンスを作成してください。 ・BTP の有償環境でSAP Data Warehouse Cloud インスタンスを作成する ・BTP の Free Tier 環境でSAP Data Warehouse Cloud インスタンスを作成する ※ DWCをサブスクリプションライセンスで購入されたお客様はインスタンス作成の作業は必要ありません。 操作手順解説 本ブログでは、下記の動画にて操作方法をガイドします (動画時間:約18分)。 ※ 画面サイズを調整する場合は、再生時に画面右下に表示されるYouTubeロゴをクリックして別画面でご確認ください。 操作の流れ 動画の内容は下記の通りです。 1. スペースの作成 2. テーブルの作成 3. ビューの作成 (モデリング) 4. ストーリー(ダッシュボード)の作成 ....
This blog post is part of a series on SAP Data Warehouse Cloud and SAP HANA Cloud CI/CD. I recommend checking follow-on blog “SAP Data Warehouse Cloud SAP HANA Cloud HDI Automation CI/CD Pipelines Details” for implementation details, including a code walkthrough. Introduction In this blog post, I’ll go over a lifecycle management approach for an....
This is a BTP blog series, where we will discuss the right way of S/4 HANA implementation and … Why we should adopt Keep-Core-Clean (S/4 HANA) approach How SAP BTP helps to keep-core-clean (S/4 HANA) & What a Business can achieve with keep-core-clean (S/4 HANA) In the first blog of this series, we will discuss each topic above at....
This blog post is part of a series on SAP Data Warehouse Cloud and SAP HANA Cloud CI/CD. Before reviewing the details in this blog post, I recommend checking “SAP Data Warehouse Cloud, SAP HANA Cloud HDI CI/CD Automation Approach” for an overview of the use case scenario, toolset and concepts. Introduction This blog post....
The SAP Business Technology Platform (BTP) Developer Onboarding video tutorial series from the SAP HANA Academy has just been completely revised and updated for the 2022 season. In this series of articles you will find videos embedded with references and additional information. For the main article, see SAP BTP Developer Onboarding | Hands-on Video Tutorials....
For those of you who enjoy using SAP Data Intelligence Cloud (SAP DI Cloud) for data management, integration and processing, and are wondering how it can be integrated with SAP Profitability and Performance Management Cloud (SAP PaPM Cloud). Well, you’re in luck because this blogpost will cover this topic, so just keep on reading! Scenario: A source table is created as an input for the View function. Note: The source table....
SAP Partners, heads up! The Q4 schedule for the Partner Certification Academy is now available. For the dates and to register go to SAP Community Groups > Partner Groups > SAP Business Technology Platform Partner Certification Academies for SAP BTP – Delivery schedule SAP Learning Free SAP Online Courses Last year, at SAP TechEd 2021, the....
This simple blog post helps you get an understanding of how data from an SAP S/4HANA on-premises system can be Analysed using SAP Analytics Cloud which is connected using Data Warehouse Cloud in SAP Business Technology Platform (BTP). This blog post covers – Connectivity of SAP S/4HANA On-premise system to SAP Data Warehouse Cloud. Creation....
This simple blog post helps you get an understanding of how data from an SAP S/4HANA on-premises system can be Analysed using SAP Analytics Cloud which is connected using Data Warehouse Cloud in SAP Business Technology Platform (BTP). This blog post covers – Connectivity of SAP S/4HANA On-premise system to SAP Data Warehouse Cloud. Creation....
I was going through the blog by Vishwa Gopalkrishna about the CI/CD automation approach for hybrid developments focusing on HDI container-based developments for SAP HANA Cloud & Space level Developments within SAP Data Warehouse Cloud .My blog would be a pre-requisite for the automation approach and would provide the hands-on and step by step tutorials for accessing SAP....
“Every company will become a technology company, and every company will become a data company” – Steve Brown ‘The Innovation Ultimatum’ Please read PART1 In SAP world, almost every company intended to use S/4HANA as their digital core. But to run any sort of business, many companies also need various other SAP and non-SAP systems/SaaS solutions. (On....
Summary: Hierarchies are one of the most important elements in SAP BW which provides the Business users flexibility to navigate the hierarchy structure in the Frontend Reports. At times, a need arises where we need to flatten the hierarchy structure because of the business requirement in order to display only certain levels of hierarchy in....
Introduction In this 2 part blog series, I will demonstrate on how you can create a full fledged youb application using Micronaut framework using groovy programming language. Micronaut is a cloud native JVM framework targeted specifically at creating microservices for the cloud. Micronaut has extremely fast startup time, leaves low memory footprint and very easily....
DBスキーマ内のDBオブジェクト (テーブルやビューなど) に対して、HDI( SAP HANA Deployment Infrastructure) コンテナーからアクセスする方法について解説いたします。 対象者は「SAP HANA Cloud(以下、「HANA Cloud」 )の基本的な操作を理解している方」になります。 ※ 実際に下記の手順を試す場合は、こちらのBlogの内容で事前に環境を準備してください。 HDI コンテナー内でテーブル定義もCalculation View 定義もその他の定義ファイルも全部セットにしてDBアプリケーションを開発する場合は、基本的に今回の作業は必要ありません。 ただし、HANA Cloudのデータ連携機能を利用したり、シンプルなDBとして使用する際にはHDIコンテナーの仕組みを利用しない方がラクチンなケースもあります。 一方で、HDIコンテナーの仕組みが必要なケース( Calculation Viewを使用するなど) もあり、その際にはHDIコンテナーから通常のスキーマのオブジェクトにアクセスする設定が必要になります。 HDI コンテナーの独立性は恐ろしいほどに厳格なので、外部のリソースに対してのアクセスはDBエンジニアにとっては回りクドイ感じがしますが、SAP HANA Cloudの小粋で便利な機能を利用するためには必須の知識になるので、今回の「お作法」を知っておきましょう。 大まかな流れは下記の通りです。 1. スキーマ管理者がHDIコンテナーに対して権限付与 2. テーブルに対してのシノニムを作成(※) ※ シノニム : DBの用語でテーブルやビューに対して付ける「別名」のこと。「エイリアス」と言った方が分かり易いかもしれません。 具体的な設定の流れ 具体的な設定の手順は下記の通りです。スキーマ名やHDIコンテナーのスキーマ名なども確認しながら、大まかな設定手順の流れをイメージしてください。 1. HDIコンテナーに権限付与するための設定 (1) User-Provided サービスの作成 (2) 権限ファイルの編集と権限付与 2. シノニムの作成 1. HDIコンテナーに権限付与するための設定....
Introduction This is in continuation to the earlier post wherein I explained how can we deploye a custom Micronaut app written in Groovy to SAP Cloud Foundry BTP. Please read the earlier post here. In this part I will explain how we can use SAP HANA cloud as a persistence layer for the application. and how....
SAP Analytics Cloud makes it easy for businesses to understand their data through its stories, dashboards and analytical applications. However, sometimes we might not be sure how we can leverage SAC to create these based on data from other applications For this worked example, we’re going to make use of SAP Data Intelligence Cloud to retrieve data from SAP....
If Dataiku is part of your landscape, you might enjoy the option to use your familiar Dataiku environment to trigger data processing in your SAP Data Warehouse Cloud / SAP HANA Cloud systems. Connect from Dataiku to the data in SAP Data Warehouse Cloud / SAP HANA Cloud and carry out data explorations, preparations, calculations, and Machine Learning. The data remains....
Roles defined in SAP HANA Cloud using HANA Cockpit or HANA Database Explorer (SQL Console) are called Catalog based roles whereas roles defined using Business Application Studio (BAS) are called HDI roles. Catalog and HDI both have their own advantages and disadvantages, some of the key differences are as follows: Figure 1: Catalog v/s HDI....
This is Part Two of a blog series on Ariba Analytics using SAP Analytics Cloud, Data Intelligence Cloud and HANA DocStore. If you would like to start with Part One, please click here Recap SAP Analytics Cloud makes it easy for businesses to understand their data through its stories, dashboards and analytical applications. Our worked example is....
This feature is available and demonstrating how you can bring the data from BTP – SAP HANA Cloud Instance to SAP HANA Onpremise (SAP Commissions). It allows through DP Agent and managed instance to read data and execute commands against remote database source, for instance, HANA database server. Using this feature, we can fetch data and update it in other databases....
This is Part Three of a blog series on Ariba Analytics using SAP Analytics Cloud, Data Intelligence Cloud and HANA DocStore. If you would like to start with Part One, please click here Recap SAP Analytics Cloud makes it easy for businesses to understand their data through its stories, dashboards and analytical applications. Our worked example is....
Hello, Developers/Architects/Project Managers My name is Partha, I’m an “Architect-Developer“. Let me share some of my experiences and realizations. So far… I have been involved in multiple S/4 HANA implementations. One thing, I realized vividly and truly believe is that developers are the king in Software/Technology Industry! Let’s analyze the power of developers. For that purpose, I....
I would like to share with you a project I’m starting. The aim of this project is to generate easily a documentation for HANA database module. Motivation One of the projects I was working on has a lot of calculated columns in its calculation views. Therefore I needed to deliver a proper documentation about these.....
In SAP HANA Cloud, the database development artifacts are deployed from and to HDI containers. It is a common scenario in application development where the tables located in one HDI container have to be accessed from other HDI containers. For example, a specific application has tables and other database artifacts in an HDI container. If....
The SAP HANA Cloud 2022 QRC3 release is happening. You can read about the major enhancements in Thomas Hammer’s blog post here. This post describes one of the features: the abstract-sounding “multi-environment” support. Part 2 describes how to get started with the multi-environment SAP HANA Cloud tools. With the 2022 QRC3 release in October 2022, SAP HANA Cloud....
The SAP HANA Cloud 2022 QRC3 release is happening. You can read about the major enhancements in Thomas Hammer’s blog post here. This post is the second of a pair that describe one of the features: “multi-environment” support. Part One tells you what SAP HANA Cloud “multi-environment” support means and sketches the benefits it brings you. This companion....
Hello, Developers/Architects/Managers Thank you for your overwhelming responses to my last post on SAP BTP Roadmap – “Developer is the KING” I got lots of queries from many of you regarding the certification in SAP BTP. And that’s a good sign, it’s the right time to upgrade your skill set in SAP. Like : “Partha, I’m....
To gain more insights into the intermediate steps of calculation view processing often an option called “intermediate data preview” is used. The intermediate data preview is started by clicking on an intermediate node and choosing Data Preview. As a result the data output of the selected node will be shown. A typical Business Application Studio....
Analytic Privileges restrict the user to view sensitive data for which they are not authorized. It is used to enable data access in calculation views by filtering the data based on the values of one or more attributes. Figure1: Process Flow Business Scenario: User A, responsible to see sales data only for Sales Office/Region say....
Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace. You can find the features introduced in previous versions in my other blog posts. What’s New in the SAP HANA Database Explorer Visual Studio Code Extension Version 1.6 What’s New in the SAP HANA....
本ブログでは、Oracle データベースとSAP Data Warehouse Cloud (以下、「DWC」) とのデータ連携の設定について解説します。 Oracle とDWCの連携のシステム構成図は下記の通りです。 機能概要と設定手順解説 本Blogでは下記の動画にて設定方法をガイドします。 ※ 画面サイズを調整する場合は、再生時に画面右下に表示されるYouTubeロゴをクリックして別画面でご確認ください。 また、動画中に出てくる関連情報/補足情報を下記にまとめていますので併せてご確認ください。 関連情報 SAP Data Warehouse Cloud – データプロビジョニングエージェント接続の準備 SAP HANA Smart Data Integration – Oracle との連携 SAP Support Portal – DP Agent のソフトェアダウンロード SAP Development Tools – DP Agent のソフトウェアダウンロード SAP HANA Smart Data Integration – Product Availability Matrix (PAM)....
This is the second part of the blog series on working with cross HDI container access scenarios in SAP HANA Cloud. The main blog or part 1 can be found here. Please note that these blogs applies only to stand alone SAP HANA Cloud instance. Recap In SAP HANA Cloud, the database development artifacts are deployed from and....
This is the third part of the blog series on working with cross HDI container access scenarios in SAP HANA Cloud. The main blog(part 1) can be found here and part 2 can be found here. Please note that these blogs applies only to stand alone SAP HANA Cloud instance Recap In SAP HANA Cloud, the database development artifacts are....
Qualtrics allows users to create surveys and generate reports without much programming effort. we have faced many requests where customers want to connect Qualtrics in their BTP setup and get real-time feedback/surveys built in their application along with a reporting tool to understand the feedback surveys and take informed decisions in their projects. We implemented....
Interested to get SAP BTP certified? Here is a video tutorial series from the SAP HANA Academy to help you reach your goal. Get Certified – SAP HANA Cloud Development << this article Get Certified – SAP HANA Cloud Administration Get Certified – SAP BTP Extension Developer (Extension Suite) Get Certified – SAP Integration Suite Get....
If you are comfortable with Azure Machine Learning, you might enjoy the option to use your familiar Azure front ends to trigger data processing in your SAP Data Warehouse Cloud / SAP HANA Cloud systems. Connect from Azure to the data in SAP Data Warehouse Cloud / SAP HANA Cloud and carry out data explorations, preparations, calculations, and Machine Learning.....
This is part 2 of my previous post about a tool that can query and bulk-provision various SAP Data Warehouse Cloud artifacts. The previous post can be found here: link. Since the last post, the Python tool has been published as a repository on the SAP-samples GitHub organization and is available for download. Please keep in....
The series of blog posts is written by Frank Gottfried, Christoph Morgen and Wei Han together. Overview In this blog post, we’ll describe an end-to-end scenario, which demonstrates how to develop a SAP Cloud Programming Model (CAP) application in SAP Business Application Studio that leverages the machine learning capabilities (HANA PAL and APL library) from SAP HANA Cloud. Additionally, we’d like to showcase how....
This is the 2nd blog post of the “SAP Data and Analytics Showcase” series of blog posts. We recommend you to look into our overall blog post to gain a better understanding of the end-to-end scenario and use case which combine multiple capabilities of SAP Data and Analytics solutions. In this blog post, we will cover how to create....
Hello All, Welcome to the part 2 of my earlier blog post. The expectation here is your have gone through the Part 1 of the Blog Post and if you had not you can find the link below : – Create a CDS Entity in SAP BTP, Expose the Entity as an OData Service to....
If Databricks is part of your landscape, you might enjoy the option to use your familiar Databricks front ends to trigger data processing in your SAP Data Warehouse Cloud / SAP HANA Cloud systems. Connect from Databricks to the data in SAP Data Warehouse Cloud / SAP HANA Cloud and carry out data explorations, preparations, calculations, and Machine Learning. The data....
A big live style topic these days is finding the right balance, either your work-life balance or with yoga and mindfulness your inner balance. In Data Science this is not always so easy. There is quite often a natural imbalance, so we very often deal with such data sets. Let’s start at the beginning: What....
I once received a question to mark the production instance of a HANA Cloud Database in the database explorer. They wanted to have the exact same behavior as mentioned in this blog post, section “Visual Clues for Production Databases”: https://blogs.sap.com/2021/09/28/recent-innovations-in-the-sap-hana-database-explorer-q3-2021/ In the earlier on-premise HANA database and HANA Express version this was automatically available without....
Interested to get SAP BTP certified? Here is a video tutorial series from the SAP HANA Academy to help you reach your goal. Get Certified – SAP HANA Cloud Administration << this article Get Certified – SAP HANA Cloud Development Get Certified – SAP BTP Extension Developer (Extension Suite) Get Certified – SAP Integration Suite Get....
今回はPart.4 SAP Analytics Cloudでの システム設定 / モデル作成 / 地理マップの作成についてご紹介します。 手順 全四回でご紹介する手順は下記の通りです Part.1 SAP HANA Cloudでの コロプレス/ドリルレイヤを使用するためのセットアップ Part.2 SAP HANA Cloud での カスタム地理階層の作成 Part.3 SAP HANA Cloudでの 分析用データの準備 / SAP HANA Cloud の Calculation View の作成 Part.4 SAP Analytics Cloudでの システム設定 / モデル作成 / 地理マップの作成（今回） 手順の全体像はこのようになっています。 それでは Part.4 を始めましょう！ Part.4-1 SAP Analytics Cloudでの システム設定 SAP Analytics....
今回はPart.2のカスタム地理階層の作成についてご紹介します。 手順 全4回でご紹介する手順は下記の通りです Part.1 SAP HANA Cloudでの コロプレス/ドリルレイヤを使用するためのセットアップ Part.2 SAP HANA Cloud での カスタム地理階層の作成（今回） Part.3 SAP HANA Cloudでの 分析用データの準備 / SAP HANA Cloud の Calculation View の作成 Part.4 SAP Analytics Cloudでの システム設定 / モデル作成 / 地理マップの作成 手順の全体像はこのようになっています。 それでは Part.2 を始めましょう！ Part.2 SAP HANA Cloudでのカスタム地理階層の作成 標準地理階層（Default Geographical Data）の確認 SAP_FPA_SPATIAL_CUSTOM_REGIONS_Z.Z.Z.mtar のインポートで利用可能になる標準地理階層の確認をおこないます 1.SAP HANA Database Explorer を使用して....
Database Upgrades & Patches is now easier! Previous Article : SAP HANA Cloud Database Upgrades and Patches – Part 1 Follow the steps for Patch & Upgrade update Once you click on Notification icon, you can see upgrade or patch information available for you to take a action.. you can select first, Apply Patch and later select for Upgrade with....
There are tons of different ways how you can performance traces on SAC for troubleshooting. In this blog I will talk about one of the tracing methods called (TIMELINE TRACES) that can be very helpful when there are performance problems being observed in SAP Analytics cloud (SAC) regardless if the connection is with BW or....
I am writing this blog post about Dynamic Joins in HANA. I found some blogs on Dynamic Join in HANA but they are confusing and did not give clear understanding what is exactly happening when we select Join as Inner join and then we make Dynamic Join as True. As of now just see the Picture....
I am writing this blog post on SAP HANA Input Parameters.There are few blogs on HANA IPs but they are not giving clear understanding. Here I am giving a basic example which will make the understanding easy for HANA developers. Those who are working on HANA for quite sometime and developed SAP HANA CVs they....
Hello Friends, I am writing this blog post on Calling a Table Function Inside a Stored Procedure OR Vice Versa in SAP HANA. As you all know scripted Calculation views are obsolete and Table function is the replacement for scripted CVs. in HANA 2.0 we have table function as a node too. Which means just....
SAP HANA Cloud enables your data-driven solutions to leverage cloud-native scalability, speed, and performance. SAP HANA Cloud also appeals to businesses extending their SAP applications with adjacent non-SAP scenarios. A great example of extending transactional applications is the use of spatial data. Companies that utilize both transactional and spatial data can gain more insights from....
Transmission line repair GEF is integrated into SAP Plant Maintenance. GEF allows Plant Maintenance users to do their tasks using a map – regardless of whether the customer is running SAP ERP Central Component (ECC), SAP Business Suite powered by SAP HANA (Suite on HANA), or SAP S/4HANA. The benefits of geospatially enabled business processes....
Background After installed ADT, added the related plugins, and deployed abapGit onto SAP dev environment, My next task was to connect my BTP Subaccount to On-Premise SAP Dev system. I browsed many blogs and read SAP help but I have been in trouble to get two-way connection between SAP Cloud and SAP On-Premise system by....
As our customers adopt SAP Data Warehouse Cloud, we often need to help them set up new users for both training and productive use. This can be a significant administrative task when there are many users, spaces, connections, and shares needed for each user. NOTE: SAP provides the SAP Data Warehouse Cloud command line interface (CLI) for....
This blog shows an example application combining SAP AppGyver with the spatial engine of SAP HANA Cloud by making use of GeoServer on BTP as a middleware. Everything has been done on the free tier and can be replicated without involving any license costs. Fast Food Finder: Fill your belly with SAP AppGyver and SAP....
SAP HANA (HANA Cloud , HAAS ..) offers comprehensive functionality to safeguard your database i.e. SAP HANA offers automatic Backup to back up your database and ensure that it can be recovered speedily and with maximum business continuity even in cases of emergency. The recovery point objective (RPO) is no more than 15 minutes. A full backup....
SAP Cloud Connector serves as a link between SAP BTP applications and on-premise systems. Runs as on-premise agent in a secured network and provides control over on-premise systems and resources that can be accessed by cloud applications. In this blog, you will learn how to enable cloud connector for HANA Cloud Instance, install and configure the cloud....
Some time ago I wrote about a way to quickly load data from CSV files into SAP HANA table using hana_ml Python package. It became quite a popular post. But it does require running some code to get a file loaded. Recently I was asked if that hana_ml functionality can be wrapped into some kind of UI and made available as an....
Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace. You can find the features introduced in previous versions in my other blog posts. What’s New in the SAP HANA Database Explorer Visual Studio Code Extension Version 1.5 What’s New in the SAP HANA....
I recently got this question on my desk and thought it might be interesting for others as well. An HDI “Container” has in total 3 base schemas and a couple of DesignTime- and RunTimer-user schemas for each Shared Key in BTP Cloud Foundry. <HDI Container> contains the run time generated objects <HDI Container>#DI contains the....
Introduction It’s been almost two years since my last post about XSUAA and therefore I thought it might be the right time to write about another topic that is happening in a lot of our applications within SAP IES (also known as SAP IT): distributed data. Just as a disclaimer. The content you see here is approximately one....
Let’s say that as a Modeler, you have successfully uploaded your data into SAP Profitability and Performance Management Cloud (SAP PaPM Cloud) and utilized SAP PaPM Cloud’s extensive modeling functions for enrichment and calculation. And as a result of your Modeling efforts, you now have the desired output that you would like to download from the solution. The question is: Depending on the number of records,....
SAP社が提供するノーコードツール SAP AppGyver を使ったアプリの作成例を3回に分けて ご紹介します。本ブログは第２回目となります。 SAP HANA Cloudからセッション情報などを取得したり、問合せ内容の登録ができる イベントガイドアプリをノーコーディングで作成しました。 SAP AppGyver上の操作をステップバイステップで記載していますので是非ご参考にしてください。 １．全体概要・準備・SAP AppGyverでのアプリ作成（画面遷移・データ参照） ２．SAP AppGyverでのアプリ作成（データ登録）←本ブログ★ ３．チャットボット機能の導入 Index １．はじめに ２．アプリケーションの構成図、利用サービス ３．準備 ４．SAP AppGyverでのアプリ作成（OData連携～データ登録～） ５．終わりに １．はじめに 本ブログでは SAP Inside Track Tokyo というコミュニティイベントのスマートフォン向け イベントガイドアプリをSAP AppGyverで作成しています。 このアプリでできることは以下となり、今回記載する内容は「問合せ機能」となります。 イベント情報の参照 イベントの概要 セッション情報 イベントの動画・投影資料 参加者ブログ FAQ イベントの参加登録 すぐにつぶやける（Twitterでハッシュタグ付き） 問合せ機能 チャットボットでセッション情報を参照する 「問合せ機能」、「チャットボット機能」以外は第一弾のブログにて記載しています。 第一弾のブログはこちら：SAP AppGyverで作る SIT イベントガイドアプリ(Part1) ２．アプリケーションの構成図、利用サービス このアプリの構成の内、今回紹介する部分は以下となります。 （他のAPIサービスなどを利用される場合はODataサービスの作成は不要です） SAP BTP, Cloud Foundry environment Node.js....
S/4 Hana Creating Custom Analytical Query And Publish As An App S/4 Hana Creating Custom Analytical Query is an app used for reporting and analysis. S/4 Hana Creating Custom Analytical Query offers the fields required to design a query. The user can select the required fields and set filters for the query. They can add restricted....
It was almost a year since my last Geospatial Tuesday post. That time it was how-to Import zipped shapefiles into SAP HANA Cloud using Database Explorer. But I still used an external tool called DBeaver to visualize data imported into SAP HANA Cloud. (And before that I even used ASCII to display spatial shapes from SAP HANA!) This time, I....
Within the time frame of 2022 QRC2, several new calculation view features have been released in SAP HANA Cloud that can be used with SAP Business Application Studio. Some of these features are highlighted below. You can find examples that illustrate the individual features here. An overview of features of other releases can be found here. ....
Interested to get SAP BTP certified? Here is a video tutorial series from the SAP HANA Academy to help you reach your goal. Get Certified – SAP BTP Extension Developer (Extension Suite) << this article Get Certified – SAP Integration Suite Get Certified – SAP HANA Cloud Administration Get Certified – SAP HANA Cloud Development Get....
A new SAP Tech Bytes series is starting today. In this blog post, I will share what is covered in the video that was release today (2022-06-27) and the videos that will be released in the next couple of weeks. The SAP Audit Log service is a platform service which stores all the audit logs....
さて、SAP AppGyverの記事です。 本日は画像データの取り扱いについて解説したいと思います。画像は。。。。賛否両論ありますが、HANA CloudのBLOB型に格納することにしましょう。 前提 今回は写真を撮ってHANA CloudのBLOB型カラムに格納するアプリケーションの作成について解説します。（次回は保存したデータを呼び出して表示するというアプリケーションを作成しようと思います。） カメラを使うのでスマートフォンにSAP AppGyver Previewアプリをインストールしてアプリを実行できるようにしておく必要があります。Web Previewでは実行できません。 前準備 Maxime SimonがCAPでSAP HANA CloudのテーブルをODataサービスとして公開するというブログを書いています。この解説の環境を利用することにします。まずは彼のブログの通り環境を作成し、ODataでデータを公開できることを確認して下さい。そして彼の解説に以下のエンティティを追加します。 schema.cds entity BlobTest : cuid { imagedata : LargeBinary; mimetype : String(100); } incidentService.cds entity BlobTest as projection on cloud.BlobTest; をservice IncidentService {....} 内に追加 また、今回SAP AppgyverからこのODataサービスを使用しますので、CORSを許可するために、srvディレクトリの下にserver.jsというファイルを作成し、下記を記述して下さい。 "use strict"; const cds = require("@sap/cds"); const cors = require("cors"); cds.on("bootstrap", app =>....
※この記事は前回からの続きものです。前回の記事で作った環境を前提としますのでまだの方はそちらをご参照下さい。 今回は前回HANA CloudのBLOB型カラムに格納した画像データをAppGyverアプリで呼び出して表示させる部分の解説です。 AppGyverアプリへの追加開発 ページの追加 今回は画像IDの一覧を表示して、それをタップすると画像を表示するという機能を作りたいと思います。同じページで作っても良いでしょうが、この機能のページを別に追加したいと思います。 GetImageというページを新規に追加します。 ついでにNavigationの機能でナビゲーションメニューにこの新しく追加したページを追加します。 これでスマートフォンの場合画面下部に表示されるナビゲーションメニューでこの新しく追加したページに移動できるようになります。 データリソースの追加 現状のAppGyverの仕様と思われる現象があり、前回定義したOData Integrationリソースでは思うようなデータを取得することが出来ませんので新規にREST API Direct IntegrationリソースとしてBlobTestのODataサービスを追加します。 今回は「GETBLOBTEST」という名前でREST API Direct Integrationリソースを追加します。ResourceURLはOData Integration リソースの時と違い、メタデータではなく/incident/BlobTestという実際のサービスを行うところまで入力する必要があります。 今回使用するのはGET COLLECTION(GET)だけです。 Resource key pathにはvalueと設定することを忘れないで下さい。(ODataリソースをREST APIリソースとして設定する場合は必要です。）そして Query parameterとして$selectを追加します。これは Is staticはTrueでValueとしてIDを設定して下さい。これでURLに?$select=IDが付与されて実行されることになります。IDカラムだけを取得するということになります。 TESTで実行してみましょう。 そしてSET SCHEMA FROM RESPONSEをクリックします。 最終的に設定されるスキーマは以下のようになります。 これでデータリソースの設定は完了です。 余談：REST API Direct Integrationで設定した理由 前回設定したODataリソースを使用しようとしたのですが、以下の理由で今回は断念しています。 ・$selectによるフィルタが現状のODataリソースでは出来なかった。 IDの一覧表示の場合はIDカラムだけのデータが欲しかったのですが、ODataリソースの場合この設定が出来ませんでした。 このためREST APIとして設定して回避しています。これは今後改善されると思われますのでこのブログ公開時点のものと考えて下さい。 テスト機能では$select指定が出来るのですが、実使用の際に引数を与えられないのが謎ですね。 変数の設定 この画面にPage variablesを設定します。 このようにテキスト型でImagedataとmimetypeを設定します。これはODataから受け取った同名のカラムの値を保持するものとして使用します。 画面とロジックの開発 画面は以下のようにシンプルな構成とします。 Scroll....
Now, here is an article on SAP AppGyver. Today I would like to explain how to handle image data. Images can be found at ….. There are pros and cons to storing it in HANA Cloud’s BLOB type column. Assumption In this article, I will explain how to create an application that takes a photo....
This article is a continuation of the previous one. This article assumes the environment created in the previous article, so please refer to that article if you have not yet done so. This time, I will explain how to display the image data stored in the BLOB type column of HANA Cloud using the SAP AppGyver....
Introduction When working with HANA Repository, you may be used to query the table “_SYS_REPO”.”ACTIVE_OBJECT” to get details about design-time objects. With HDI, the same information is now split by containers and you have to query 2 objects: the view M_OBJECTS the procedure READ_DEPLOYED For some use cases, it would be convenient to be able to query....
This blog is intended to provide some more understanding about SAP HANA NSE and its configuration. Design Principles of NSE SAP HANA NSE adds a seamlessly integrated disk-based processing extension to SAP HANA’s in-memory column store by offering a large spectrum of data sizes for an improved cost-to-performance ratio. It manages data without fully loading....
Philip MUGGLESTONE from the SAP HANA Academy just released a new series of hands-on tutorial videos introducing SAP Graph. In this blog post you will find the videos embedded with references and some additional information for the Administrator persona. For the introduction article about SAP Graph, see SAP Graph | Hands-on Video Tutorials For how to get started with....
SAP HANA Cloud is a true cloud product and an integral part of SAP BTP. In an on-premise set-up using SAP HANA XS classic, application development could be discussed and handled to a large extend within XS classic. For SAP HANA Cloud, XS advanced is the new and only way of building applications. This programming....
In HANA XS classic, to get access on all analytical privileges(classic AP) in the system _SYS_BI_CP_ALL can be granted to an user(directly or via a role), generally for developers/ HANA Admin. But in HANA cloud or XS advanced using HDI container there is no such analytical privilege exists for developers. Even though Developer has got the....
The latest release of the Automated Predictive Library (APL) introduces the capability to build several time series models at once from a segmented measure like Sales by Store for example or Profit by Product. No need any more to define a loop in your SQL code or Python code. Just tell APL what column represents....
This blog post is on usage of two powerful Nodes namely Hierarchy function and Minus Node in HANA Calculation view. Both Nodes are available in SAP HANA 2.0 XSA and HANA cloud. Minus and Hierarchy function Node are available starting SAP HANA 2.0 SPS01 and SPS03 respectively for on premise and available in SAP HANA....
Common machine learning scenarios such as fraud detection, customer churn, employee flight risk, aim to predict Yes/No outcomes using binary classification models. But sometimes the target to predict has more than just two classes. This is the case of Delivery Timeliness that can have three categories: Early/On-time/Late. From this article you will learn how to....
To follow-up with this blog post you must have read and completed the following previous blog posts in this series: Series introduction and preparation Jumpstart the CAP Project Import SAP SuccessFactors OData Services definitions Define the CDS Data Model Create the CAP Service Add Business Logic Prepare the UI with CDS Annotations Add Security Deploy....
If you are a JavaScript developer then you have multiple options and frameworks for connecting to and working with SAP HANA databases. It’s easy to be overwhelmed with too many options, some of which even seem to be overlapping in functionality. In this blog post series, I’d like to walk the reader through the assorted....
If you are wondering how to integrate a Standalone SAP HANA Cloud, Data Lake to your SAP PaPM Cloud then this blog is for you. Let me start with a bit of introduction of what SAP HANA Cloud, Data Lake is. There are two types of SAP HANA Cloud, Data Lake: Embedded SAP HANA Cloud,....
In this blog post I am going tp write about HANA Lead and Lag Functions. The functionality is same as SQL but I found it little weird while implementing this one 1 of the HANA Graphical calculation Views. Doing in scripted CVs it is pretty easy but while doing in Graphical HANA CVs these functions....
In the previous blog post in this series, we took a deep look at the two major different JavaScript modules that act as HANA Clients: @sap/hana-client and hdb. Architectural differences aside, let’s return to that sample usage of the @sap/hana-client we saw at the end of the previous blog post: import hanaClient from "@sap/hana-client" import * as xsenv from "@sap/xsenv" export....
Going back to our discuss in the previous blog post in this series about @sap/hana-client and hdb, the situation is now even more complex. @sap/hana-client supports promises, but hdb doesn’t. That’s just one of several differences between the two modules. There are also other functions like connection pooling or calling stored procedures that can be done in both @sap/hana-client and hdb, but perhaps could be made even easier with....
This is an essential article for anyone planning to use the Embedded Edition of SAP Analytics Cloud. The Embedded Edition is a slimline version of the regular Enterprise Edition meaning the only connectivity is ‘live’ and only to SAP HANA on SAP Cloud Platform. I describe several other important differences between the two editions and....
In this blog post series, we’ve explored several aspects of the HANA client tooling for JavaScript developers. In part one, we examined the differences between @sap/hana-client and hdb modules. In part two, we saw how to optimize our code using Promises / Async / Await. Then in part three, we looked at the value of additional wrapper modules like @sap/hdbext and....
はじめに 今回はHANA Cloudの地理空間情報(Spatial data)をSAP Analytics Cloud (SAC)の地図上に表示させる方法について紹介します！ 全4パートのブログを通して、下記のデータをHANA CloudにインポートしSACの地図上で可視化します 国 > 都道府県 > 市区町村 の3階層のカスタムヒエラルキー 人口・世帯数の分析用データ HANA Cloud の Shape fileを SAP Analytics Cloud (SAC)の地図上に表示させたい場合、HANA上でカスタムヒエラルキーを作成・登録し、SAC地理空間コロプレスレイヤ―として表示できるようにする必要があります。 今回はこちらのブログの手順を日本地図で行い、より詳細な手順について解説します。 前提 SAP Analytics上でのSAP HANA Cloudのライブ接続が作成済みであること (作成方法についてはこちら) 本手順は、SAP HANA Cloud バージョン 2022.16.15 (QRC 2/2022) および SAP Analytics Cloud バージョン 2022.16.1 で実施しています。バージョンが異なる場合は若干手順が異なる場合があります 手順 ご紹介する手順は下記の通りです Part.1 SAP HANA Cloudでの コロプレス/ドリルレイヤを使用するためのセットアップ（今回） Part.2 SAP HANA Cloud での カスタム地理階層の作成....
Data preview on intermediate nodes of a calculation view is a regular task while using HANA studio as a development tool. it is useful for debugging/troubleshooting data output at each node level of a CV. But after migrating to HANA XSA(On-Premise) or HANA cloud(Cloud platform) then you will need to use Web IDE for HANA(On-Premise)....
I am excited to share about our new mission published this week in the SAP Discovery Center, “Access, Share and Monetize Data with SAP Data Warehouse Cloud”. SAP BTP Startup program “Data-to-Value Track”, an initiative from SAP.iO is supporting startups to become a data provider by leveraging the Data Marketplace for SAP Data Warehouse Cloud. And this mission....
As a common effort of the HDI team here are some findings we made and manifested in blogs so that you should get a page for information that maybe in the documentation as well but here in condensed form to get a quick start or leverage approaches we see as useful. How to move....
Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace. This version included the database connection list and a SQL console for executing queries against a database. What’s New? Today, version 1.5 of the extension has been released to the Visual Studio Code marketplace.....
I am writing this blog post about Anonymous Block Do..Begin in SAP HANA WEB IDE with an simple example. We can write complex DML statements too but below example will give an idea on how to formulate and write Anonymous Block Do..Begin in SAP HANA WEB IDE. So what are Anonymous Block Do..Begin in SAP....
Use case: You are a HANA system administrator/developer and got to work on an Authorization issue in SAC/BOBJ reporting live model based on HANA Calculation view for a business user. The CV has several transactional and dimensional CVs used and It is hard to identify which object has analytical privilege issue. Example: In the above....
Photo by Geio Tischler on Unsplash The SAP HANA Client for Python as of now is only available for x86 Macs. While the client team is planning to release universal binaries, you can continue your work in Python also on the M1 by using Apple’s Rosetta technology. There are many descriptions out there, which explain how to run x86 Python....
Abstract Innovate your IT landscape with SAP Data Warehouse Cloud, which is SAP’s strategic target solution for all data warehousing use cases in the puplic cloud, in line with SAP’s data-to-value portfolio strategy. This blog post provides SAP BW and SAP BW/4HANA customers an overview of how existing on-premises investments can be converted to the cloud. More importantly,....
In this blog post I will demonstrate how to load Qualtrics Survey Data via a custom SAP Data Intelligence operator into a SAP HANA Cloud table for use in SAP Data Warehouse Cloud and SAP Analytics Cloud. I will show how solutions from unified data and analytics can be used together to get insights from....
“When the winds of change blow, some people build walls and others build windmills.“ -Unknown, An ancient Chinese proverb Introduction Dear friends, wish you all a very happy and wonderful new year. As i said in the last part, in this, we will deploy an sapui5 application for managing our test cases. Developing sapui5 applications....
You might have seen that SAP just recently released the first version of SAP HANA Database Explorer as a Visual Studio Code Extension. You can get that extension here: SAP HANA Database Explorer – Visual Studio Marketplace SAP HANA DB Explorer in VSCode Marketplace For those of us that do a lot of local development in....
The easiest way to get data into SAP Data Warehouse Cloud is to setup a connection to your data sources and retrieve the data from there. Though this is certainly the most common scenario, there are a few other interesting options on data ingestion covering different use cases, which I want to highlight in the....
Interested in getting certified as SAP Certified Associate for SAP Business Technology Platform (SAP BTP) solutions? In this post, you will find an overview with video tutorial embedded about how to prepare and pass the exam(s). For the articles about the video tutorial series, see Get Certified – SAP Extension Suite Get Certified – SAP....
Each year the Business Application Research Center (BARC) is conducting The Data Management Survey: The new survey on data management tools (bi-survey.com) and is collecting the feedback from the end users and implementation or consulting partners of Data Management solutions to present their findings and their view on the overall solution offering and portfolio of the different....
As of the QRC 02/2021 release of SAP HANA Cloud, data lake, you can query files in your data lake file container that contain structured data without ever having to load the data into a database. What is SQL on Files? SQL on Files is a capability of the Data Lake Files service in SAP HANA Cloud, data lake that allows....
As of the QRC 01/2021 release of SAP HANA Cloud, SAP HANA database, you can leverage LDAP authentication and authorization for your SAP HANA database users. When and why would I use this feature? You already knew that the Lightweight Directory Access Protocol (LDAP) is an open standard protocol that facilitates authorization between client applications and the....
Back by popular demand: If you missed this workshop series in March, you will get another chance to participate in May and learn hands-on about creating and optimizing calculation views in SAP Business Application Studio in a federated scenario using a trial of SAP HANA Cloud. Save your spot now – It’s free! May 18th – Session 1: How to set up an....
Picture this – you are the manager of a supermarket and would like to forecast the sales in the next few weeks and have been provided with the historical daily sales data of hundreds of products. What kind of problem would you classify this as? Of course, time series modeling, such as ARIMA and exponential....
本ブログではSAP Analytics Cloudヘルプに書かれている手順を基に、“SAP HANA Cloud”接続タイプとシングルサインオン (SSO) を使用したライブデータ接続の設定方法をご紹介します。45分ほどで完了する手順です。 SAP Analytics Cloud公式サイトにサポートされている接続先の最新の状況を公開しています。 前提条件 SAP HANA Cloud接続タイプは、Cloud Foundry 環境のみで機能します。Neo 環境 (SAP データセンタ) については、直接接続と SSO を使用した SAP HANA Cloud へのライブデータ接続 を参照してください。 SAP Analytics Cloudでモデルとストーリーを作成/表示するために、生成されたクエリで使用されるSAP HANA CloudデータベースのCalculation Viewへの読込アクセスが必要です。 アクセス権限の付与方法。 SAP Analytics Cloudでは、 CUBEタイプのCalculation Viewしかアクセスすることができません。dimensionタイプCalculation ViewやテーブルやSQL Viewにアクセスできません。Calculation Viewの作り方についてはこちらのチュートリアルをを参照してください。 SAML シングルサインオン (SSO) をSAP Analytics Cloudで有効にする必要があります。詳細については、カスタム SAML アイデンティティプロバイダの有効化 を参照してください。 接続を設定するには、SAP HANA CloudおよびSAP Analytics Cloudで管理者レベルの権限を持ち、SAML アイデンティティプロバイダを通じてSAP Analytics....
This post builds on top of the previous, but should help you as a reference without going through all previous posts hopefully too. In my SAP HANA database in the SAP HANA Cloud trial, I got four calculation views built: 3 dimensions Date_Dim, Item and Warehouse and 1 cube with the star join Inventory. In this post let’s see how to use the SAP....
Motivation As many of you I have on my SAP Business Technology Platform Trial account an instance of the SAP HANA Cloud Trial running. This trial instance is stopped everyday. Sometimes I am a little bit “angry” when I switch to my private workplace – enthusiastic to try out some stuff on SAP HANA Cloud Trial –....
SAP HANAデータベースにあるデータを外部に公開するユースケースではODataを使用することを推奨しています。 2019年からSAP では数々のプロジェクトで得た経験に基づいて、統一されたクラウドアプリケーションの開発手法Cloud Application Programming model (CAP)を構築し、提供しています。CAPは、サービス及びアプリケーションを構築するための言語、ライブラリ、ツールのフレームワークです。ベストプラクティスを凝縮し「ゴールデンパス」を提供しています。開発過程で繰り返し発生する作業に対して、すぐに使える豊富なソリューションに沿って開発者をガイドします。 CAPのプロジェクトでは、技術的な分野を掘り下げずに、ドメインに重点を置いて開発を進めることができます。 このブログでは、SAP Cloud Application Programming Modelを使用してSAPHANA Cloudにテーブルを作成し、そのテーブルをODataサービスとして公開します。この方法では、ODatav4.0を使用してデータを公開します。 ODatav2.0を使用してデータを公開する従来のxsodataメソッドとは対照的です。 参考リンク:Building hana-opensap-cloud-2020SAP Experience academy (SAP Internal)CAP Getting started guide 前提 SAP Business Technology PlatformアカウントでSAP HANA Cloudインスタンスを作成（トライアルでも可能） 開発環境の準備 HANA Cloudインスタンスがセットアップされ、開始する準備ができたら、サブアカウントでサブスクリプションを開き、SAP Business ApplicationStudioをクリックします。 新しいDev Spaceを作成します。 SAP Cloud Business Application テンプレートを選択し、開発スペース名を指定します。 ステータスが「開始中」から「実行中」に変わったら、開発スペース名の付いたタイルをクリックします。バックグラウンドで、Dev Spaceには、CAPアプリケーションの開発に必要なコンポーネントが用意されています。たとえば、ノードJSやCDSなど。Business Application Studioで開発すると、ローカルＰＣに何もインストールする必要がありません。 テンプレートからプロジェクトを作成 これで、Business Application Studioが起動、構成され、使用できるようになりました。 Welcomeタブで、[テンプレートからプロジェクトを作成]をクリックします。 @sap/capテンプレートを選択します。 プロジェクトにSAP HANA関連の機能を含めるには、[hana]チェックボックスをオンにします。....
As Solution Advisors, we often need to create custom datasets to support customer opportunities. We can create more engaging customer experiences if we had more realistic datasets that more closely resembled their own data. Ideally, we would be able to create a dataset of any size easily and able to specify constraints on the data,....
For Solution Advisors who occasionally receive customer datasets to analyze, running descriptive statistics to summarize, describe, and visualize the data is often the first step. In this blog, I will highlight two ways the hana_ml Python library can automatically generate visualizations your SAP HANA Dataset to help you quickly understand your data. These can serve as handy....
Machine Learning capabilities have been part of SAP HANA since the earliest version and have continuously evolved over time. These days, Machine Learning embedded in SAP HANA comes in two flavors: the Automated Predictive Library (APL) and the Predictive Analysis Library (PAL). While the automated Machine Learning of the APL targets especially developers and business analysts, the expert Machine....
Purpose I found accessing tables in HDI container using SAP BAS is a bit of tricky and have been juggling of how to use the form editor for synonym. Here is a tip for someone who might have been in the same dilemma as I have, or for who don’t want to spend time on....
Philip MUGGLESTONE from the SAP HANA Academy and the Partner Innovation Lab just uploaded a new series of hands-on video tutorials about SAP Business Technology Platform extension generators. In this blog post you will find the videos embedded with references and additional information. For the related blog posts, visit SAP BTP Extension Generators: Authentication and Authorization....
As Solution Advisors, we occasionally participate in POCs which require us to receive and analyze real customer data. Often, the first step to developing an analysis plan is to perform some exploratory data analysis on the data to determine the distribution of values and uniqueness of each column. Since we are dealing with real customer....
There are so many variables and external influences that can cloud our judgment and decision-making. That’s why, when you see someone who is truly confident in their decision, the reason is invariably: Data. Data provides confidence because it is objective and backs up new ideas with solid evidence. It helps ensure that decisions rise above....