SAP BW Migration Assessment Questions

SAP BW Migration Assessment Questions

Migration Motivation

Creation of new use-cases is very slow (slow time-to-market)
We need to onboard many non-SAP data sources and analyze them with SAP data
BW and related systems are costly to operate
Hard/Impossible to integrate SAP data (master data) with non-SAP applications
Performance issues with BW
Users without access to SAP BW analyze data via Excel, resulting in many different “sources of truth” (governance problem)
Need the ability to use modern analytical tools like PowerBI/Tableau/Looker and python

Existing System Landscape

Your SAP EPRs (Data Sources)

  1. How many SAP ERP instances do you have? ECCs? S/4HANA? S/4HANA on Rise?
  2. Any other SAP and non-SAP data sources that need to be ingested in BW?

Reporting layer

Which reporting tool do you already use?

  1. SAP BO, SAP Lumira, SAP Analytics Cloud
  2. PowerBI, Tableau or Looker

Your SAP BW

  1. Are you using BW classic, BW 7.5 on HANA, or BW/4HANA?
  2. How many instances of BW do you have?
  3. How much data do you have stored in your SAP BW (in GBs, approximately)?
  4. How many SAP-named users access your SAP BW (approximately)?
  5. Are any other SAP-related hard deadlines coming soon? SAP license needs to be extended, SAP hardware is coming out of support, …?

High-Level Migration Complexity Estimation

  1. How many data reporting cubes/composite-provides need to be fully re-engineered?
  2. How many data reporting cubes/composite-provides can be lift-and-shifted?
  3. Which use-cases are not necessary to migrate at all?
  4. How many custom ABAP functions and classes exist? (we can guide you on how to find out)
  5. How many reports/dashboards do you currently have (approximately)?
  6. Do you need your reports to be updated in (near) real-time?
  7. Do you have any specific security requirements?

Precise Use-Case Level Complexity Estimation

  1. How many BW objects does the use-case rely on?
    1. Data Sources/Extractors
    2. Info Sources
    3. Info Objects
    4. Cubes
    5. ADSOs, DSOs
    6. Composite Providers, Multi-Providers
    7. Transformations, Update Rules
    8. Hana Calculation Views
  2. How many lines of unique custom ABAP code pieces (functions, classes) and the overall number of code lines
  3. Which objects and transformations might be removed (duplicate table due to performance optimization, authorization separation, …)

Return to SAP BW to Databricks migration