Modernizing SAP BW: BW Private Cloud Edition, the Data Product Generator and Query Regression Testing

Keep this: job aid

BW modernization and query regression card

• Dates: BW 7.5 mainstream ends 2027; extended and BW 7.5 in BW PCE end 2030; BW/4HANA to 2040.
• Paths per use case: retire, lift (BW PCE), expose (DPG), rebuild (Datasphere), convert (BW/4HANA).
• Lift prerequisites: BW 7.5 on SAP HANA SPS 24+; BW/4HANA 2021 SPS 04+; older BW/4HANA to 2023.
• Inventory: queries (usage over a full year), providers, flows, routines, chains, RSECADMIN authorizations.
• Every routine in scope → plain-language rule → regression case.
• DPG: RSDPS (BW 7.5) or Data Subscription app (BW/4HANA) → BW inbound space → Data Sharing Cockpit.
• Reconcile each BW data product to its InfoProvider by group; redesign access in Datasphere.
• Query regression: freeze data, stored variants, baseline, change, rerun, compare cell by cell, zero tolerance.
• Watch currency, exception aggregation, hierarchies, non-cumulatives, restricted key figures, routines.
• Coexistence: one official source per KPI; parallel run one close; decommission with history, retention and source cleanup.