Sara Sampaio

Sara Sampaio

Author Since: March 10, 2022

The company uses email authentication of staff to Linked Learning using Azure. There was a requirement to use the User ID (BizX ID) to update the course completion status from linkedin Learning into company LMS. So I had built interface to integrate LinkedIn Learning with LMS , do the necessary field mappings from Linkedin EmailID....

In my previous blog post, I have demonstrated how we can reset SAP password by just sending an email. But there were questions raised by many readers regarding UI, so today I will be explaining how we can beautify the user input. Our tool has now evolved to a semi-bot, you send an email and....

For all those SAP customers who have SF, C4C Service Center and CPI, who are experiencing problems with access to C4C Service Center and CPI, here is the solution along with my experience in solving this problem. THE PROBLEM You have C4C Service Center configured correctly and working, employees from SF can log in to....

Table of Contents Motivation Getting Started Setting Up Business Roles and Catalogs Administrator Role Flavor Builder Role Business User (Consumer) Role Creating UI Adaptation for Classic Application Managing UI Adaptations for Classic Applications Understanding Assignment Categories Using Software Collections to Transport UI Adaptations Using Restrictions to Assign UI Adaptations to Business Roles Consuming UI Adaptations....

Previous article – Introducing CAP to SAP Commissions This article describes how to consume file based approach using with CAP (Cloud Application Programming) for end users to see the report. There are several ways we can make use of CAP Application for the end users to see the real data. Download raw data from Commissions workspace as....

Previous article – SAP Commissions – CAP – Consuming Files based – Part 1 This article describes how to make a Fiori App for the end users to see the Payments report from your project. Note: you need to run the below cds command and start configuring as per below steps cds watch Go to File –  select New....

Have you ever been working on a project where you need some real-world geographical location dashboards to track ?? for example, say, how many incentives/commissions are generated through this particular location/city or how many sales reps are in this particular locality selling faster? OpenStreetMap is a great open-source map of the world that can give us....

前言 在进行计划预测时,我们经常使用“时间序列预测”功能来寻找一些关键 KPI 的演变规律,从而生成可以用以预测未来数值的预测模型。时间序列预测可以帮助帮助用户理解,这些 KPI 的变化是否存在某种规律,以及他们在某个特定月份是否倾向于更低的值(周期性分析)。 在一些情况下,被预测的 KPI 只和时间相关,因此仅依靠该 KPI 的历史值即可实现准确的预测。但有时,我们要预测的值不仅取决于时间,还与其他外部因素相关。例如,某公司产品的销售额在一定程度上与该公司在营销和广告上的花费有关,或者某一城市租用的自行车数量与该城市的天气和温度相关。 因此,在 SAP 分析云近期的更新中,我们将“影响因素”功能引入到时间序列预测模型中,使得时间序列模型的生成过程中,不仅可以基于历史值,更可以将其他外部影响因素的影响纳入模型的学习范围,从而生成更准确的预测值。在这篇文章中,我将向您展示如何使用“影响因素”功能,以从您的数据中获得更多见解,并提高预测的准确性。 场景 假设您在上海的一家自行车租赁公司工作。公司提供了一个计划模型,其中包含一个BikeHires测量值,表示每天的使用人数,以及与天气相关的几个测量值。您想基于预测计划来预测未来31天租用的自行车数量。在这种情况下,假设当前日期为2015年7月31日,这将允许我们将预测值与2015年8月实际产生的值进行比较。 如果要重新创建此示例,可以下载此数据集。请注意,列BikeHires, Temp.Min, Temp.Max, Temp.Mean, Humid.Min, Humid.Max, Humid.Mean 和 Rain将作为度量,其他列应视为维度。 基线预测模型 让我们创建一个“基线”预测模型,在不使用影响因素的情况下预测租用人数。我们将在 2015 年 7 月 31 日之后预测 31 个预测点,并从一整年的历史数据中学习,见下图。 如下图所示,我们配置一个观测项时段,时段大小为1年,截至2015年7月31日。 如下图所示,目前我们不添加任何的影响因素 对预测模型进行训练后,我们可以在预测建模报告中得到以下结论: 经过训练的预测模型的期望误差为93%。 当将预测值与实际值进行比较时,我们可以看到一些波动没有建模,一些预测值与实际值相差甚远。 共有7个异常值(预测值与实际值相差甚远的点)。 请注意,根据预测引擎的版本迭代,您得到的结果可能略有不同。 通过解释报告,我们可以看到预测模型在时间序列中发现了趋势和一些周期性模式。 这表明自行车租用量在一定程度上是由时间决定的。但我们认为,与天气相关的因素,如室外温度或降雨量,同样也会对自行车租赁产生影响。如今,我们可以利用“影响因素”功能,来验证是否有这种相关性。 利用影响因素改进预测模型 我们希望保留基线模型作为参考,并对改进的预测模型使用相同的设置,所以让我们使用“克隆”功能。 打开新创建的预测模型,向下滚动至设置的“影响因素”部分。让我们通过添加以下影响因素并训练预测模型来验证我们关于外部温度和降雨量对自行车租用产生影响的假设: Humid. Max 当日最大的空气湿度(%) Humid. Mean 当日平均的空气湿度(%) Humid. Min....

The Web Dispatcher component is used as a load balancer for http(s) across the SAP application servers. To achieve high availability of the SAP Web Dispatcher, Azure Internal Load Balancer (ILB) implements either the failover cluster (active/passive) or the parallel (active/active) Web Dispatcher setup. We will describe both scenarios and Azure Internal Load Balancer configuration for them. For internet facing communications a....

When we are doing HR or Bank related integration here main factor is data secure, so one of way is encrypt data using PGP keys. In this tutorial I am going to explore How to generate PGP Keys using Kleopatra Software How to Encrypt data using PGP Public key in SAP CPI How to Decrypt....

In the plant NMDC, we defined two storage locations, 0001 and 0003. They share the same warehouse number NM1.     We hope to achieve the following results:   If the goods are received to the 0001 storage location, different materials can be put on the shelf to the storage type 001 / 002 /....

