Achieve faster results in SAP BW with snapshots thanks to query analysis

Transaction /PBS/NLSA_MD for managing master data and hierarchy snapshots

Selection InfoCube/DSO

List of suitable master data and automatic DSP generation

The generation of snapshots is an effective method for reducing the response time of queries with access to nearline data. To this end, copies of master data and hierarchies are saved in the nearline database. The query is then processed to a large extent in the nearline database, which considerably reduces the runtime and places less load on the BW application server. But which master data and hierarchies are most suitable for snapshots?

You can easily find the answer to this question with the new query analysis. You start the analysis directly from the central transaction for managing master data and hierarchy snapshots. It is executed on the basis of specified InfoCubes and DataStore objects. First, the queries that contain the specified InfoProviders are determined internally. If a master record or hierarchy contains a specified number of characteristics, they are proposed for a “Data Snapshot Process” (DSP). You can create this process directly from the result list. The process represents a type of infrastructure for the actual copy process, which you can execute at any time, e.g. at times when the load is lower. If the copies of master data and hierarchies are saved in the nearline database, they are linked with the InfoCube data. This significantly reduces the query response time.

SAP BW

BW 7.0 BW 7.3 BW 7.4 BW 7.5
CBW for SAP NLS Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar aDSO
Verfügbar InfoCubes, DSO and PSA
CBW NLS DB2 Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar aDSO
Verfügbar InfoCubes, DSO and PSA
CBW NLS IQ Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar aDSO
Verfügbar InfoCubes, DSO and PSA
CBW NLS Vector Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar InfoCubes, DSO and PSA
Verfügbar aDSO
Verfügbar InfoCubes, DSO and PSA



  Available
  Available (with NAI Functionality)
  In development