Freelancers
Cancel
 Sign In
Join Now

Unlock the Power of Business Data for SAP RISE Customers: Mastering Data Management and Cultivating Insights

updated date: 31.May.2023 Business data has become a strategically crucial asset for enterprises after they have digitalized their business management with enterprise software. According to HBR insights, companies can derive value from data. For RISE with SAP customers, they are running their business transactions in SAP system for their corporate finance, supply chain, production, warehousing, sales and....

Mixed Modeling Scenarios Consuming DataStore Objects

This blog is about the pros and cons of External SAP HANA Views vs. External SAP HANA SQL Views in context of mixed modeling scenarios. It also shares some insights on cold store pruning and how to handle currencies. Mixed modeling has become a very popular pattern for data modeling in SAP BW/4HANA in the past. In this blog,....

Data writeback from SAC to SAP BW4 HANA through Open Data Protocol (OData) Services

The purpose of this article is to explain the integration mechanism between two SAP platforms – SAP Analytics Cloud (SAC) and SAP BW/4 HANA (SAP Business Warehouse) through OData (Open Data Protocol) services that provides data writeback feature. This integration opens a plethora of opportunities for businesses to make informed decisions with advanced and flexible....

HOW TO WRITE CONTAIN CONDITION FOR TWO DIFFERENT TABLE FIELDS

Summary: I am writing this blog because we can’t directly compare fields from two different tables in CDS View. This document will help or guide you to achieve the compare field from two different tables. Will see step by step how can we accomplish the fields from two different tables using the “contain” condition. Basically,....

SAP BW IOBJ conversion to SAP BW4HANA IOBJ

The classic BW request status management (RSSM) based on Request IDs (0REQUID) is not available with SAP BW/4HANA. SAP BW/4HANA has a new request status and process management (RSPM) based on Request Transaction Sequence Numbers (0REQTSN) Now it is mandatory step need to convert Master data info objects / Open hub destination using below Task....

SAP BW Bridge: Just a SAP BW/4HANA in SAP Datasphere?

In 2021, SAP has published the SAP BW Birdge. Is it a SAP BW/4 HANA in the Business Technology Platform? Does this give the SAP BW a cloud SaaS perspective? What is the BW Bridge? There are already many blogposts and information material on the subject, so I’ll treat the topic only briefly here. The....

HANA Workload Management deep dive part III

last updated: 2023-04-14 16:00 CEST After we identified our bottlenecks, understood the workload and configured the right parameters for our instance, we have to check if we should go for a new HANA workload class or use the possibility for user parameters. At first you should know that your first choice should always be to use workload....

Handle High Frequency Inbound Processing into SAP BW/4HANA System

With the migration to SAP BW/4HANA, source system of type “Web Service” is not available. And here comes a new capability “Write Interface” for DataStore Objects allowing to push data into inbound queue tables of Staging DataStore Objects and Standard DataStore Objects, replacing the push capability of PSA tables of DataSources of Web Service Source....

BW4HANA ADSO Active Table Partitioning. Why needed and best method to perform.

This blog post is related to SAP BW4HANA or BWonHANA or SAP S/4 HANA Embeded Analytics ADSO Active table partitioning. Now please understand that the active table of the ADSO holds data after activation and it is the area where all data resides. Sometimes we may come up with a situation where the ADSO reached....

Thoughts on hybrid development with BW/4HANA and SAP Hana Calculation Views as generally valid solution pattern looking at a mid-term time horizon and SAP Datasphere

Note: Adjusting SAP DWC to SAP Datasphere with the presentation of SAP Datasphere today.   Repeatedly in recent years I have been confronted with the question of how to evaluate “hybrid” development” in BW, i.e. creating virtual models with SAP HANA native Calculation Views built on BW-generated HANA Calculation Views, often with the subsequent use....

HANA Workload Management deep dive part II

last updated: 2023-01-09 18:00 CEST Ok, you already read part I of the deep dive series of HANA workload management. You are waiting for more insides after you identified some HANA resource bottlenecks? Then you are on the right track. In this part I will describe how you can get an overview of your systems workload and....