就在最近,我们的同事 Junling Chang 使用SAP 分析云中的分析应用功能,开发了一个专为移动端展示而设计的移动应用demo。 我们先来看下这个demo,这是一个移动端上的仪表盘,展示的是业务用户比较关心的一些关键指标,这些指标会按照不同的主题来加以分类,包括财务、销售、生产和库存等四个不同的主题。用户可以在这四个主题间做切换,快速定位到自己所关心的那部分内容。   关于这个demo的详细内容,可以参考以下的这篇blog: 指尖上的业务分析助理 – SAP 分析云与企业微信集成案例   今天我们就以这个移动应用为例,来简单介绍下如何利用分析应用做有针对性的移动设计,以及设计过程中需要注意的一些点或经验。   1 – 为什么要使用分析应用 我们都知道,在SAP 分析云的故事中,已经可以使用响应式画布来做设计,而这些响应式页面已经支持在移动端实现自适应的展现。但是,使用故事的响应式画布,在实际应用中,还是会遇到某些限制,比如: 画布的自适应行为完全由系统来决定,单个微件(widget)会占据整个屏幕的宽度,无法有效利用屏幕的全部空间 不同微件之间不允许重叠,在页面设计上会有一定局限性,尤其是最终的界面美观 用户交互的方式比较有限 而如果采用SAC的分析应用,则可以利用更丰富的配置以及灵活的脚本语言,来做灵活的页面布局,更美观的页面设计,以及更多样的用户交互,从而在移动端实现更好的用户体验。 目前,分析应用已经支持在IOS的SAC移动app,或者在移动设备的浏览器上使用。对于安卓端的SAC移动app对分析应用的支持,也已经在开发的产品路线图上。 关于分析应用的更多详细信息,可以参考以下帮助文档: SAP 分析云 帮助文档 – 分析应用设计(分析设计器)   2 – 如何为移动端设计分析应用 应用的页面分为上下两个部分:   位于页面底部的切换面板,方便用户在不同主题间做内容的切换 占据大部分页面的主题面板,展示不同主题下的内容,主题面板也包括两部分: 页面上方固定位置的KPI面板,展示用户最关心的一组关键指标 页面中间的分析面板,用户可以通过手指的移动来展示更多内容 下面我们就依次来介绍下不同面板的一些设计细节。   2.1 – 切换面板   切换面板包含了四个区块,代表不同的主题(财务、销售、生产、库存),供用户做切换,每个区块占据25%的屏幕宽度。 在设计上,每个区块其实都包含了四个不同的微件: 图片,即不同的小图标 文本,主题描述,如“财务分析” 前景图形,用于用户点击 背景图形,用于标识当前选中的主题   这个切换面板占据100%的屏幕宽度,为了保证切换面板一直显示,将其高度设计为固定的11%的屏幕高度(可根据页面设计自由调整),并且在位置上,设置为从屏幕底部开始布局。   每个区块则占据25%的屏幕宽度,分别从屏幕的0%、25%、50%和75%处开始定位。....

When the dispute case was been closed, it’s been regarded can’t be changed anymore by users at the front-end. The user will get the below message when clicking the change icon: The FSCM system could set the status as ‘Closed’ (SCMG_T_CASE_ATTR-STAT_ORDERNO) and close the dispute case automatically while the disputed amount is updated as ZERO....

@BW/BI Transport Best Practices (use of TOC) : When transporting the BW objects it is always best practice not to move the original transport request to Quality in the initial stage when QA or testing not done. Because if there some issue found in the objects in testing, we do not have create a new....

Intent of this blog post is provide a working prototype for additional GOS service to upload multiple attachment together in one go. Business Requirement Some time it is difficult for users to upload 7-8 documents in GOS using the option ‘Create Attachment’, as the same steps needs to be repeated several times. So users require....

I have seen that some users are still not clear about how plan data import works or how it behaves in SAP S/4HANA Cloud – Finance. For this reason, I am writing this blog post, I would show you an example of a case where the mistake is common. Let’s call this Case X, below I....

A few weeks ago I started using  ATC at work So today I added ATC support to my visual studio code extension supports: running ATC on a single object (ctrl+shift+f2, like  eclipse) request exemptions show documentation

In früheren Blogs haben wir die SAP Data Warehouse Cloud, SAP BW bridge vorgestellt. Wenn Sie ein klassisches SAP BW System benutzen, können Sie ihre Modelle durch ein klassisches Migrations-/Konvertierungsprojekt in die SAP Data Warehouse Cloud, SAP BW bridge überführen. Für die Umstellung können Sie wie bei Konvertierung zu SAP BW/4HANA unter folgenden Ansätzen wählen. Neuinstallation = Greenfield-Ansatz....

In this blog post I will show how we can configure the SAP Analytics Cloud (SAC) Data Export API to access SAC planning data and integrate it with Data Warehouse Cloud (DWC) and SAP Data Intelligence (DI). The API provides OData and Cloud Data Integration (CDI) access for great integration with DWC and DI. CDI....

In this blog I wish to bring out the difference involved with implementing RISE with SAP S/4HANA,private edition against RISE with SAP S/4HANA cloud(essential edition) This blog is intended for those who have basic understanding of RISE and wish to understand a detailed difference between the public and private edition while using SAP Activate methodology.....

SAP provides TCODE SO50 to deal with inbound emails with customized function modules. There’re many good articles that explain the whole process of email inbound processing including real scenarios very well: Receiving E-Mail and processing it with ABAP from Thomas Jung Advanced Inbound Email Handling from Christian Drumm Offline/External Mail Approval Process without using SAP It’s very common....

In the previous post, we learned to build a web form in plain HTML with no coding experience. Even though creating HTML web forms is easy, HTML does not give many options when it comes to visualization. In this blog post, we are going to create a template-driven web form using the Angular framework and Fundamental NGX Library. Angular....

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,....

