--- title: "Optimizing SAP BW/4HANA: Monitoring and Data Management" description: Optimize SAP BW/4HANA operations with enhanced monitoring, mobile access, and efficient data management for superior performance and streamlined admin. image: https://blog.sap-press.com/hubfs/Optimizing%20SAP%20BW_4HANA%20Operations_%20Streamlined%20Monitoring%20and%20Efficient%20Data%20Management.png --- [![rheinwerk-sappress-logo-header-1](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://blog.sap-press.com/) [Blog](https://blog.sap-press.com) - Books - Get an overview of our books and courses on every relevant SAP topic. - [Programming](https://sap-press.com/programming/) - [Administration](https://sap-press.com/administration/) - [BI](https://sap-press.com/business-intelligence/) - [Finance](https://sap-press.com/finance-controlling/) - [Logistics](https://sap-press.com/logistics/) - [HR](https://sap-press.com/human-resources/) - [CRM & Sales](https://sap-press.com/marketing-sales/) - [HANA](https://sap-press.com/hana/) - [Introductions](https://sap-press.com/introductions/) - [E-Bites](https://sap-press.com/e-bites/) - [Certification Guides](https://www.sap-press.com/certification-guides/) - [Rheinwerk Courses](https://www.sap-press.com/online-courses/) - Book Subscription - Get unlimited access to all SAP PRESS books! - [SAP PRESS Subscription](https://sap-press.com/subscriptions/) [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) # Optimizing SAP BW/4HANA: Monitoring and Data Management ![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg) by [SAP PRESS](https://blog.sap-press.com/author/sap-press) Discover how SAP BW/4HANA 2.0 streamlines operations with enhanced process chain monitoring, mobile access, and optimized data management for improved performance and efficiency.   Once the first data flows have been developed in [SAP BW/4HANA](https://learning.sap-press.com/sap-bw4hana), they can be used in a productive operation, while the remaining developments and maintenance work continues in parallel. An essential task in the operation of SAP BW/4HANA is certainly the monitoring of the process chains.   Typically, the loading of your data targets takes place whenever the fewest users work with the data, i.e., at night and on weekends. The new process chain app presented in this blog post is a significant relief for the application management teams. The new monitoring views, which give you an overview of the extract, transform, and load (ETL) business and the accumulated data volume in real time, are also helpful. ## Data Warehousing Workbench SAP BW/4HANA 2.0 does not leave much of the former data warehousing workbench (Transaction RSA1) in [SAP BW](https://learning.sap-press.com/sap-data-management#SAP-Business-Warehouse) 7.5. The **Modeling** area has completely disappeared, as you can see in this figure.   ![Data Warehousing Workbench in SAP BW/4HANA 2.0](https://blog.sap-press.com/hs-fs/hubfs/image-png-Feb-13-2025-02-15-16-5606-PM.png?width=441&height=753&name=image-png-Feb-13-2025-02-15-16-5606-PM.png)   The **Administration**, **Transport Connection**, **Documents**, **BI Content**, **Translation,** and **Metadata Repository** areas remain almost unchanged in SAP BW/4HANA 2.0. Only the contentof the **Administration** area underwent significant changes: - The administration of the source systems was transferred from **modeling** to the **Administration** - The monitors **Realtime Data Acquisition**, **Load Data**, **Change Run**, **Copy Data Flow**, **Precalculation Server**, and **DataStore Objects** have been removed. - The functions **Realignment Run**, **Broadcasting**, **Migration 3.x Objects**, and **Mass Activation of BAdI SPOs**, the administration cockpit, and the transaction **External SAP HANA View** for administering the external [SAP HANA](https://learning.sap-press.com/sap-hana) view for an SAP BW object have been removed from the **Administration** - The tasks **Archiving Request Administration**, **Executing the BW Housekeeping List**, and **Monitoring the BW Housekeeping List** have been removed from the **Housekeeping Tasks** - Compared to SAP BW/4HANA 1.0, version 2.0 replaced the data aging in **Housekeeping Tasks** with the options **DTO Temperature Maintenance** and **DTO Execution**. - The **OLAP Cache** entry has been removed from the **Current Settings** The functions **Transport Application Components**, **Transport InfoAreas**, **Unit Conversion Type**, **Currency Translation Type**, and **Time Characteristics** have been added to the **Current Settings** folder. - **Overview SAP HANA Remote Subscriptions** has been added to **Monitors**. All in all, the administrator of SAP BW/4HANA has to cope with a whole series of changes that are related to the fact that SAP BW/4HANA manages with a smaller number of modeling objects than previous SAP BW releases. BI functions such as broadcasting were transferred to the SAP BusinessObjects BI suite. The modeling takes place with the SAP BW modeling tools in Eclipse. ## Process Chains App With the process chain app, shown in the figure below, you can monitor your process chains from your smartphone and initiate repair measures if necessary.   ![Process Chain Mobile Monitoring Application](https://blog.sap-press.com/hs-fs/hubfs/image-png-Feb-13-2025-02-15-53-8585-PM.png?width=648&height=838&name=image-png-Feb-13-2025-02-15-53-8585-PM.png)   As in previous SAP BW releases, you can enter the process chains to be monitored in a list in the *monitor for monitoring periodic process chains* (Transaction RSPCM). Since the process chain app is based on [SAP Fiori](https://learning.sap-press.com/sap-fiori), it can be called using a URL in a web browser. On SAP Cloud Appliance Library, your URL is *http://vhcala4hci.dummy.nodomain:54410/sap/bc/ui5\_ui5/sap/rspcm\_web/index.html? sap-client=001* for client 001.   A link to this URL is located in the **Administration Monitors Process Chain App** folder of the data warehousing workbench. In case of issues follow the instructions on *[http://s-prs.co/v454459](http://s-prs.co/v454459)*. On SAP Cloud Appliance Library, we activated the [SAPUI5](https://learning.sap-press.com/sapui5)application for process chain monitoring. Call Transaction SICF and select the service name **RSPCM\*.** Conform with **Execute**. Navigate to **default\_host >** **sap >** **bc >** **ui5 > ui5 >** **sap** and then right click on the service **rspcm\_web.** Activate the service using the context menu, as shown in the next figure. In the **Activation of ICF Services** dialog box choose the second **Yes** button. ![Activating the SAPUI5 Application for Process Chain Monitoring](https://blog.sap-press.com/hs-fs/hubfs/image-png-Feb-13-2025-02-16-24-6821-PM.png?width=1472&height=704&name=image-png-Feb-13-2025-02-16-24-6821-PM.png)   Repeat these steps for the service **rspcm\_gw\_service\_srv** in **default\_host >** **sap >** **bc >** **ui5 >** **ui5 >** **sap**.   ## Process Types Compared to SAP BW 7.5, there are numerous differences in the process types used in SAP BW/4HANA 2.0. Only the process type **General Services** for controlling the process chain and the **Other** group remain the same. The **Reporting Agent**, **Retail**, **Global Spend Analyses**, and SAP Business Planning and Consolidation process types groups no longer appear.   In SAP BW/4HANA, changes have also been made to the process types in the following groups: - **Loading process and postprocessing:** All process types related to the persistent staging area and InfoPackages, 3.x objects, InfoCubes, and broadcaster events have been removed. The process type *Start SAP HANA EIM Remote Subscription*, with which you can use a remote source as a deltaenabled data source if it supports the delta update, has been added. - **Data target administration:** All process types that are related to the SAP Business Warehouse Accelerator, InfoCubes, classic DSOs, and the persistent staging area (PSA) have been removed. The process type *Request Deletion from DSO (advanced)* has been replaced by the process type *Clean Obsolete Requests in DataStore Objects (adv.)*. The new process type allows you to define the cleanup action (activate requests, remove old requests from the inbound table, or remove old requests from the changelog). As a limitation, both a certain number of days and a certain number of requests can be excluded from the cleanup. - **Other SAP BW Processes:** The attribute change run, the analysis process, and the switching of real-time InfoCubes between planning mode and load mode have been removed. Process types for switching aDSOs between planning and loading mode were added for this purpose. The process chains are managed in *process chain maintenance* (Transaction RSPC) as in previous SAP BW releases. ## Triggering a Delta Merge Data changes in SAP BW/4HANA are first stored in a *delta store.* Several deltas are then transferred to the *main store* using the SAP HANA *delta merge* function. However, read access always reads both storage areas so that the database remains consistent.   Suppose an aDSO receives data across multiple data transfer processes. In that case, load balancing problems can occur in the SAP HANA database if each data transfer process (DTP) executes a delta merge function independently of the other DTPs. It therefore makes sense to deactivate the **Trigger database merge** option for these DTPs, as shown in this figure. ![Deactivating a Delta Merge in the Data Transfer Process](https://blog.sap-press.com/hs-fs/hubfs/image-png-Feb-13-2025-02-16-49-3138-PM.png?width=1232&height=626&name=image-png-Feb-13-2025-02-16-49-3138-PM.png)   After all data transfer processes have written their data to the aDSO, you can execute a delta merge for all requests involved together, controlled by a process chain (see figure below). Execute the merge directly or, alternatively, you can schedule it to run regularly in a process chain.   ![Scheduling the Delta Merge of an aDSO in the Process Chain in SAP BW/4HANA](https://blog.sap-press.com/hs-fs/hubfs/image-png-Feb-13-2025-02-17-12-2243-PM.png?width=1187&height=750&name=image-png-Feb-13-2025-02-17-12-2243-PM.png)   *The Trigger Delta Merge* process type is in the **Loading Process and Postprocessing** group. You can define delta merge operations for multiple aDSOs in one step.   ## Monitoring Views for Core Data Services *Core data services* (CDS) is an SAP standard for defining persistent objects. For monitoring, it is sufficient to know that the CDS language is based on SQL-92. Therefore, there are also CDS views.   For SAP BW/4HANA, CDS views have the advantage that you can make standard queries directly in SAP HANA Studio based on these views. This table gives you an overview of the standard SQL views.   ![Monitoring Views for SAP BW/4HANA in SAP HANA Studio](https://blog.sap-press.com/hs-fs/hubfs/image-png-Feb-13-2025-02-17-34-5375-PM.png?width=1011&height=478&name=image-png-Feb-13-2025-02-17-34-5375-PM.png)   To access a monitoring view, log on to SAP HANA Studio with your SAP BW/4HANA system user SAPHANADB. Then open the context menu of the **Views** folder and filter the display in schema SAPHANADB according to the view you require. In the context menu of this view, choose **Open Data Preview**. On the **Analysis** tab in the dialog that opens, you can define your monitoring query. The figure below shows, for example, the average load time of aDSO requests that are based on CDS views.   ![Example of a Monitoring Query in SAP HANA Studio](https://blog.sap-press.com/hs-fs/hubfs/image-png-Feb-13-2025-02-17-57-8692-PM.png?width=1184&height=723&name=image-png-Feb-13-2025-02-17-57-8692-PM.png)   Here, you can see the average as well as the total loading time of aDSO requests. Here you can see that the times for the *PartProviders* of the semantic group, that is, the semantically partitioned aDSOs, are far below the loading time of the original aDSO POS\_ADSO. This is because the PartProviders receive less data. However, the sum of loading times is still well below the average for the entire database. This shows that semantic partitioning also promises performance advantages when loading.   The times for the open hub destination are only slightly above those of a PartProvider. Therefore, data export to legacy systems can be considered uncritical.   ![Optimizing SAP BW/4HANA Operations](https://blog.sap-press.com/hs-fs/hubfs/bw4hana_monitoring_process_chain_mgmt_infographic.png?width=1275&height=1800&name=bw4hana_monitoring_process_chain_mgmt_infographic.png) [![Want to save this infographic? Click here to download!](https://no-cache.hubspot.com/cta/default/5707200/c4442517-6a9b-4474-b042-00c1b6789fa8.png)](https://cta-redirect.hubspot.com/cta/redirect/5707200/c4442517-6a9b-4474-b042-00c1b6789fa8)   Editor’s note: This post has been adapted from a section of the book [*SAP BW/4HANA 2.0: The Comprehensive Guide*](https://www.sap-press.com/sap-bw4hana-20_4544/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=1635_chapter5&utm_content=1635) by [Thorsten Lüdtke](https://www.linkedin.com/in/biportal/) and Marina Lüdtke. Thorsten is an independent SAP BI architect and founder of BIPortal GmbH ([https://bi-portal.com](https://bi-portal.com)). He specializes in data warehouse architectures based on SAP BW/4HANA, SAP HANA, and [SAP Data Intelligence](https://learning.sap-press.com/sap-data-management#SAP-Data-Intelligence). Marina is the managing director of BIPortal GmbH in Hamburg, Germany. Previously she worked as a sales representative for various chemical companies in Germany, East Africa, and South America.   This post was originally published in 2/2025. ## Recommendation [![SAP BW/4HANA 2.0](https://blog.sap-press.com/hs-fs/hubfs/social-suggested-images/1635%20-%20new%20trim%20size-Jul-06-2023-02-49-31-7972-PM.jpg?width=170&name=1635%20-%20new%20trim%20size-Jul-06-2023-02-49-31-7972-PM.jpg)](https://www.sap-press.com/sap-bw4hana-20_4544/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=1635_chapter5&utm_content=1635) **SAP BW/4HANA 2.0** Ready for SAP BW/4HANA 2.0? Whether you're an architect, administrator, or developer, this comprehensive guide is for you. Start with a new installation or migrate from an existing SAP BW system. Then walk through major administration, security, and data management tasks. You'll learn to model data, convert ABAP transformations, use embedded SAP BPC for planning, connect to SAP Analytics Cloud, and more. The data warehouse of the future is here! [Learn More](https://www.sap-press.com/sap-bw4hana-20_4544/?utm_source=sappressblog&utm_medium=referral&utm_campaign=Blogs&utm_term=1635_chapter5&utm_content=1635) ![SAP PRESS](https://blog.sap-press.com/hubfs/Twitter_profile_pic.svg) **by [SAP PRESS](https://blog.sap-press.com/author/sap-press)** SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP IBP, intelligent technologies, SAP Business Technology Platform, and more! [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) [![Share on facebook](https://7528309.fs1.hubspotusercontent-na1.net/hub/7528309/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/facebook-color.png?width=24&name=facebook-color.png)](https://www.facebook.com/share.php?u=https%3A%2F%2Fblog.sap-press.com%2Foptimizing-sap-bw4hana-operations-streamlined-monitoring-and-efficient-data-management%3Futm_medium%3Dsocial%26utm_source%3Dfacebook) [![Share on linkedin](https://7528302.fs1.hubspotusercontent-na1.net/hub/7528302/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/linkedin-color.png?width=24&name=linkedin-color.png)](https://www.linkedin.com/shareArticle?mini=true&url=https%3A%2F%2Fblog.sap-press.com%2Foptimizing-sap-bw4hana-operations-streamlined-monitoring-and-efficient-data-management%3Futm_medium%3Dsocial%26utm_source%3Dlinkedin) [![Share on twitter](https://7528304.fs1.hubspotusercontent-na1.net/hub/7528304/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/twitter-color.png?width=24&name=twitter-color.png)](https://twitter.com/intent/tweet?original_referer=https%3A%2F%2Fblog.sap-press.com%2Foptimizing-sap-bw4hana-operations-streamlined-monitoring-and-efficient-data-management%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&url=https%3A%2F%2Fblog.sap-press.com%2Foptimizing-sap-bw4hana-operations-streamlined-monitoring-and-efficient-data-management%3Futm_medium%3Dsocial%26utm_source%3Dtwitter&source=tweetbutton&text=) [![Share on email](https://7528311.fs1.hubspotusercontent-na1.net/hub/7528311/hubfs/raw_assets/public/mV0_d-web-default-modules_hubspot/img/email-color.png?width=24&name=email-color.png)](mailto:?subject=Check+out+https%3A%2F%2Fblog.sap-press.com%2Foptimizing-sap-bw4hana-operations-streamlined-monitoring-and-efficient-data-management%3Futm_medium%3Dsocial%26utm_source%3Demail&body=Check+out+https%3A%2F%2Fblog.sap-press.com%2Foptimizing-sap-bw4hana-operations-streamlined-monitoring-and-efficient-data-management%3Futm_medium%3Dsocial%26utm_source%3Demail) ### Comments ### Latest Blog Posts [![SAP BW/4HANA Process Chain Operations](https://blog.sap-press.com/hs-fs/hubfs/SAP%20BW4HANA%20Process%20Chain%20Operations.png?height=600&name=SAP%20BW4HANA%20Process%20Chain%20Operations.png)](https://blog.sap-press.com/sap-bw4hana-process-chain-operations) [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) ## [SAP BW/4HANA Process Chain Operations](https://blog.sap-press.com/sap-bw4hana-process-chain-operations) [Read More](https://blog.sap-press.com/sap-bw4hana-process-chain-operations) [![SAP BW/4HANA: Modeling, Simplified](https://blog.sap-press.com/hs-fs/hubfs/SAP%20BW4HANA%20Modeling%2c%20Simplified.png?height=600&name=SAP%20BW4HANA%20Modeling,%20Simplified.png)](https://blog.sap-press.com/sap-bw/4hana-modeling-simplified) [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) ## [SAP BW/4HANA: Modeling, Simplified](https://blog.sap-press.com/sap-bw/4hana-modeling-simplified) [Read More](https://blog.sap-press.com/sap-bw/4hana-modeling-simplified) **Subscribe to our blog!**Get notified about future blog updates. - - - - - ### The official SAP PRESS Blog As the world’s leading SAP publisher, SAP PRESS’ goal is to create resources that will help you accelerate your SAP journey. The SAP PRESS Blog is designed to provide helpful, actionable information on a variety of SAP topics, from SAP ERP to SAP S/4HANA. Explore ABAP, FICO, SAP HANA, and more! ### SAP Blog Topics - [All Topics](https://blog.sap-press.com) - [Logistics](https://blog.sap-press.com/tag/logistics) - [Programming](https://blog.sap-press.com/tag/programming) - [FICO](https://blog.sap-press.com/tag/fico) - [Administration](https://blog.sap-press.com/tag/administration) - [Business Intelligence](https://blog.sap-press.com/tag/business-intelligence) - [What Is?](https://blog.sap-press.com/tag/what-is) - [Featured](https://blog.sap-press.com/tag/featured) - [CRM & Sales](https://blog.sap-press.com/tag/crm-sales) - [Video](https://blog.sap-press.com/tag/video) - [Human Resources](https://blog.sap-press.com/tag/human-resources) ### Blog curated by [![Rheinwerk Publishing & SAP PRESS Logo](https://blog.sap-press.com/hubfs/rheinwerk-sappress-logo-header-1.svg)](https://sap-press.com) [Visit the SAP PRESS Store](https://sap-press.com) ### About - [Home](https://sap-press.com/) - [About Us](https://sap-press.com/the-publisher/) - [Contact](mailto:info@rheinwerk-publishing.com) - [Legal Notes](https://sap-press.com/legal-notes/) - [Privacy Policy](https://sap-press.com/privacy/) - [Terms of Use](https://sap-press.com/terms/) - [Guest Posting](https://blog.sap-press.com/guest-posting) © 2026 Rheinwerk Publishing, Inc. | Change Privacy Options ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "SAP PRESS", "url" : "https://blog.sap-press.com/author/sap-press" }, "dateModified" : "2026-03-13T01:06:29.065Z", "datePublished" : "2025-02-25T14:36:16.000Z", "headline" : "Optimizing SAP BW/4HANA: Monitoring and Data Management", "image" : [ "https://blog.sap-press.com/hubfs/Optimizing%20SAP%20BW_4HANA%20Operations_%20Streamlined%20Monitoring%20and%20Efficient%20Data%20Management.png" ], "mainEntityOfPage" : { "@id" : "https://blog.sap-press.com/optimizing-sap-bw4hana-operations-streamlined-monitoring-and-efficient-data-management", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://blog.sap-press.com/hubfs/Logo-1.jpg" }, "name" : "Rheinwerk Publishing, Inc." } } ```