How to consume an analytical query / BEx Query in ABAP

How can I consume an analytical query in ABAP ? Normally analytical queries are used with reporting tools like SAC, Analysis Office, WebDynpro Grid,  or RSRT in backend. This post show how to directly access and use the query within your own ABAP application by the use of Lightweight BICS API ( LBA ) . It’s really easy....

Copying a Login From One SAP IQ or SAP HDLRE Instance to Another

Over the years, many customers have asked for the ability to copy or move logins from one SAP IQ instance to another as part of the normal development progression.  Times arise when you want to maintain the same password.  Fortunately, there are methods to do this.  What I will describe below is the same process....

Vom CDS-View zur Fiori-Launchpad-Kachel (der ganze Weg)

Als SAP BW Berater weiß man die Vorzüge eines ad-hoc-Reportings zu schätzen. SAP S/4HANA Embedded Analytics führt ein breites Spektrum an CDS-Views mit sich. Daneben lassen sich mit selbst erstellten CDS-Views vielfältige, unternehmerische Anforderungen abdecken. Wie aber lassen sich solche CDS-Views möglichst einfach in einem ad-hoc-Reporting nutzen? SAP S/4HANA Embedded Analytics nutzt dabei das SAP....

BestPractice – How to use SAP Data Warehouse Cloud as source for SAP BW/4HANA

A frequent use case in hybrid data warehousing scenarios is to enrich existing data models in SAP BW/4HANA with analytical data models from SAP Data Warehouse Cloud. Data from SAP Data Warehouse Cloud is to be transferred to SAP BW/4HANA to enrich the existing data flow in the on-premise system with public cloud data. The....

SAP BW/4HANA 2021 SP04: Renovating ODP Extraction in HANA Runtime

In one of my earlier blogs, I put a spotlight on BW Transformations in HANA Runtime from ODP sources. The trigger came from lessons learned during an in-place conversion to SAP BW/4HANA were my team ran into situations causing some headaches. The reason was, that there is no HANA Runtime for transformations on ODP sources in....

