Technical Articles
Software Logistics (SL) for SAP BW and BW/4HANA
Last Changed: 25th of January 2023
Software Logistics (SL) for SAP BW and BW/4HANA
Blog Content
- where (my) the cool stuff happens …
- SAP First Guidance
- SAP BW NLS Solution
- SAP BW/4HANA
- SAP BW Upgrade
- SAP BW Installation/Configuration on/for HANA
- SAP BW and BI-JAVA Installation
- SAP BW Migration to BWoH
- SAP BW System copy
- SAP BW Housekeeping
- Event Presentations
- Additional Topics
-
SAP BW/4HANA
-
- On the Road to BW/4HANA
– first stage accomplished – second stage finalized – choose your Path to BW/4HANA – the Road to SAP BW/4HANA – SAP BW/4HANA Content - Implementation Roadmap – Transition to SAP BW/4HANA
- On the Road to BW/4HANA
- SAP First Guidance – complete functional scope (CFS) for SAP BW/4HANA
- SAP First Guidance – complete functional scope (CFS) for SAP BW on HANA
- SAP First Guidance – deploy SAP BW/4HANA in the Azure Cloud
SAP BW/4HANA ConversionSAP Help – https://help.sap.com/viewer/p/SAP_READINESS_CHECK
Note 2934843 – Remote conversion of SEM-BCS to BCS4HANA
Note 3061594 – SAP Readiness Check for SAP BW/4HANA – Central Note
Note 3164354 – Potential Data Loss during Remote Transfer of aDSOs
Question – SAP BW System Consolidation and Upgrade to BW4HANA -
-
- SAP Community – SAP BW/4 HANA Community – Application Lifecycle Management
- SAP BW? – three things to know…
- why SAP BW/4HANA?
- Analytics with SAP | SAP HANA 2.0 – An Introduction
- SAP Product and Solution Roadmaps
- Overview SAP Business Warehouse (legacy Information)
- SAP BW(/4) on HANA Features –
Features 7.40 SP05 – Features 7.40 SP08/SP09 – Features 7.50 SP00/SP01 – Features 7.50 SP04/SP05 – Features BW/4HANA SP00 – Features BW/4HANA SP04 – Features BW/4HANA SP08 (FP01) – Roadmap BW/4HANA 2.0 – What’s new with SAP BW/4HANA 2.0 SP04 – TechEd-2020 SAP Analytics Q/A Summary (SAP DWC, SAC, BW4HANA) – Day 1 – What’s new with SAP BW/4HANA 2.0 SP07 – What’s new with SAP BW/4HANA 2021 – What’s new with SAP BW/4HANA 2021 SP04 new!
SAP BW Upgrade
Information for the Upgrade to SAP BW 7.50 and BW/4HANA:
- Presentation: Upgrade to SAP BW 7.50 (Last Update: 14th of December 2020)
- SAP BEx Community Page
- SUM for ABAP – Troubleshooting Guide
- Blog: Upgrade BW/4HANA 2.0 – the time is now …
Additional Information about the former BW release upgrades:
- Presentation: Upgrade to SAP NetWeaver BW 7.3x
- Presentation: Upgrade to SAP BW 7.40
- the Legend is back, “the Upgrade Bible“: Upgrade to SAP BW 7.0x
- Changes in SAP BEx after Upgrade to 7.3x
- SAP Business Explorer (BEx) Maintenance and Support Policy
- Good News – Easier Modeling of the SEM Add-On in Solution Manager
SL related BLOG’s:
- Maintenance Planner – The Next Generation Experience for Landscape Maintenance with SAP Solution Manager
- Downtime minimization when upgrading BW systems
- SUM in the family way
- Software Update Manager (SUM): introducing the tool for software maintenance
- Upgrade was never been easier…
ASU Toolbox (incl. BW Specific Content) and BW Upgrade pre/post Task List
With the ASU (application specific upgrade) toolbox, customers get one single truth for all pre/post upgrade steps regarding the technical upgrade to SAP BW 7.0x and all following releases.
More detailed information about the ASU toolbox can be found in note 1000009. This tool has been available since 2008 (see the TechEd Presentation and the new Upgrade to SAP BW 7.30 Presentation) has been enhanced and now allows application specific and technical resources to work together for a successful upgrade to SAP BW 7.30. Together with the BW Housekeeping Task List, there are also additional Task Lists available to simplify preparation of the application-specific part.
Implement the following SAP Note to enable usage of task list SAP_BW_BEFORE_UPGRADE via transaction STC01.Note 1734333 – BW Pre and Post Upgrade and Migration Tasks
See also the – SAP First Guidance – BW Housekeeping and BW-PCA
SAP BW and BI-JAVA Installation
The Software Logistics Toolset (SWPM) can be used to install all SAP NetWeaver 7.30 based instances onwards. See the capabilities for an up-to-date SAP Installation.
In addition the SAP BW Installation/Configuration (also on HANA) includes the complete SAP BW basis customizing settings, together with an example configuration of the system parameter. The guidance raises no claim to completeness.
See all SAP First Guidance Documents here – SAP BW on SAP HANA First Guidance Collection
The technical configuration is an elementary part of setting up and operating SAP system landscapes. For example, you have to perform initial technical configuration to bring a newly installed system into operation. But also during the lifecycle of an SAP system, technical parameters have to be set and adapted.
Blog: BI-JAVA, BEx Web and EP: the real connection…
The separation of the dual stack (ABAP and JAVA in one instance) into two separate stacks is a SAP recommendation. An option available since SAP NetWeaver BW 7.0 is the de-installation of the Java Add-In with SAPInst. This presentation provides details and guidance about the process to prepare for upgrade to SAP NetWeaver BW 7.30, concentrating on the ABAP stack.
As a successor for most scenarios, we offer the combined export of the Java system, de-installation of the Java Add-In and installation of a new Java system using the dual-stack split tool available as part of the SL toolset 1.0 (SP05). For more information, see “Dual-Stack Split”.
If you are running SAP NetWeaver 7.30 JAVA Add-In you can use the software provisioning manager 1.0 (SWPM) as part of the SL toolset for the de-installation process, as this always contains the latest software components (Note 1680045). Note that the dual split process is not supported for SAP NetWeaver 7.30 systems (Note 1655335)
With SAP NetWeaver 7.3x JAVA the Functional Unit Configuration UI (former CTC BI-JAVA Template) is available
In Advance check the WebAS/SSO Settings after the Upgrade to NetWeaver 7.3x.
The settings are almost identical to NetWeaver BW 7.0xBlog: SAP NetWeaver Portal Upgrade 7.0 to 7.4
Migration to SAP BW on SAP HANA (BWoH)
Database Migration Option (DMO) of SUM – Introduction
DMO is an option of SUM (Software Update Manager) for a combined update and migration: update an existing SAP system to a higher Software Release and migrate to SAP HANA database including the unicode conversion of the source database. The procedure is only available for systems based on AS ABAP, hence the executable SAPup is used in background. DMO migrates from an existing relational database type (“anyDB”) to SAP HANA. Software Update Manager (SUM) is the tool for system maintenance: Release upgrades, EHP implementation, applying SP stacks.
- Blog: optimizing system downtime is timeless …
- Blog: HANA 1.0 vs HANA 2.0 – plan your Migration wisely …
Please Note that since Q1/2014 the Presentation –
Migration to BW on HANA – First Guidance concludes all of these manual efforts now.
=> Updated January 2020SAP First Guidance – Using the new DMO to migrate to BW on HANA
More flexibility with SAP BW Post-Copy Automation
To reduce downtime for your production landscape, one of the recommended migration paths of SAP NetWeaver Business Warehouse (SAP NetWeaver BW) to SAP NetWeaver BW on SAP HANA comprises a system copy of your SAP NetWeaver BW system. The system copy procedure of SAP NetWeaver BW systems and landscapes is complex for a number of reasons however. A large number of configuration settings are involved for example (such as connections and delta queue handling for data loading), as well as system copy scenarios of SAP NetWeaver BW (each with different landscape aspects) that have to be handled as part of every system copy, regardless of whether the system copy is part of the migration to SAP HANA or you want to perform regular system copies of your SAP NetWeaver BW landscape.
To achieve this, SAP NetWeaver Landscape Virtualization Management offers preconfigured “task lists” used by the ABAP task manager for lifecycle management automation.
You can also enable SAP BW powered by SAP HANA to “go productive” with parallel operation of your existing production system, both connected to the same back-end systems. This is achieved with a special and unique automated solution for delta queue cloning and synchronization on production systems.
SAP Note 886102 (SMP login required) thus becomes obsolete. Using the post-copy automation for SAP BW (BW PCA) in the migration process of SAP BW to SAP BW on SAP HANA, this process can be shortened by weeks and becomes easier, faster and more reliable.
The former presentation TechEd 2014 – Session ITM206 still illustrates the migration to SAP BW on SAP HANA from an end-to-end perspective.
- BLOG: Three things to know when migrating SAP BW on SAP HANA
- BLOG: What’s the Difference between a Classic #SAPBW and #BWonHANA?
- BLOG: Migration of SAP Systems to SAP HANA
- BLOG: Where to find information on SAP BW on SAP HANA migrations
- BLOG: SAP BW Powered by SAP HANA Scale out – Best Practices
- BLOG: The SAP HANA Reference for NetWeaver Basis Administrators
- BLOG: Migration to SAP HANA: Latest News about SAP Note 1775293
SAP BW System Copy
PDF help: User Guide for SAP BW Note Analyzer
Note 2743291 – PCA for BW/4HANA
Note 2570363 – Availability of BW PCA for BW/4HANA
Note 1707321 – BW System Copy: Post Copy Automation (BW-PCA)
Note 1614266 – System Copy: Post-Copy Automation (PCA) / SAP Landscape Management (LaMa)
SAP BW 7.30 – Systemcopy ABAP => Update from January 2020
Since Release 7.30 SP05, it is now possible to perform a heterogeneous system copy (including unicode migration) to migrate existing systems based on SAP BW 7.30 SP05 and higher to SAP BW on SAP HANA (HDB) based systems.
With this major step forward, a new procedure called “Post Copy Automation (BW PCA)” now supports customers with what can often be complex post-steps before and after the homogenous/heterogeneous BW system copy. This presentation is the delta information to the existing document “SAP NetWeaver 7.30 – BW Systemcopy ABAP” shown above. The technical Improvements with the leaner data model provides advantages with BW on HANA too.
You can also refer to the SAP First Guidance Documents
– SAP First Guidance – SAP BW on HANA – Edition 2021
– SAP First Guidance – BW Housekeeping and BW-PCA
To ease this generic step of BW system copy, a new procedure called “BW Post Copy automation (BW PCA)” is available, which supports customer now in the complex pre and post steps during the homogeneous/heterogeneous SAP BW system copy (information from the SAP ALM group) procedure.
Please note that these procedure can be used independently from your BW and Database Version starting from NetWeaver 7.0x
Blog – System Copy Automation for SAP Business Warehouse System Landscapes
Blog – New Note Analyzer for SAP BW PCA and Housekeeping
Blog – System Copy Automation for SAP Business Warehouse System Landscapes (BW PCA)
We distinguish between two use cases explained in the FAQ for BW-PCA:
- Initial copy
based on an existing original BW system and connected BW source systems
Task Lists – SAP_BW_COPY_INITIAL_PREPARE (SAP BW systems only)
and SAP_BW_BASIS_COPY_INITIAL_CONFIG
Note 2534288 – HEC Service “Homogeneous System Copy / System Refresh (ABAP)
Note 2681701 – System Copy: Task Content (12.1 Improvements)
- Refresh of an existing system
based on an existing SAP BW system and connected SAP BW source systems
Task List – SAP_BW_BASIS_COPY_REFRESH_CONFIG
Updating to the minimum level of the mentioned Support Stacks is recommended to minimize the manual effort. For both cases the BW-PCA Task lists support the customer together with the software provisioning manager 1.0 (SWPM) in these software lifecycle management tasks. BW-PCA is embedded in the SAP NetWeaver Landscape Virtualization Management
SAP BW Housekeeping Tasks
Here, you will learn about various housekeeping activities that should be part of the operational concept of your Enterprise Data Warehouse. These housekeeping activities will support you in removing unwanted and unneeded data as well as unused metadata. Scheduling these activities regularly in the system will ensure optimum utilization of system resources while at the same time increasing the overall system performance.
SAP First Guidance – SAP BW Housekeeping and BW-PCA
Note 1829728 – BW Housekeeping Task List
Note 1855296 – BW Housekeeping, Upgrade and Migration Task List Improvements 1
Note 2124850 – Class CL_RSO_DTP_ERROR_LOG_DELETE is missing Housekeeping task list
Note 2407784 – How to clean up RSBKDATA and related tables
The Housekeeping Task List (Pre/Post Steps) allows you to automate mandatory tasks prior to upgrade/migration with DMO to ensure the quality of the migration process and the health of your BW System.
Blog: Create #SAP #BW Housekeeping task list
Blog: House Keeping / Performance Tuning Activities in SAP BW Systems
Blog: SAP BW-Performance Tuning through System Tables
Event Presentations
Presentation – Hitchhiker’s Guide to NetWeaver or “thank you for the fish …” (simply timeless)
Presentation – Upgrade S/4HANA Version 2020 -Basis View
Additional Topics like References, Experiences, etc.
For information about lower releases, see SAP BW 7.0 and lower – exclusively.
Product Availability Matrix (PAM) for Business Warehouse Accelerator 7.20 (BWA)
Note 1845809 – Latest Revision for BWA 7.20
Note 2495501 – BWA 7.20: Revision 41
Note 2665383 – BWA 7.20: Revision 42
Note 2887737 – BWA 7.20: Revision 44 (05.02.2020)
Note 3284562 – BWA 7.20: Revision 49 (30.12.2022)
This is a collection of resources from the former SCN Network and its content is not reflecting the findings from this document of future upgrade and enhancements.
Blog – IE11 will no longer be supported by various SAP UI technologies in newer releases
Blog – SAP BW Upgrade: Pre and Post upgrade activities with answer to why?
Blog – SAP BW 7.4 Powered by HANA — Promising Features (Part 1)
Blog – ABAP CDS in SAP BW
Blog – SAP BI4.x Installation/Update/Patching
Blog – Removal of only Time Dependent Attribute added Accidentally
Blog – Some interesting Facts of Compatibility Views in SAP BW/4HANA and SAP S/4HANA – SAP Cloud Integration into SAP BW/4HANA – further Content from Frank Riesner (SAP)
Blog – How to load Flat Files from MS Office 365 to BW/4HANA using SDI / DP-Agent
DSAG Forum: “TG Road 2 BW/4HANA” => (DSAG-ID requested) share your experience with other DSAG members.
Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics
@RolandKramer
“I have no special talent, I am only passionately curious.”
Great Compilation \ knowledge sharing of Upgrade Document.Thanks Roland for this Guide.
Thanks Roland, its very useful info.
We are planning to upgrade our BW system from 7.4 to 7.5 on HANA. For that we are looking for general BW 7.5 upgradation Checklist like Pre-upgrade BW activity and post-upgrade BW activity. More interested in Related to BW activity not basis activity.
Do you have any Checklist for BW activity?
Thanks
Ferdl
You can use the ASU toolbox for this task which is mentioned in SAP Note 1000009
Furthermore you can find additional Application Hints in the 7.50 Upgrade Presentation found above
https://blogs.sap.com/2016/10/11/software-application-lifecycle-management-sap-bw/#bwupgrade
Best Regards Roland
Hi Roland,
Thank you very much for nice content,We are planning to upgrade our
BW Upgrade 7.00 on Oracle DB to BW 7.5 Hana DB
For that we are looking for general BW 7.5 up gradation Checklist like Pre-upgrade and post-upgrade security activities as to what data we need to take back up and More interested in security related activities, Can you please help me to get started with security activities.
Hi,
Everything is described in the Blog above
https://blogs.sap.com/2016/10/11/software-application-lifecycle-management-sap-bw/comment-page-1/#bwupgrade and in the following SAP First Guidance
SAP First Guidance – Using the new DMO to migrate to BW on HANA
DMO: optimizing system downtime is timeless …
Best Regards Roland
We are interested in deploying our existing BPC 10.1 / BW 7.4 application to Azure cloud. Noticed first guidance on SAP BW4/HANA on Azure. Is an upgrade roadmap from BPC10.1 / BW7.4 to BPC11 / BW7.5 available on Azure? Our goal on BPC11 is to go back to the embedded model.
Hello John
actually there is no Upgrade from BPC10.1 / BW7.4 as it would be a so called "In-Place Conversion via an Upgrade to "BW on HANA 7.50".
For the Upgrade to SAP BW 7.50 see the following Presentation
Then you can convert to BW/4 and BPC 11.0 according to the Blog - On the Road to BW/4HANA – first stage accomplished – second stage finalized – choose your Path
As you already mentioned the SAP First Guidance – deploy SAP BW/4HANA in the Azure Cloud
there is no difference between the on-premise Deployment and the IaaS Deployment on Azure
Best Regards Roland
Hello Experts,
Finally our company decided to move our database do HANA.
We are currently in SAP BW 731 and we also use BI-IP capabilities.
When moving to BW on HANA the BI-IP capabilities will be affected? Do we need to activate anything to continue using BI-IP? Aditional licenses are necessary?
Many thanks for your help.
Best Regards,
Rui
Hello Rui
You can still use BI-IP with BW on HANA
With BW/4 you have to purchase the BPC Add-On to access the former BI-IP Application/Data again
Best Regards Roland
Hi Roland,
Is is possible to have S/4HANA and BW/4HANA on appliance and works for production scenario?
Regards,
Amit
Hi
technically yes. Furthermore I would use separate HANA Instances for S/4 and BW/4 and not a single multi-tenant instance
best regards roland
Good day!
Does any similar SAP_BW_HOUSEKEEPING task list exist for BW/4HANA? Only 7.5* mentioned in related notes.
Just trying to understand these terms lol. I hate programming languages
Thanks Roland, its great info and very useful information.
My question to you and your seek your advise here is that my company has 2 ERP systems with ECC 6 EHP 6 and SP 10 and 7 respectively. Does this upgrade of our BW systems from NW7.3 to NW 7.5 has any prerequsits on the versions of my ERP systems (meaning does my ERP's also need to go through any SP level upgrade or EHP upgrade for getting my BW system upgraded to NW7.5?
Thank you Roland for all your useful postings.
I wanted to ask for the remote conversion options, if all existing BW Analysis workbooks will need to be manually converted to point to the new SID after remote conversion. Hopefully there's a batch job or some conversion utility users can use to convert their existing BW Analysis workbooks over to the new SID?
I prefer the remote conversion option assuming there's some automated or batch method to repoint existing BW Analysis workbooks over to the new SID.
Regards,
Bruce