Welcome to the Fifth episode of the Series: SAP CAPM Full Stack UI5 Application with CRUD Operations. Till now we have created Development Space in BAS, set up a project structure for development, created entities and exposed the same as Odata services. In this episode, we will create a FreeStyle UI5 Application for the project. Assumption(OR Must Have....

Welcome to the Fourth Episode of the Series: SAP CAPM Full Stack UI5 Application with CRUD Operations. Till now we have created Development Space in BAS, set up a project structure for development, created entities and exposed the same as Odata services. In this episode, we will be inserting the Data in the created database entity for the....

This blog provides an overview for the SAP tools available for SAP SuccessFactors data integration scenarios. Keeping up with technology changes introduced by SAP SuccessFactors: Choosing between “Point To Point” Integration pattern and “middleware” based approach is often the biggest challenge. Here are the quick decision points on the advantages of using SAP SuccessFactors Integration....

I am writing this article to help some SAP Consultants around the world, like me, implementing SAP LBN-GTT. During the execution of Package and Deploy settings of TPOF (Tracking Purchase Orders Fulfillment) app., we faced the error message below: Error Starting application “gtt-ui-sample-track-purcahseorders_ui_deployer”: Controller operation failed: 422 Unprocessable Entity: CF- UnprocessableEntity(100008): memory quota_exceed We noticed....

Introduction – This article relates to scenario where absence entitlement are calculated in external system but are used in Employee Central Time Off for employees to record absences.   Background – Migration to SuccessFactors from on-premise SAP HCM and non-SAP ecosystem is happening for last few years and this will continue to grow. At times multiple system....

Dear all, as the name implies, SAP BW/4HANA or SAP S/4HANA are fully integrated with the underlying SAP HANA platform. This also means, that the physical data model changed compared to their predecessor products (for example in FICO area). Some tables are removed, changed or consolidated which makes a lot of sense to leverage the full power....

Introduction This blog helps UI5/Fiori developers understand sap.m.uploader.UploadSet UI Element in detail. Problem The SAP UI5 Demo site explains the UploadSet sample application. However, the  site can not explain how it works with a back-end system. Solution Below is the step by step working example of the UploadSet UI element that I have implement. Hope....

Security-Enhanced Linux is a Linux Security Model (LSM) that allows defining security policies to implement mandatory access controls (MAC), providing a very granular layer to strengthen the OS against attacks. Despite the obvious benefits of using SELinux, it has been historically advised not to use it on Enforcing mode (we will see what this is....

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....

Welcome to the Sixth Episode of the Series: SAP CAPM Full Stack UI5 Application with CRUD Operations. Till now we have created Development Space in BAS with a project structure for development, created entities and exposed Odata services. In this episode, we will create a Table in UI, do READ Operation on our Odata service & bind the....

When moving from ECC to S4 the new ACR magnetic media solution needs to be used to report to DIAN. The legacy solution ZDIAN_15 is not supported in S4. The new ACR solution is real nice for the users. However it has substantial limitations to the legacy solution. With this blog we would like to....

Businesses are unique, and so are their challenges. Evora designs, builds, and implements custom-tailored solutions based on modern technologies and best practices. As a long-time SAP partner, we have extensive experience in developing custom apps and connecting them to SAP backend systems. I spoke to my colleague Frederic Pollmann about his project experience so I could share....

  SAP S/4HANA Cloud is a complete enterprise resource planning (ERP) system with built-in intelligent technologies, including AI, machine learning, and advanced embedded analytics. It comes with embedded analytics in the form of a huge set of predefined SAP Fiori analytical apps which can visualize operational data that is already in the system. SAP S/4HANA Cloud also integrates SAP....

  Como vai TIME quanto tempo, mas afinal o que é a metodologia SAP Activate? Resumidamente o SAP Activate Methodology é composta, basicamente, por 4 fases. Prepare: Conduzir o planejamento e preparação inicial e definir governança do projeto para iniciar o projeto o com o pé direito. Explore: A equipe do cliente explora as capacidades da solução....

When implementing my openSource based RAP Generator I had the requirement that on the object page on item level fields should be read-only based on data that I had entered in the object page on header level. So on the item level I had a mixture of fields that are read only by default and....

SAP WM module is integrated with other SAP modules. After the salesperson completes the creation of the sales document, the business personnel of the warehouse department need to pick for the delivery document. If WM management is enabled for the picking storage location, the warehouse personnel need to create a TO (Transfer Order) based on....

Hello everyone! I wanted to share something that might be really useful for both the technical and functional consultants about Smartforms. The problem we had was, we were having a mirror image preview on a smartform we created a couple of weeks ago which was working absolutely fine on Live System as well as on the Development System. However,....

Generally for file based integration, SAP Process Orchestration File Adapter or SFTP Adapter is used to poll the data files from the file system or FTP/SFTP servers. But in some file integration scenario, the web server (Nginx, Apache, IIS etc.) is to be used instead of FTP/SFTP server in case that the FTP/SFTP server is....

While building an Integration in CPI, we often come across a situation where we need to use same piece of code which we have used earlier or sometimes we need to use external Jar file’s class to process some data. This Blog will explain how you can use External Jar files in CPI and make....

Objective: The objective of this blog post is to showcase system demo and settings that we need to perform for 2 step KANBAN stock transfer with EWM managed storage locations. Both source and destination storage locations will be EWM managed. Context: 2 step stock transfer is generally used when the source storage location from which the....

Hey everyone,  I am so excited to announce a new long format “talk show” that we are releasing from the Developer Advocates team called Developers Digest (link at bottom of page to watch) Developers Digest In this premiere episode Mamikee Kanneh co-hosts with me.  We have a great time running through all the segments, similar to the way a....

SAP HANA smart data access (SDA) allows you to access remote data as if the data were stored in local tables in SAP HANA, without copying the data into SAP HANA.   Before we start we check a view requirements Which Oracle Version is supported by which HANA Version: 2600176 – SAP HANA Smart Data Access....

There could be dozens of various reasons to trigger FPRUNX errors during adobe form generation like ‘ADS: com. adobe.ProcessingException: com.adobe.Processing’. Find below discussions about the basic FPRUNX Error messages and possible solutions: Error in Calling SAP adobe form: ADS ADS: com. adobe.ProcessingException FPRUNX Error messages and possible solutions Maybe can try the below method as....

This blog post gives an example on how to implement token exchange in a multitenant scenario. It builds on the previous tutorial and adds multitenant capabilities. Quicklinks: Quick Guide Sample Code Content 0. Introduction 1. Backend Application 2. Frontend Application 3. Run the Scenario Appendix: Sample Code Prerequisites To follow this tutorial, the following prerequisites are required: – Access to 2 subaccounts....

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....

Please follow below steps to upload Cloud Groups in GRC AC for IAG Bridge For Uploading Cloud Group setup as below  Role Type = Technical Role Import Source= File on Desktop Role Authentic Source = Skip Application Type = IAG Landscape = ARIBA/SAC etc. Methodology = Complete Selection Criteria              ....

SAP BTP ABAP Environment (“Steampunk”) started few years ago with their on-premise connectivity based on the SAP BTP Neo Environment. As part of the simplification and streamlining of the integration setup, the support of connectivity service of the SAP BTP Cloud Foundry Environment was introduced with 2111. Technical Background The SAP BTP Neo based on-premise connectivity has....

The topics discussed here may touch legal or regulatory topics. Neither SAP nor myself are allowed to provide legal advice. The information provided here considers only technical aspects and is not  legal advice any may not be used as such. Examples are for illustration only and shall highlight possible efforts that might be necessary.  ....

Customers and onboarding team more often than not would like to cancel onboarding of records seen in the onboarding dashboard. If you receive an error ” [Onboarding] Cancel OnboardingError : [COE0018]The cancellation request fornew hire xxx has failed. Please contact youradministrator (Onboarding/Offboarding) “, it means there is a missing configuration in the instance. Assuming other....

This article describes how you can achieve real time Sales Order & Sales Transaction creation integrated with 3rd Party CRM/Billing System when order is confirmed successful..  so you can develop a script consuming commissions API’s which will create based on scheduled time. What is CRUD API ? CRUD is an acronym that stands for CREATE, READ, UPDATE, and....

The more we lean towards AMDP based HANA transformations compared to good old ABAP these days, the more we feel the need of having substitutes of reusable standard ABAP function modules & programs. One such instance is LAST_DAY_IN_PERIOD_GET. While we can hope for a readymade HANA function or procedure developed & delivered by SAP with the....

本文介绍的期间费用表是客户系统实施嵌入式分析eSAC的一次概念验证的成果,以验证期间费用表在S/4HANA Cloud中自建的可行性。S/4HANA Cloud 嵌入式 SAP Analytics Cloud 可以增强当前系统的分析功能,并更好地帮助客户分析业务相关数据。本文将会在下文向读者介绍如何实施嵌入式 SAC以完成期间费用表(跨三年比较)的关键步骤并展示嵌入式分析云的功能。 客户的需求 SAP S/4HANA Cloud 中已存在大量标准分析应用。但是,特定地区或有特殊用途的客户会对仪表盘/报表有特定的样式需求。很多中国客户财务部门想要在一个界面上查看不同公司代码中多个年度的账户余额,可以允许最终用户灵活地比较不同公司代码之间的财务绩效,并查看近三年的趋势。另外,如果客户要在当地地区进行 IPO,在招股说明书中需要向公众披露按职能范围划分的期间费用,以展示公司的财务状况。 期间费用表(跨三年比较)的内容如下: CompanyCode   FunctionArea   GLAccount   Amount (Current Period) Portion % by Account AMT_CurrentPeriodLastYear YOYRate_Period(CurrentPeriod) Amount (Previous Period) PeriodOnPeriodRatio YTD_CurrentYear YTD_LastYear TYD_YOYRate YTD_YM2 YTD_YM3 EndBalance_YM1 EndBalance_YM2 EndBalance_YM3   目前标准应用支持比较 2 年的账户余额。当前没有可以比较多个公司代码的 3 个会计年度科目余额的 CDS ,查询或 Fiori 应用程序。因此,我们推荐客户使用嵌入式分析云创建跨3 年比较的期间费用表。实现该表使用标准数据源,不需要执行许多步骤。  ....

In this blog I wish to share my personnel experience in preparing for the beta exam ‘SAP on AWS – Specialty (PAS-C01)” . NOTE: This does not cover any new additions or modifications that AWS might bring in with the Standard version starting from 7th April 2022 As this is a brand new exam till today ,....

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....

Just think of SAP BTP as a solar system with its native runtimes and services but still allowing you to reach destinations in a different universe.  Indeed, SAP BTP offers a number of kernel services. Among them the connectivity services. SAP BTP Connectivity services comprise a connectivity lite, connectivity proxy and destination services. The destination service is the....

A few days ago I added ATC support to my visual studio code extension Today I decided to improve my workflow by adding an option to refresh the findings on activation adding a button to automatically adding the pseudocomments or pragmas The latter is a bit flaky as there’s no API to find them, and I extrat them....

Before explaining how a specific SAP analytics or data management product can address a dedicated problem, it is quite important to understand the overall problem using a product agnostic approach. A reference architecture typically helps in the identification of areas and business pain points that need to be addressed. Together with a world wide team....

As promised, part2 is in continuation to my blog post https://blogs.sap.com/2022/03/25/soh-migration-sum-dmo-with-system-move-first-hand-experience-part-1  In this blog post we will cover the following. How to effectively use DURATIONS file (MIGRATE_DT_DUR.XML) to reduce downtime. An out of the box solution to fast forward the downtime stage. SUM parallel mode execution Let’s start with how MIGRATE_DT_DUR.XML file can contribute. Durations.xml When....

This blog post is relevant to scenario wherein standard service is not available as a SEGW project, Standard service does not highlight the Consumption CDS view.   Select the SAP Fiori Application. Get the OData service details. Go to Service Implementation. Go to DPC class. Put breakpoint in GetEntitySet Method Run Get Call. Under _get_data_table_container....

  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....

This blog has been inspired by the requirement of one of our customers to analyze in detail the impacts of price, quantity and exchanges rates impact on Stock Keeping Unit (SKU) reported by end users in different transaction currencies of their revenue. The purpose of this blog is to give an example on how to....

This blog is about one of our project requirement to split a single table with multiple columns for example 20 columns in to 2 parts ( Table-1 with 15 columns and Table-2 with 5 columns) to accommodate in single page and how we accommodated using Sections We have a BO webi document that runs for 50+....

In my last blog post Calling SuccessFactors OData APIs via iRPA 2.0 I wrote about how we can create an automation which is calling a SuccessFactors API for performing upsert operations. The automation however also needs to be invoked. For this I worked on developing a chatbot which would call the API based trigger of the automation.....

This article is intended for database admins, consultants, customers & partners to start with basic configuration in HANA WebIDE for your SDI Project SAP will provide web-based integrated development environment (SAP Web IDE) is a quick way to get started for developing applications. SAP Web IDE is a good choice for immediate development access. Also an....

As part of SAP S/4HANA Customer Care and Regional Implementation Group, I am privileged to work across many customers, and our aim is to bring their lessons learned to you.  One unfortunate pattern, common among customers new to SAP Fiori, is a poorly configured launchpad. For example, even though the SAP Fiori launchpad appears, when....

はじめに 今回は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 での カスタム地理階層の作成....

Normally, you use ABAP at a very high level, just think of RAP for example. From time to time, however, it can be useful to remember the absolute basics. Using the example of elementary data objects, let’s look at the absolute basis of all data processing and descend to the bits and bytes. This may....

SAP Integration Suiteは次世代のハイブリッドの連携基盤として、Cloud-to-Cloud、Cloud-to-Ground、Ground-to-CloudとGround-to-Groundなど連携シナリオを全面的にサポートしています。 SAP Cloud Integrationで開発したIntegration Flowは、以下の3種類のRuntimeにデプロイして、実行することが可能です。 ①. Integration Suite メインな実行環境として、Cloud-to-Cloud、Cloud-to-Ground、Ground-to-CloudとGround-to-Groundシナリオで利用可能 ②. Cloud Integration Content Runtime SAP Process Orchestration 7.5上に動かすCloud Integraionの実行環境として提供され、 Ground-to-CloudとGround-to-Groundシナリオで利用可能 ③. Hybrid Deployment Option オンプレミス上のスタンドアロンの実行環境であり、Ground-to-CloudとGround-to-Groundシナリオは利用可能。2022年Q4にBeta版がリリースされる予定です。(最新のリリース予定はSAP Road Mapをご参考ください。) 本ブログは、②.Cloud Integration Content Runtime on Process Orchestrationの機能概要について、ご紹介します。 利用環境 Cloud Integration Content Runtime on Process Orchestrationは、SAP NetWeaver 7.5 SPS05以降で提供されるコンポーネントであり、以下のインストレーションタイプがサポートされています。 Advanced Adapter Engine Advanced Adapter Engine Extended SAP....

In many use cases it is required to build and deploy a Fiori app as a standalone webapp. This may be the case when you do not want to buy SAP BTP Portal Service or the SAP BTP Launchpad Service or if you want to build a offline PWA app and also if you want....

You’ve probably read about NFTs and associate them with artworks of Apes that have sold for millions of dollars. In this post, I’ll tell you what nfts actually are, whether the technology can be used for things other than art and how the technology behind nfts actual works. I promise the latter is so simple....

Even the best of intentions might lead to bad outcomes. This is also true for chatbots. Infamous examples of chatbots gone rogue include Microsoft’s Tay or Korean Luda Lee that both fired off hate speech and homophobic insults at users. Since more and more chatbots and voice assistants, also called conversational agents (CA), penetrate our....

How do you predict how a particular thing will perform, given set criteria? Forecasting models are one of the best ways to use what a business already knows to figure out what they’re likely to encounter as they move forward. Thus, the past consumption of a particular material can potentially predict how the business will....

1. Introduction This is a personal sequel to Fiori-like web app development in pure ABAP with htmx and Fundamental by Patrick VILLENEUVE to explore further the possibilities of combining htmx and ABAP to develop business web apps. 1.1 Motivation The world is shifting towards SAP web development using SAPUI5 and ABAP RAP model on a platform like BTP, and....

After some time, again a new video on the first steps with the Cloud Integration Automation Service Launchpad. In this video I will show which steps are necessary to start a new workflow and some tips and tricks on the usage of the interface. Chapters Selecting a scenario Generating a workflow Working on tasks in the Inbox....

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)....

Customer Vendor Integration BLOG POST Part 1 of 3. This is the first part of a three part blog post on SAP CVI (Customer/Vendor Integration). SAP delivers the CVI cockpit to convert customers and vendors to business partners, but there is a lot of preparation that needs to be done. Copyright @ V3iT Inc Converting....

The travel distance calculation (TDN) is a very complex functionality in EWM, which needs many data to work properly. The process of completing of all this data is very complicated and lacks on comprehensive visualisation and tools in standard system. Mostly you have to edit or import tables with XYZ bin coordinates, local and global....

In my recent project we come across a requirement where we need to connect Node.js with Python. So, I thought of writing a blog on it. In below example we will create a simple service where we run Python script and  show “Hello world from python”. First we need to install python for node modules....

Scripting inside SAP Conversational AI chatbots is a key feature, enabling developers to parse API responses or convert bits of conversations to display the way they want. The developers in the community ask how to do all kinds of crazy things within scripting. Well, not really crazy, but developers are used to doing whatever they....

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....

This Blog explains the steps which needs to be followed to configure in SAP S/4HANA Cloud to meet customer requirements for inserting or updating Country/Regions attributes. Prerequisites Your user must have authorization to access and modify the content of SSCUI view and it would be good if you have hands-on on configuring the solution via....

I’ve been exploring ways to transport role collections between BTP subaccounts. In my previous blog post, I introduced a custom tool for achieving the same. In this blog, I’m going to use standard services such as  SAP Continuous Integration and Delivery (CI/CD) and SAP Cloud Transport Management (TM). What makes this possible is that xs-security.json can....

Welcome to the Eight episode (Not the last) of the Series: SAP CAPM Full Stack UI5 Application with CRUD Operations. Till now we have created Development Space in BAS with project structure for development, created entities, exposed Odata services and done Update & Delete Operation. In this episode, we will do Edit Operation in the created table. Assumption(OR....

Disclaimer: Please note that this blog was published prior to the re-branding related to SAP Build portfolio, which was announced at SAP TechEd 2022. SAP Launchpad service and SAP Work Zone come together under the SAP Build Work Zone brand, with two editions: standard edition (formerly SAP Launchpad service) and advanced edition (formerly SAP Work Zone). You can learn more in this blog post.  SAP....

Recently I started to experiment building Digital Manufacturing Cloud POD plugins and soon learned that it can be quite time consuming just to build the basic structure of the plugin without adding any functionality. In my first plugin I created the file structure and files manually (with lots of copying and pasting from samples) which....

Here we get into the details of creating an extension endpoint in CDC (a.k.a Gigya) and its deployment in cloud foundry. The challenge faced by CDC developer is to understand the behavior of CDC extension that is hosted elsewhere, the blog is an attempt to explain the intricacies of creating such an extension using Node.js....

I am writing this blog post on HANA Smart data integration aka SAP HANA Flowgraphs. Basically SAP HANA Flowgraphs are nothing but ETL data flows which are inbuilt in SAP’s web based modelling toll i.e. SAP WEB IDE or SAP Business Application Studio. Flow Graphs A flow graph is usually considered an operator which helps....

Based on the following question RAP: Key As Segment capability support posted by Geert-Jan Klaps I found that I missed to blog about a nice “out-of-the-box” feature available for OData V4 services that lets a consumer use an alternate convention for addressing entities by appending a segment containing the unquoted key value to the URL. This feature is described....

This article gives you an overview of the steps to set up your SAP Subscription Billing in SAP Business Technology Platform environment (BTP) with SAP CPQ and enable access to the application and APIs. Once you’ve received a “welcome” email from SAP with your global account and initial user, you need to complete the following setup activities....

NOTE: this blog post is intended for developers who have previous experience in developing CAP applications which consume either OData or REST APIs using SAP Business Application Studio and SAP BTP destinations, as well as handling communication scenarios and communication arrangements in S/4HANA Cloud. Introduction You may have realized that most modern cloud applications are....

Since SAP Conversational AI introduced the speech-to-text client API, it’s worth taking a look at all the ways you can control your chatbot from the client side. You can: Add a button to open and close the Web Client. Let your app send a message to the chatbot Provide your chatbot with client information from....

Fleet management is extremely popular within the industry where many vehicles are used, it’s used to keep track of vehicle usage, fuel consumption, etc. In this blog, you will learn the essential steps to monitor consumption in fleet management using the PM (Plant Maintenance) module. I am trying to explain the steps used to set up fleet management along with creating the necessary master....

valid as of SAP S/4HANA 2020 This is the 2nd blog in my blog post series on managing hierarchies in SAP S/4HANA. Blog 1/3: FIORI apps to manage hierarchies Blog 2/3: Detailed features of FIORI app “Manage Global Hierarchies” Blog 3/3: Detailed features of other FIORI app to manage hierarchies In this blog, we will....

SAP Business Client has a great talent for integration. First, single apps have been integrated. Second, the Fiori Launchpad as a whole (FLP@ABAP). Now, the cloud launchpad, called SAP Build Work Zone, standard edition, fka SAP Fiori Launchpad Service, running on Business Technology Platform (BTP, cloud foundry). So even in the cloud you can mix native SAP GUI....

Now a days client has plenty of choices to select Analytical tools as per there business requirements and budget. Cloud being most popular option most of clients are preferring cloud solutions so that they don’t need to invest time in maintaining environments and installations. With Wide adaption of SAP intelligent Enterprise SAP has introduce Business....

Objective of this blog post is to showcase new functionality made available in S4 HANA 2020 for synchronous goods receipt for external procurement like purchase orders created for EWM managed storage location. Prior to S4 HANA 2020, we were obliged to create inbound delivery for purchase orders created for EWM managed storage location to post....

SELECT * EXCEPT col1, col2, ... to select all columns but those listed behind EXCEPT is not supported in most SQL variants, see e.g. discussions in stackoverflow. Alas, it is not supported in ABAP SQL either. But instead of working wit GTTs and ALTER TABLE as proposed in variuos discussions, we have another way, namely our dynamic tokens. Let’s look at an example. Assume we....

This article is mainly intended for Google Cloud Platform (GCP) Admins who can develop the applications locally in your cloud shell environment and deploy it to SAP Business Technology Platform (BTP) using SAP Commissions API’s to build custom dashboards .. High Level Architecture flow Pre-requisites Google Cloud Platform – Cloud Shell Environment SAP Business Technology Platform – Cloud Foundry Runtime SAP Commissions API....

This blog post explains how receipts that reach SAP Customer Checkout manager can be forwarded to your external system and what fields are relevant for processing. This allows you to build an integration and use all information that are provided in the receipt to full extent. SAP Customer Checkout manager offers a generic interface for....

As we know, Fiori launchpad is the starting point to start using Fiori apps and fiori launchpad  shows some general features with it like User settings, search icon, Notification icon ( if configured) , App Finder etc. Recently, I got a requirement from multiple teams that they want to hide some of these features or....

Reactive forms are forms that are defined programmatically at the level of the component class. Compared to the template-driven web forms we saw in the previous post, there aren’t many differences in the way the forms are displayed in the browser. Rather a blunt difference between those two is the way they are programmed. In....

SAP Data Intelligence have some capabilities of extract data from many sources, like SAP ABAP based systems, traditional and nosql databases, streaming tools, API’s and even SAAS 3rd Party solutions, but if you need to extract data from Salesforce, there are no standard operator to achieve these requirement. Because of this, we will see in....

Most of the time in Analysis Office we use single query and multiple queries in multiple sheet. When two queries are used in same sheet of Analysis Office, one after another there may be a risk of overlapping of the crosstab if the data increases and we get a warning message in Analysis Office. Causing....

SAP Champion Michael Keller and I discussed why we got started with ABAP and why you should too. We talked briefly on our experience with ABAP and Michael shared his expertise and why he “Hearts ABAP”. Check out the 3 minute video below   If you are also interested in learning ABAP, check out the resources below:....

As part of this blog , we will go through a scenario of posting a new Item on a SharePoint Site List with data being provided from C4C Service Ticket , using SAP CPI iFlow . Our Scenario Prerequisites Your MS Admin should create an App for CPI with necessary API permissions  and provide you....

Patch-Level Independent Bootstrap We listen to your feedback! A while back we got the feedback to make the bootstrap URL more stable and in dedicated feedback rounds, we evaluated that this should apply especially to the bootstrap URLs of long-term maintenance versions. With the introduction of the removal of outdated versions, this feature becomes even more....

Introduction In this blog we will explain you how we can create a Pareto chart in SAP Analytics Cloud using a Live Data connection to BW. A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending bars and the cumulative total is....

Fundamental Library Styles has dropped the IE11 support on its newest version release v0.23.0, resulting in some changes in the published CSS file. Previously, the theme variables were included in bundles, and CSS files for each theme were distributed containing those fallback values. As a result, the styling files were containing the duplicated declaration. Despite the increased....

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.....

You are using SAP E-Mobility and want to understand how to work with the additional services of Personal Data Manager and the Audit Log Viewer Service. The SAP documentation is not sufficient. SAP E-Mobility logs the following events related to personal data changes: The creation, modification, and deletion of badges The creation of data records for charging events  ....

SAP SuccessFactors Employee Central consists of Foundation objects (Position, Location, Division, Legal Entity, Department, Division, Business Unit) and Employee Data related objects (Person, Personal Information, Employment information, Job Information, Compensation information). The foundation objects form the Organization structure and acts as a framework on which the Employee information is built. Third party (Target) systems that....

I’m writing this blogpost to be helpful for someone like me who are migrating their projects from SAP WEBIDE to BAS. I’ll be updating this BLog as and when I learn something new in BAS and find solutions for problems  in migration.    Run your app in a specific version from Cloud foundary Launchpad If....

Overview While I was conducting a workshop on implementing custom search selectors, one of the participants asked if it was possible to search for users where email address, for example, is NOT Empty? (you’ll notice that the capacity to search on emails that ARE empty is in the product already). Answer: Yes, absolutely! There are....

The purpose of this little series of blog posts is to provide an orientation to working with equipment addresses in customer developed programs. In prior blog posts, we looked at how addresses are managed. Now in this blog post, we look at how to create a piece of equipment and assign an address to it.....

This blog will give an overview of sending Provider Contract Custom fields of CRM Order to S4 HANA Provider Contract. Step1  : Create AET field in SAP CRM using Administrator Business Role. Enhanced Object – PROVIDER_CONTRACT , Field name  – ZZFIELD using the AET Application Enhancement tool in SAP CRM. In CRMD_ORDERADM_I table Object –....

Running a Home-Grown Security Compliance Solution In a previous blog from about a year ago, I already spoke about our move towards compliance-as-code for security compliance scanning in SAP. Since then, the solution has involved into a policy control development, scanning and data pipeline operation that enables compliance, remediation and enforcement efforts through the organizational hierarchy. Multicloud....

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....

With the release of 5.33.x/ 6.25.x, SAP Cloud Integration now provides a feature where users can consume the reusable artifacts such as Script Collection and Message Mapping Artifacts across different packages. This enhancement will bring a better reusability experience for the usage of script collection across integration packages. Till now, Integration Developers were allowed to....

LSMW and LTMC are weak on complexity of routing. Component allocation, PRT assignment, etc. is hard to manage with these standart tools. Therefore i developped a flexible program that you can upload a whole excel with multiple sheets at once.   Details In the selection screen below, you can map your excel details. Routing Upload....

In H2 2021 the first iteration of milestone awards was released, introducing Service Milestones to recognise employee tenure by one of the available standard employment dates.  To learn more about configuring service milestone awards, follow this Knowledge Base Article.  In H1 2022, we follow this up with the first automated milestone life event awards to recognise....

The purpose of this Blog post is to demonstrate how text entered into a search (input field) can be used to filter a dashboard. This can be useful if users want to be able to filter on multiple values (not currently possible using a drop down ) or if the list of values is too....

In my blog post 2 weeks ago, I talked about how to use the SAP Conversational AI speech-to-text features with IBM’s speech-to-text service to your chatbot. Now I want to show another fun way to implement speech to text, but with a 3rd-party JavaScript service that kind of mimics Siri and Alexa. The speech-to-text documentation is available....

Note: This post is part of a series. For a complete overview visit the Principal Propagation in SAP Integration Suite. This blog post covers the use case for communicating an external system or client (for example Postman) with SuccessFactors using Principal Propagation in SAP Integration Suite, that is forwarding the identity of a user across several....

This blog post is part of the series covering Principal Propagation in SAP Integration Suite. As explained in SAP Cloud Integration help page, you can set up Principal Propagation with SAP BTP to forward the identity of a user across several systems and avoid the use of technical users in each of the systems involved. In....

This blog post describes applicable for S/4HANA Cloud system administrators scenario: during the system implementation it is necessary to create a new business role by the business key user request. In the same time, business key user request includes name of the app, to which it is necessary to set up access, but not the....

Logical prerequisites You have a SOAP to RFC Synchronous scenario and want to use SOAPUI for testing purposes. During testing procedure you receive a error from SAP PO. Something like this: <SOAP:Fault>          <faultcode>SOAP:Server</faultcode>          <faultstring>Server Error</faultstring>          <detail>             <s:SystemError xmlns:s=”http://sap.com/xi/WebService/xi2.0″>....

This blog post introduces you to the recently published SuccessFactors Implementation Design Principle (SFIDP) document: SAP SuccessFactors Learning: Employee Centered Learning Experience. Implementation Design Principle documents are owned and managed by SAP SuccessFactors Product Management who engage and collaborate with select, interested partners along with SAP Professional Service to tap the rich implementation experience that is distilled....

I just finished the opensap course DevOps for ABAP with gCTS in SAP S/4HANA Lots of excellent content like advice on dockerization and hands-on experience with gCTS And some confusing advice on branch switching on shared dev systems (which I find almost impossible to reconcile with a sane git based workflow. One of the exercises though....

The SAP Application Interface Framework enables you to develop and monitor interfaces as well as execute error handling in a single framework residing in your SAP back end system. It enables you to monitor interfaces across technologies centrally and configure alerts for the errors, mass error handling, and most importantly, empower business users. If there....

Metaflow helps data-scientists and developers to create scalable Machine Learning services and bring them to production faster. For a good overview on how to build and productize ML services with Metaflow see: https://docs.metaflow.org/introduction/why-metaflow. The Metaflow Python library for SAP AI Core extends Metaflow’s capabilities to run ML training pipelines as Argo Workflows. In this blog you will learn....

Today we will walk through how to create Parent child hierarchy in SAP DWC. Introduction  A Parent child hierarchy is a hierarchy in a dimension that is based on two table columns . Together this  columns defines the hierarchical relationship among the members of the dimension . The limitation of parent-child hierarchy is that each....

Having a code base, which is readable and maintainable is essential for sustainable development. The book Clean Code from Robert C. Martin and some other books contain many best practices around maintainable code. Writing cleaner code is an easy way to boost the quality, maintainability and testability of your code. With Clean SAPUI5 we provide....

  For the migration you need to take care of the DB migration and also the media migration. These are completely separate things, so if one is working, it does not mean that the other will work as well. This blog is about database migration; the next blog will be about media migration. As a....

Do you need to download a lot of Message Processing Log (MPL) attachments? There are already some tools available that come to your rescue here. Please have a look into the solutions from Ivo Vermeer, Oğul Kaan Mert and Fatih Pense. The question that I had when reading the aforementioned blogs was: Can we implement such a functionality in....

In case you need to create an xHTML file meeting ESEF standards, but it does not require tags (e.g. for Dutch companies who need to file an “enkelvoudige jaarrekening”, see here ) you can use a simple workaround in Disclosure Management.   1) Create a period with Word, Instance and taxonomy reports   2) In the taxonomy....

With the announcement of SAP BusinessObjects BI 4.3 SP02 release, you might already aware about the new type of SSO mechanism introduced in BI Platform: End to End SSO with Authorization Server – OAuth SSO Let’s see what is it all about the new type of SSO. More about Authorization Server (OAuth) SSO Important Points to Note Steps to Configure Authorization....

After watching and being involved in activities around mergers, divestments, and acquisitions over the 16 years of my career so far, I have realized never to underestimate the importance of an organization’s Master Data. A consumer products company I am familiar with acquired a big competitor in Australia in 2018. I was involved in the....

Great news! With one of its latest releases, SAP Continuous Integration and Delivery is providing a predefined pipeline for container-based applications. With this new offering, you can create Docker images, push them to your container registry, and deploy them to SAP Business Technology Platform (SAP BTP) – all with the click of a button. In....

I recently just first touched on the APO system and surprisingly find out that APO even doesn’t have the MARA/MARC table and Transaction code MM01 not to mention the function module like ‘BAPI_MATERIAL_SAVEDATA’! Here list of the basic approach to mass deletes MRP controllers in APO. It’s for the beginning level of APO development only....

Purpose The purpose of this little series of blog posts is to provide an orientation to working with equipment addresses in customer developed programs. In prior blog posts, we looked at how addresses are managed. Now in this blog post, we look at how to create an address suitable for a piece of equipment. This....

SAP Business Application Studio is the new IDE on SAP BTP  Like its predecessor, SAP Web IDE Full-Stack, it provides a cloud-based development environment. However, it also brings some new concepts into the picture like Dev Spaces   Once you click Create Dev Space, SAP Business Application Studio will add a kind of private virtual machine for....

在之前的文章中,我们向您介绍了预测计划的“影响因素”功能,以利用影响因素来提高预测的准确性。在那篇文章的末尾我们提到,当使用一些不受控制的影响因素时,因为您不能确定未来的值,您必须根据不同的场景生成多个预测。听起来很熟悉吗?您可能已经想到了假设模拟(What-If Simulation)。 假设模拟在计划环境中使用,以根据不同的假设业务场景确定KPI的值。 如果我的折扣和去年一样,我今年的收入会是多少?如果我不打折呢? 如果新冠病毒疾病继续传播,我的费用会收到什么样的影响?如果取消隔离限制又会怎样? 如果营销预算减少了怎么办?这将如何影响我的销售业绩? 如果明天不下雨,我所在城市的自行车出租量会是多少?如果下雨怎么办? 在这篇文章中,我们将向您展示如何利用SAP 分析云预测计划的预测功能来执行预测性“假设模拟”。 预测与假设模拟的关系 模拟模型 为了理解“预测假设模拟”与传统假设模拟的区别,我们需要快速了解假设模拟背后的方法。我们要执行假设模拟,需要: 一些业务变量:业务变量是与您的业务相关联的KPI(关键绩效指标)。 一些场景:这些场景是您想要测试的不同业务假设。每个场景对应于一组您想要测试的业务变量值,以查看它如何影响要估计的KPI。“如果我明年将广告预算增加10%,并保持相同的折扣”将是一种情况,“如果我明年将广告预算减少10%,且不打折”将是另一种情况。 模拟模型:模拟模型表示业务变量之间存在的关系。这是您业务的简化表现。 通常,模拟模型是计划模型本身,在计划模型中(通过创建层次结构或计算)明确表示度量/账户(业务变量)之间存在的关系。但该方法仅适用于以下情况: 必须知道业务变量和待估计结果之间的关系,并且必须在计划模型中正确表达; 业务变量和结果之间的关系不会随着时间而改变。 预测模型可以找到业务变量和要预测的KPI之间的关系,这些关系可能无法在计划模型中表达。此外,每次重新训练预测模型时,都会重新评估这些关系。预测模型可以作为补充,在业务变量和KPI之间提供额外的关系,从而获得更好的模拟模型。 实例 假设您是一名汽车销售,您想预测下一年的收入。您有一个具有以下KPI 的计划模型: 收入(您希望通过模拟估算的KPI) 售出的单位数量 单价 折扣 广告预算 在计划模型中,收入明确表示为售出单位数量、单价和折扣的函数(收入 = 售出单位数量*单价*折扣)。因为这种关系在计划模型中明确存在,所以您可以很容易地模拟折扣和单价的变化对收入的影响。 但这个计划模型也包含一些没有明确表达的关系。我们可以假设,折扣和广告预算会影响售出的单位数量(这通常就是为什么要进行折扣和广告)。但这些关系通常不会在计划模型中表达出来,因此在模拟中有一些不完全正确的地方:更改折扣和广告预算的值不会影响售出的单元数。 因此,为了修复模拟,您可以使用时间序列预测模型,以广告预算和折扣作为影响因素来预测售出的单元数。通过这种方式,缺失的关系被建模,并可用作规划模型中存在的关系的补充。 这些新关系可以带来两个好处: 您可以考虑之前在模拟中未考虑的变量的影响,例如广告预算; 运行模拟时,对于不受您控制的变量,不必给出确定的值,例如售出的单位数。对于受控制的变量,您可以给定相应的值,例如单价和广告预算。 场景 假设您在一家共享单车公司工作。您有一个计划模型,其中包含一个BikeHires测量值,表示每天的使用人数,以及与天气相关的几个测量值。您想基于预测计划来预测未来31天租用的自行车数量。如果要重新创建此示例,可以下载此数据集。请注意,列BikeHires, Temp.Min, Temp.Max, Temp.Mean, Humid.Min, Humid.Max, Humid.Mean 和 Rain将作为度量,其他列应视为维度。 步骤 模拟场景 在之前的一篇文章中,我们已经看到共享单车租赁的数量受到一些与天气有关的条件的影响。但我们希望得到未来30天的预测。我们可能会有一些相当精确的天气预报,我们可以用来预测明天,甚至可能是未来一周的天气预报,如果精确性不太重要的话……但我们不可能得到任何可信的的未来30天的天气预报。在这些情况下,我们都会使用不可靠的输入来生成预测。 那么,我们该怎么办?我们应该进行预测性的“假设”模拟,即根据不同的假设查看预测输出,知道它们只是假设。因为预测是基于本身不可预测的输入,所以我们不会对未来做出假设。相反,我们看的是在这样或那样的情况下会发生什么。 我们将使用3个简单场景(“假设”)进行假设模拟: 一种中间情景,可以根据天气的一些标准假设生成预测; 一种悲观情景,允许根据对天气的悲观假设生成预测(天气状况往往会降低自行车租用数量); 一个乐观的情景,可以根据对天气的乐观假设(天气状况往往会增加自行车租用数量)生成。 设置场景 每个模拟场景都将表示为一个计划版本,因此我们需要创建3个私有版本。但要创建这些版本,我们需要考虑SAP....

To become a OO developer you have to become a OO designer. As far as I know there is no standardization in OO design. So becoming a blackbelt OO designer is not possible. Learning OO design is a journey of doing an OO course, reading blogs, watching YouTube movies, searching for answers on the internet....

This blog post describes the way to work with processes in SAP Clod ALM. The blog post implies following pre-requisites: SAP Cloud ALM project is created Initial scope of the project as solution scenario “SAP Best Practices for SAP S/4HANA Cloud” is defined:   Start of work Once the initial set-up of Project in SAP Cloud ALM is done and solution scenario(s) is defined,....

This is an overview of the terms I found to be useful for OO design. That doesn’t mean other terms are not important, but for starting OO design, you could focus on these terms. Software Architecture layers and Class Categories Presentation layer Application Controller View Model Service layer (= Interface layer) Server proxy Client proxy....

In my last blogs I used Basic Authentication method to call SuccessFactors OData APIs.  Calling SuccessFactors OData APIs via iRPA 2.0 Let’s call iRPA 2.0 bot from CAI chatbot to update SuccessFactors I decided to invest time in changing this to OAuth 2.0 Authentication method. What makes oAuth 2.0 with SAML more secure than Basic....

  In my previous blogs I have brought you details of the many support and enablement materials and asset types we are bringing to you via the SAP Enterprise Support Value Maps. For your convenience I have added the links to those relevant blogs below. Today, I would like to reveal that we have reorganized....

Intended Audience: This blog is relevant for customer’s and consultants who are implementing SuccessFactors for a global client where they are planning to implement the solution in a multiple phase and have a complex landscape setup. Use Case: We have a global customer who is planning to implement SuccessFactors modules in their organization but want....

Multi-application usage has long been a predominant form of software utilization in businesses around the world. The benefits of using an all-in-one solution such as SAP Business ByDesign have begun to outweigh those of using multiple systems, but exceptions do exist. For example, an organization may want to have smaller third-party applications for a particular....

Valid as of SAP S/4HANA 2020 In this blog post series, I will provide an overview of the functionalities available for managing hierarchies in SAP S/4HANA. I will also discuss some of the interesting features and limitations of the FIORI apps supporting hierarchies. Blog 1/3: FIORI apps to manage hierarchies Blog 2/3: Detailed features of....

This article is intended for database admins, consultants, customers & partners to know the basics & understanding of Design time Artifacts available in HANA WebIDE for your SDI Project Implementation.. The following table lists in alphabetical order the design-time artifacts you can develop and deploy with the SAP HANA Deployment Infrastructure (HDI). For more information about the syntax required for....

This article gives you the information related to UI5 Integration Cards overview and gives you an idea to develop for your own projects which can provide a quick information for business users in one single portal. UI Integration with Cards Documentation In order to develop cards the card developers should be familiar with: Getting Started Card types....

While pushing your files for processing, you keep your data in form of files. But what if the data you are storing is sensitive. How can you protect that from unauthorized access? One of the ways is encrypting the files using GPG. In this blog, I’ll tell you what GPG is and how you can....

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....

Introduction Embracing TDD(Test Driven Development) What is the core benefit of TDD? Is it not time taking? The coding looks too complicated We are not on S/4HANA. Is that ok? Should we wait for S/4HANA? So, what do you suggest? Further reading Introduction Last October, at GrainCorp, we went live with CropConnect self-service Croptimiser. It....

Hi Recruiting Management customers and colleagues, as we all know H1 2022 Release is a hot topic at the moment, and as for every release, it comes with new exciting features. In this blog, rather than mentioning an enhancement I would like to talk about a very important deprecation that will take place between H1....

Embedded EWM provides flexibility to effectively carry out transactions through mobile RFUI Screens. These Screens are designed to cater to end to end functionality often with advanced features such as Picking with Pick Handling Units. While working as a consultant with various clients during EWM implementations I have come across numerous requirements where these screens....

SuccessFactors 1H 2022 Release in terms of Latest Home Page There are few notable changes in terms of Latest Home Page in SuccessFactors 1H 2022 release. In this blog we are going to discuss few of the new changes/functionalities in the latest Home Page as per 1H 2022 release. Functionality 1: Addition of new Quick Actions....

In this blog post, I will talk about how we can create the following Newsflash effect (or any animation effect) in a dashboard by applying Timers. Animation using Timers I have used 2 Timers, both have been initialized in Application – onInitialization using Timer.start(). Use Case 1 : Timer1 in Action Here, I want to....

Authorizations are such an integral part of an SAP environment. Unfortunately, not many have noticed the subtle changes that have impacted migrating from SAP ERP to SAP S/4HANA. Despite the lack of coverage, these authorization evolution elements are apparent to anyone who has to use the new system almost immediately. How has authorization changed between....

This post is a follow up content for the previous blog post from my colleague Sonia Petrescu and me ( Soumya Prakash Mishra ) for SAP IAG integration with different SAP Ariba modules. Integrating SAP Ariba solutions with SAP Cloud IAG (4 Minutes read) and  Extending Cloud Integration of SAP IAG to SAP Ariba Strategic Sourcing Suite(3 Minutes read) I....

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....

A while back I set myself the challenge of building an Analytic App that brought together a number of scripting elements; primarily as an exercise in understanding script interactions and chains of events. As you start creating ever more complex Apps for customers, you quickly realise that each script / function in isolation is fairly....

The debugger in my visual studio code extension just had a rewrite On top of a bunch of bug fixes onsession and  breakpoint handling has 2 new features: multiple debugging “threads” – can debug multiple runs of the same process (or multiple distinct processes) at once go to statement is now supported via the vscode UI FollowLikeRSS....

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,....

SAP Startup Framework now natively supports systemd on Linux  SAP applications have been available on Linux since 1999, and ever since SAP has used System-V startup scripts to start the applications automatically on all UNIX-like operating systems. This has been a big benefit in the past because SAP administrators could use the same knowledge for....

This document aims to provide detailed step by step implementing fast entry of characteristics in Order Confirmation. This document encompasses screenshots of the steps to be followed. Characteristics value assignment of a batch class in production process is essentially important for a product where the product holds a batch specification. Using fast entry of characteristics,....

SAP Fiori introduces a new family theme called Horizon. The theme of family has been evolving iteratively. However, this latest update takes more than just theme upgrades. See the previous post for more details.  Some components, for example, have changed not only their color, but also their design: Switch in Quartz Light theme   Switch in Morning Horizon....

SAP SuccessFactors has become a major pioneer in framework and integration as part of the Cloud HCM applications in the market, since becoming a part of SAP in 2011. The flexibility offered in SAP SuccessFactors APIs makes a good fit for varying architecture complexity. Within SAP SuccessFactors, Employee Central (EC) is the hub for Employee related....

Data compliance has always been a concern, but in recent years, not paying proper attention could lead to costly consequences. Data compliance is a significant concern for most companies that use SAP because of legislative regulations. Laws and rules such as the General Data Protection Regulation (GDPR) in the EU and the Health Insurance Portability....

Background The existing server certificate for domain “*.crm.ondemand.com” is renewed as it is going to expire on Dec 16th, 2022. Scope You will be affected if either of the below scenarios are applicable to you: Your browser does not have DigiCert Certificates. You have an inbound communication integration to your C4C product. Impact The SSL....

Background As part of infrastructure migration, and standard practice for SSL certificates it is recommended to use SAN extension for which your existing *.crm.ondemand.com domain certificate is incorporated with Multi Domain SSL Certificate feature. Scope You will be affected if either of the below scenarios is applicable to you: Your browser does not have DigiCert Certificates. You have an....

Introduction In this article I discuss why recovery of a transaction log dump of a SAP ASE database may sometimes take longer than expected and It is assumed you do have a working knowledge of SAP ASE as a DBA. An important (the most important ?) part of your job as a database administrator (DBA)....