I received similar questions about SAP SuccessFactors (SF) landscape from our partners and customers; therefore, I decided to write a blog post about common cross-customer questions about landscape management. This blog is intended for customer admins, and consultants new to SAP SuccessFactors. The aim is to provide information in a simple way via a FAQ-kind structure. Feel free to share your opinion and areas for improvement. What is multi-tenant architecture? SAP SuccessFactors (SF) is using multi-tenant architecture like most of Software as a Service (SaaS) vendors. Multi-tenancy is an architecture used in Software as a Service (SaaS) in which an instance of a software application serves multiple customers. Each customer is called a tenant. It allows SaaS companies to serve even quite small customers. The model, in which a server can be used by multiple tenants utilizing a scalable, available, and resilient architecture. The underlying hardware is completely shared, logically isolated, and with fully centralized services. It also allows SaaS vendors to scale up or down quickly. (e.g. adding 5.000 or 50.000 more users may mean changing some tenancy assignments only and could be done on the fly) How is the (initial) user management at SuccessFactors? About the user, authorization and administrator concept, and User management are key topics for admins. it is common that the SAP order form has a procurement team or senior management contacts therefore these should be replaced once tenants are available. 2768771 – SuccessFactors IT Contact Change request it is possible that credentials are lost or blocked by a spam filter, therefore you can to request reactivation 2517118 – New Instance Creation & Instance Re-activation Process | Credentials Notification to customers – HCM Suite How is the SAP SuccessFactors Provisioning, the process of setting up IT infrastructure? Here the standard provisioning of SuccessFactors BizX platform solutions is explained. Once you have a valid SF contract, prior to the start date (usually within 2 weeks), Authorised administrators per order form will receive an email about landscape and login information. You will receive three tenants if you have Employee Central (EC) otherwise two tenants. (In this article, I excluded Validated Learning Environments, Onboarding 1.0, WFP/WFA and ECP for sake of simplicity). PrevandStdEnvironment Prev and Std Environment of SF modules What are the SAP SuccessFactors Preview and Productive Environments? There are two environments one is Preview environment (PREV) that is used for regression testing (hcmXXpreview.sapsf.com/login?company=YY) and Production Environment (STD) (hcmXX.sapsf.com/login?company=YY). (XX– stands for a two-digit number about DataCenter, YY-stands for the customerID) Preview tenant is used for the release changes related to program or code changes. There are universal enhancements that are mandatory to all customers and opt-in features which the customer may decide to deploy. It is upgraded about 30 days before production tenants. As of 2022, SuccessFactors offer two times a year release changes in May and November, therefore about 2 months a year the code stack of the preview and production environments differs. Remark; Preview and Productive Environments are codestack-related definitions and not their usage. In other words, you may have preproduction and development tenants within the productive environment. How is the Data Center setup for Successfactors? A Data Center is a physical location of server/s where the SuccessFactors cloud application is hosted. The data center is generally driven by legal requirements or where most customers’ end-users are from. It is defined in your SAP Order form. The Data Center location’s exact address is not shared, and data center visits are not offered. For more information please visit SAP Trust Center What are the SAP SuccessFactors Productive and Non-Productive Instance(s) / Tenant(s)? Instance and Tenant are interchangeably used terms and refer to a single database schema of a platform (product type) for example SF HXM Core (BizX). Each instance when provisioned for a specific customer is assigned a unique alphanumeric identifier, called CompanyID. A productive tenant (or productive instance) is in a productive environment and only one for every customer number. Customer production instance is always hosted in the Productive Environment. You may have many other non-productive tenants either in preview or productive Environments. SAP does not provide service SLAs for non-productive tenants, and these may run on weaker hardware. Non-productive tenants do have some limitations on concurrent usage and should not be released for end users due to compliance regulations. What is the typical instance landscape during and after implementation? During Project Implementation Non-Production instance in Preview Environment – All Development, Testing, and System Integration Testing(SIT) should be done in this environment. Non-Production instance in Productive Environment – (EC customers only) used for User Acceptance Testing(UAT) & Payroll Parallel Processing. Production instance in a Productive Environment When customers have more than standard (two or three) instances, it gives them greater flexibility e.g. tenants for HR-IS test and trial (could be used for adoption sandbox), for training etc. Customers could request further nonproduction landscapes per their needs. During Operation, Business as Usual (BAU) Non-Production Tenant in Preview Environment – Regression Testing for Releases, Enhancement Development & Testing environment Non-Production in Productive Environment – Used for Production Support and Payroll Testing Production Tenant in Productive Environment What is Instance refresh? SF landscape – Refresh directions A refresh is a process of copying all data and configuration from source to target, without impacting the integrations in the target. The source is the instance from which data and configurations are copied to the target instance. The target is the instance to which data and configurations are copied using Instance Refresh. Refresh is not supported if the target is a production instance if it is a cross-data center request, or during a blackout period (during release changes). Admins can request the service via Instance Refresh Tool. Please check 2791468 – Instance Refresh Tool for BizX & LMS | Must-know guide & FAQ for further details. To set up other environments, there is always a need to copy data and configurations from the productive instance into nonproductive instances. To avoid unintended access to confidential live HR data, set up production-like permissions within the test environment, deletion of selected datasets or scramble employee data (Data Anonymization) in all nonproductive instances is recommended. What will the Refresh include? A refresh will copy all contents of the instance database schema. The Refresh will include all internal instance settings (permissions in Admin Tools, Detailed Reporting Rights, Company System, and Logo settings, etc.), template configuration and supporting content materials (competencies, rating scales, picklists, etc.), user data and history and other content of the instance. The Refresh will also include settings at the SuccessFactors application layer level (Company Module and Feature Settings, SSO Configuration, and IP Restrictions (both Provisioning-based and GUI based in Admin Tools). The only item remaining within the SOURCE is the Company ID (as the Company Name/ID are not updated in a refresh). SAP operation team, respective to the module, will conduct the necessary Post Refresh Requirements within Provisioning; the GUI based aspects, such as Themes, IP Restriction, and Custom Tiles, etc., are the responsibility of the customer to address Post Refresh. If you have developed content that only exists in the TARGET, IT WILL BE LOST, so you will need to take steps to save copies of any templates before the refresh process, which you may want to re-establish in the TARGET instance Post Refresh. InstanceRefreshvs.Synch Instance Refresh vs. Synchronization What is Instance Synchronization? Instance synchronization is quite different than instance refresh which copies all configuration and data. Here at synchronization, it is only copying the configuration of your multiple SAP SuccessFactors instances. Instance synchronization enables you to “push” new configurations from one instance to another. Use Instance Synchronization when you sync/copy the selected configuration from the source instance to the target instance without changing its data or when you want to adopt incremental implementation of configuration or feature. Unlike refresh, you might use production as a target therefore be very careful and aware of the source/target tenants. Which modules are available for the Refresh? The Refresh is not an entire Suite Refresh, and only a select set of Modules can be refreshed under the (free) Refresh offering. These Modules currently include: Foundations (BizX)= Employee Central (EC); Performance Management (PM); Goal Management (GM); Live Profile (LP); Succession (SCM); Compensation (Comp); Variable Pay (VarPay); Recruiting (RCM) Learning (LMS) Onboarding 1.0 (ONB), if you have an old onboarding tenant (not part of BizX) Currently the other modules (Jam, Recruit Marketing (RMK) and Work Force Analytics (WFA), Online Report Designer, and Advanced Reporting do not have a refresh capability. What is Instance Cloning? Cloning, Copying SOURCE and creating new TARGET (TARGET instance does NOT already exist), where at Refresh, Copying SOURCE to TARGET (TARGET instance already exists). A Clone is almost the same as an Instance Refresh but requires an additional process to have a net new instance provisioned by SAP. Were as an Instance Refresh already has a TARGET established, a Clone does not yet have a TARGET and the TARGET is created as part of the process. The significant difference in both is that any net new instance requires proper provisioning. Does SAP SF support data scrambling(Data Anonymization)? SAP SF support via add-on solutions (Refer to SAP AppStore) as well as native out-of-the-box and free of cost. EC, RCM and Platform (people profile) information could be scrambled (the fields are enriched further the current list is available for review). The most common problem the Employee Photo Anonymization is also as of b2205 release possible. 2827300 – [Provisioning Opt-In Feature] Instance Refresh Tool | Data Anonymization feature What is the recommended frequency of instance fresh or instance synchronization? It is impossible to give a one-fit-all recommendation, just like on-premise software landscapes. However, twice a year, from production to quality instance refresh, before the new release could be followed. What is the recommended Successfactors Landscape? As explained earlier bare minimum is a development and a production instance. Just like on-premise landscape decisions, it should be tailored per customer need.For example, for multi-phase implementations for three regional templates, when one or more phases are live and others are still in the implementation phase, it requires several tenants. (just like on-premise solutions). Among many other justifications, for a similarly tiered landscape to match the client’s ERP landscape and payroll testing or Secondary testing environments (e.g. Cutover Test, Integration Test, Pre-Production) – used for conducting targeted, isolated tests, generally as part of the final stages prior to a production cutover. Several large enterprises also use a production-like, non-production landscape by HR-IS for own feature adoption tests or as a sandbox for learning. One major advantage of SaaS is simple tenant creation and refresh; within days, you can get an additional tenant. Associated costs and required technical skills are insignificant. Please check, SAP SuccessFactors Architecture Leading Practices (ALP) – Instance Strategy for key topics. Does the SuccessFactors Platform offer tools for managing data protection and privacy? SAP SuccessFactors values data protection as essential and is fully committed to helping customers comply with applicable regulations – including but not limited to the requirements imposed by the General Data Protection Regulation (GDPR). Customers get valuable support in their compliance efforts by delivering features and functionalities designed to strengthen data protection and security per their country’s regulations. However, it remains the customer’s responsibility to evaluate legal requirements and implement, configure and use the features provided by SAP SuccessFactors in compliance with all applicable regulations. No tool is out of a box complaint since it is a joint effort. Summary Hopefully, this blog helps you better understand the SAP SuccessFactors landscape and Landscape management basics. I look forward to getting questions from you, our customers, to enrich the blog further and aim to explain more simply. Happy to get your comments for my other blog posts Orkun TUERKMEN Feel free to check SAP SuccessFactors platform blog posts and Q&A about the SF platform, to post or to follow questions about the SF platform.

Sizing implies deciding hardware necessities such as memory, CPU control, disk space, I/O capacity, and network transmission capacity. It is an iterative process to translate business requirements into necessary hardware requirements and is ordinarily performed early within the phase of the project. To prepare your BW system to upgrade/migrate to HANA, it’s important to estimate....

Flattening of Hierarchy in SAP BW/4HANA using CDS Views

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

Important Standard Tables in SAP BW & BW/4HANA

Below a list of some of the important standard SAP tables in a SAP Business Warehouse (BW) system with their description. Also there are some recommendations with reference SAP note on how to perform housekeeping and cleaning up of these BW tables. For more information you can see SAP note 2388483 – How-To: Data Management for Technical Tables. ....

Planning the System Conversion to SAP BW/4HANA – Expert Guided Implementation

  SAP BW/4HANA is SAP’s next generation data warehouse solution built entirely on one of the most advanced in-memory platforms today – SAP HANA. This Expert-Guided Implementation (EGI) service will help you prepare to convert your current SAP BW system to SAP BW/4HANA. The expert delivered session will cover “on-premise” BW/4HANA conversion concepts including; In-Place Conversion, Remote....

Exposing ABAP CDS views to Power BI

S4HANA ABAP CDS view provides a powerful way to model and consume the data residing in HANA database. It allows developers to create semantically rich data models which the application services expose to UI clients and various reporting tools. It is the central pillar of S/4HANA development and is used as the core technology in....

How to post SAC API output into BW/4HANA using ABAP

1. Introduction This simple tutorial should give you an idea of how to consume SAC APIs in ABAP and post the result to BW ADSO. SAP exposes a few data-export APIs. API documentation can be found in the following links; https://api.sap.com/package/SAPAnalyticsCloud/rest https://help.sap.com/docs/…SAP Analytics Cloud REST API 2. Use-case Store changelog for SAC metadata Enhance existing....

How to load Flat Files from MS Office 365 to BW/4HANA using SDI / DP-Agent

1. Introduction This simple tutorial should give you an idea of how to extract the flat files from MS Sharepoint 365 to BW/4HANA. Many thanks to Andrei Paul Andreianu for co-authoring this blog! 2. Use-case Load the flat files from MS Sharepoint 365 to BW/4HANA. Store the Flat File changelog and snapshots in BW/4HANA. Enhance....

データ抽出可能なCDSビューの活用方法

S/4HANAにおけるリアルタイムアナリティクスのためのキーテクノロジーとして登場したCDSビューは、BW4/HANA、Data Warehouse CloudなどSAPのDWH系製品に対し、S/4HANAからデータ連携を行うためのテクノロジとしても、その活用範囲が広がっています。 本ブログではリアルタイムレプリケーションを中心にデータ抽出可能なCDSビューの活用方法をご紹介したいと思います。 1.データ抽出可能なCDSビューとは？ データ抽出に使用できるCDSビューはアノテーション「@Analytics.dataExtraction.enabled」が”true”に設定されている必要があります。 ※CDSビューのモデリング方式であるVirtual Data Model（VDM）におけるビュータイプを決めるアノテーション「@VDM.viewType」との関連で混乱される場合がありますが、「データ抽出可能なCDSビューか」はあくまでアノテーション「@Analytics.dataExtraction.enabled」で決定されます。 以下はSAP Data Warehouse Cloudのデータビルダで、接続先のS/4HANAシステムから利用するCDSビューを選択する画面です。ここで利用可能なCDSビューはすべてアノテーション「@Analytics.dataExtraction.enabled」が”true”に設定されています。 ※SAP Data Warehouse CloudとS/4HANAとの接続設定等についてはこちらをご確認ください。 例1:アノテーションが設定されている場合（勘定コードマスタ） 例2:アノテーションが設定されていない場合（品目マスタ） 2.データ抽出可能なCDSビューの探し方 まずはS/4HANAのビューブラウザを利用する方法です。こちらは先ほどご紹介したブログの「データ連携可能なCDSビューについて」の章に記載されておりますので、ご確認ください。 S/4HANA 2020からは「データ抽出可能なCDSビュー」を検索可能なCDSビュー（　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　I_DATAEXTRACTIONENABLEDVIEW（SQLビュー：IXTRCTNENBLDVW））が利用可能になりました。このCDSビューを利用するとデータ抽出可能なCDSビューを検索できるだけでなく、そのCDSビューがリリース済みか、またリアルタイムレプリケーションに対応しているか、まで判別することができます。 トランザクションコード：SE16Nで「IXTRCTNENBLDVW」を検索すると以下のように利用可能な項目定義を確認いただけます。 データ照会を行うと「データ抽出可能なCDSビュー」の一覧を確認いただくことが可能です。 ※「ISSAPRELEASEDVIEW」にXを指定⇒リリース済のデータ抽出可能なCDSビューの一覧　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　※「DELTACHGDATACAPTUREISSUPPORTED」にXを指定⇒リアルタイムレプリケーションに対応しているデータ抽出可能なCDSビューの一覧 3.リアルタイムレプリケーションの仕組みとは？ リアルタイムレプリケーションのベースとなっているのはCDC（Change Data Capture）です。この機能によりS/4HANA配下のHANAデータベーステーブルに対する更新情報がロギングされ、さらにこの更新情報を相手先に超短周期で連携することにより、リアルタイムレプリケーションの仕組みが実現されています。 以下はSAPのDWH系製品とS/4HANAの連携概念図です。今回は赤枠のSAP HANA SDIからの連携をベースに説明します。 ①まず、SDIからAPI経由でODP（Operational Data Provisioning）にリアルタイムレプリケーションの設定及び初回データ要求が行われます。 ②この要求に基づき、CDSビュー配下のテーブルの更新情報がロギングが開始されます。　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　（この情報はトランザクションコード：DHCDCMONで確認できます） ③ODPはCDSビュー及び要求元別に差分情報（ODQ）の管理を開始します ④CDSビュー配下のテーブルにINSERT, UPDATE, DELETEがあった場合、CDCに差分情報が管理されています。　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　（差分情報はテーブルのキー項目ごとにどんな変更があったかをベースに管理されていますので、CDSビューには配下のテーブルのキー項目がビュー項目として設定されている必要があります） ⑤SDIは周期的にODQにデータを要求します。QDQはCDCから前回連携分からの差分更新情報を抽出し、SDIにデータを連携します。 4.リアルタイムレプリケーション可能なCDSビューとは？ リアルタイムレプリケーションが可能なCDSビューとなるためには前述のアノテーション「@Analytics.dataExtraction.enabled」に加えて、「@Analytics.dataExtraction.delta.changeDataCapture」が記載されていることが必要になります。 以下は原価センタマスタ（I_CostCenter）の例になりますが、「changeDataCapture.automatic：true」と記載されています。 原価センタマスタの場合、CDSビューの配下のテーブルが「CSKS」という単一テーブルです。この場合は、「changeDataCapture.automatic：true」の記載のみでリアルタイムレプリケーションが可能なCDSビューとすることができます。また、CSKSのキー項目がビュー項目として設定されていることがわかります。 これに対し配下に複数のテーブルを持つCDSビューの場合は少し複雑になります。複数テーブルが配下にある場合に唯一リアルタイムレプリケーションが可能なのは、N:1のLeftouter joinを作成できるケースです。（UNIONやInner Join はリアルタイムレプリケーションがサポートされません） これはCDCがテーブルのキー項目を元に差分認識をしていることによります。例えばN:NのLeftouter joinの場合は右テーブルとの結合により、左テーブル単体の場合と比較して取得されるデータ件数が変動します。そうすると正しい差分変更情報を連携できないため、左テーブルのデータ更新を基にビュー全体の差分情報生成が可能なN:1のLeftouter joinのみがサポート対象となっています。詳細はこちらを参照ください。 5.リアルタイムレプリケーション実践 これまでご説明したリアルタイムレプリケーションの仕組みを実際の画面を見ながら、復習したいと思います。（今回はSAP....

Create Hierarchy from non-SAP Source

Since BW 7.3 the hierarchy frame work allows to load hierarchy data from any datasource – also from a non-hierarchy datasource. In this post, I’ll walk through the process of loading a hierarchy from a SQL database table via a master data attributes datasource. The hierarchy to be created consists of 3 levels. Source material....

Hana Table Migration using Export & Import

One of most common requirement in Hana is to move user defined table from one Hana environment to another (Ex: Dev > QA > Prod). Here is one of the method i.e. Export & Import we can use. Solution – Will migrate the Hana Table from Source Hana Environment to Target Hana Environment. Step 1 Export....

Deleting / Re-organizing BOOKMARKS – SAP BW bookmarks deletion

You want to do a mass deletion of bookmarks, how do you achieve this? The following 3 ways are what I am aware of to clean up activity related to bookmarks. There probably are more ways to address this issue but in this blog I just highlight 2 ways on how you can reorganize/delete bookmarks.....

Handle Divide By 0 Error in Hana Sql or Hana View

Sometime we have to divide two numbers in Hana Sql or in Hana views. If denominator comes as 0 there is no logic implemented handle 0 in denominator then Hana will throw Divide by 0 error during Query execution. Also this is good practice to handle denominator 0 case whenever we do any division in....

SAP Analytics Cloud – TroubleShooting – Timeline Traces

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

SAP BW4HANA Conversion Operating Modes

SAP BW/4HANA Starter Add-On is delivered as an SAP NetWeaver add-on. When the add-on is imported on an SAP NetWeaver installation, the system is in Compatibility Mode. Object types, processes and user interfaces in existing scenarios are still tolerated in this mode, but new scenarios must be implemented with the new SAP HANA-optimized object types,....

What SAP BW to SAP BW4HANA conversion?

SAP BW/4HANA is SAP’s next generation data warehouse solution. It is a new product (not a legal successor of any existing SAP Business Warehouse solution), built entirely on one of the most advanced in-memory platforms today – SAP HANA. It provides a simple set of objects that is well suited for modelling an agile and....

SAP IQ Audit Process (SAP ILM, SAP BW NLS/DTO, and Standalone SAP IQ)

SAP IQ has a built in audit feature that is well documented in the manuals and in other blogs.   On the operational side, however, knowing how to process the audit data and what to do with it is just as important.  If you simply use the dbtran utility to pull out the audit data, you will....

HANA SDI SOAP integration into SAP BW Process chains

How to run native SAP HANA objects (e.g., procedures) in SAP BW Process Chains (PC)   Have you ever considered running HANA artifacts such as HANA Flow Graphs, Procedures etc. direct in BW Process Chains? Instead of using the BW scheduling and HANA scheduling tools separately and trying to get things synchronized between the systems.....

Transition to SAP Data Warehouse Cloud Roadmap updated – Conversion of SAP BW or SAP BW/4HANA to SAP Data Warehouse Cloud, SAP BW Bridge

We have published an updated version (22Q2) of the “Transition to SAP Data Warehouse Cloud” roadmap with the latest information on the SAP Data Warehouse cloud solution and new links to supporting material for the implemenation project. In addition, we have included information about the SAP Data Warehouse Cloud, SAP BW bridge. SAP BW bridge is....

SAP BW4HANA DS connation (MS SQL DB) Source system via SDA

  As you are all aware now, you cannot connect DS directly to the SAP BW4HANA system, Hance needs to connect DS DB with the HANA database via SDA and create a source system. Based on customer requirements set up HANA DB connection with MS SQL DB and set up source system. Contributor Abhishek Sinha DISCLAIMER....

Some interesting Facts of Compatibility Views in SAP BW/4HANA and SAP S/4HANA

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

HANA script to substitute ABAP Function Module LAST_DAY_IN_PERIOD_GET

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

Conversion to SAP Data Warehouse Cloud: Conversion Paths and Cloud Transformation Steps

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

What’s new in SAP Data Warehouse Cloud in Q4 2021

During the final quarter of 2021 we have delivered lots of great features to SAP Data Warehouse Cloud. Join our product update sessions and get to know the major features delivered in Q4 2021. The session on January 19th, 2022 starts at 5 pm CET / 11 am ET and covers the following topics New....

ADSO Deletion Program(Inbound Table) in SAP BW

Summary This Document explains about handling ADSO  Inbound Table deletion in SAP BW Author       : Bala.G.Reddy Company   : Cognizant Technology solutions. Created on: 8TH Dec 2014. Author Bio I am Bala.G.Reddy working as Technology Architect  at Cognizant Technology Solutions, India. I  joined Cognizant Technology Solutions in 2014 and I have extensively worked on multiple SAP....

External HANA view configuration in BW4HANA

SAP Introduced new functionality from BW 7.4 on HANA where we can generate HANA view directly from B4HANA and BW on HANA application during BW object activation, The external HANA view enables to create scenarios where data, which is modeled in the BW system, are merged with data modeled in SAP HANA with SAP HANA....

Let your voice be heard – Share your feedback and complete the BARC Data Management Survey 2022

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

SAP BW4HANA Conversion Operating Modes

SAP BW/4HANA Starter Add-On is delivered as an SAP NetWeaver add-on. When the add-on is imported on an SAP NetWeaver installation, the system is in Compatibility Mode. Object types, processes and user interfaces in existing scenarios are still tolerated in this mode, but new scenarios must be implemented with the new SAP HANA-optimized object types,....

SAP BW/4HANA – SAP Blended Learning Academy inklusive Zertifizierung

SAP BW/4HANA ist ein auf SAP HANA basierendes Data-Warehouse-Anwendungspaket.Mit dieser On-Premise-Data-Warehouse-Schicht für die SAP Business Technology Platform (BTP) können Sie Daten im gesamten Unternehmen konsolidieren und so eine konsistente, abgestimmte Sicht auf Ihre Daten erhalten. SAP BW/4HANA zeichnet sich durch folgende Hauptfunktionen aus: Einfache Datenmodellierung und ‑administration Integration mit Anwendungen von SAP und anderen Anbietern Schnelle Verarbeitung großer Datenvolumen Intuitive....

Part 2 – SAP S/4HANA Cloud Data Integration Overview

After getting an overview and understanding of how Virtual Data Models (VDM) and ABAP Core Data Services (ABAP CDS Views) work in SAP S/4HANA, and the requirements needed for a CDS View to be extractable in my colleague Michael Sanjongco’s blog post Part 1 – SAP S/4HANA Cloud Data Integration to power your Intelligence Enterprise. This blog will briefly explain the....

Tunnel Live Data Connection to SAP BW or S4HANA

Introduction SAP Analytics cloud (SAC) is a new generation of Software-as-a-Service (SaaS) that redefines analytics in the cloud by providing all analytical capabilities for all user types in one product. It is built on SAP HANA Cloud Platform.  SAC is a public SaaS solution that enables access to both on-premise and cloud data sources. In....

Die vorberechnete Wertemenge oder Bucket List als Filter in einer analytischen BW Query

Diese Funktionalität wurde mit dem BW/4HANA 2.0 Support Package Stack 04 eingeführt. Die vorberechnete Wertemenge bietet die Möglichkeit die Laufzeit einer Query zu steigern, sofern die Filterwerte dynamisch ermittelt werden sollen und die ermittelte Wertemenge sehr groß sein kann. Wie geht man hierbei vor? Die betreffende Query erhält einen Filter für ein entsprechendes Merkmal. Der Filterwert....