Freelancers
Cancel
 Sign In
Join Now

BW ON HANA

When comes to SAP BW upgrade many companies may have many questions but the most asked  question is should we upgrade to BW4HANA or BW ON HANA. I would like to explain briefly the difference between both and what should be the approach and what  are the most important steps to take care after the....

CDS View Metadata Tool

After longtime, I’m writing blog in SAP , hope it will be useful who are working with CDS Views. About Author: I Nanda Anantha working in SAP BW/ABAP and HANA for last 18 years and written few blogs in past and my interest is exploring and learning new things in SAP. Why I’m writing this blog?....

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

Amount in certain currency is multiplied by 100 at Report Level

Hari Boda is working as a SAP Lead BW-HANA consultant at TekLink Software Pvt  Ltd and has worked on multiple assignments in BW-HANA analytics  domain. Brief about issue: Amount in certain currency is multiplied by 100 in bex report in other terms the decimal places in a query is returning wrong values, sometimes the amount....

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

Enable hidden Fields of SAP BW DataSource

Fields hidden by SAP in Standard BW Data Sources Many a times you would have observed that there are a few fields present in the extract structure of the SAP BW datasource but are not available in RSA6 or the data source which is replicated in BW. This blog talks about all steps as to....

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

System Copy Automation for SAP Business Warehouse System Landscapes (BW PCA)

System copy configuration of SAP Business Warehouse (SAP BW and BW/4HANA) system landscape is highly complex due to the many connections between the involved application systems. Typically such a system landscape contains SAP BW (incl. BW/4HANA) systems, BI Java systems and SAP BW source systems such as SAP ERP, SAP CRM and SAP SCM etc.. ....

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

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

How to backup context of composite provider ?

Life is forcing you sometimes to change the context of composite provider. Many times I had a situation when I have to replace the ADSO to CalcView. But what if somethings goes wrong and you have to recreate assignments for all object once again ? It is not simple, in perfect world there should be....

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

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

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

SAPIQDB NLS SPS Upgrade Solutions

Introduction:This article speaks about the patching of SAPIQ server starting from the need, scope , pre-requisites, actual activity and post steps in brief documentation. Why patching of SAPIQ server is required?To patch SAPIQDB server whenever the corresponding HANA DB SPS version is upgraded. For better performance always recommended to update to the latest version as....