Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

Summary

You want to either prepare or analyze your SAP BW system to move to BW on HANA or BW/4HANA. You have now (one/several) of those challenges to:

  • Identify Objects that are not needed anymore, to preserve effort and valuable memory space?
  • Align with the functional business department how many of those tenths, hundredths, thousands of Queries should be taken over/are still needed?
  • You need to reflect new requirements in data models. InfoProviders need to be adjusted?
  • While you talk to your business department they want to take over (parts/all) of the old Queries, so they can continue work?
  • You need to rebuild Data Flows and therefore need to understand complexities within flows and what actually happens?

Errors

There is not really an actual error beside the fact that many of those tasks above you have to do manually! Who likes to copy and paste information into Excel and stays focused doing that (without error) for hundreds of elements?! Of course errors can creep in here by doing mistakes in the manual steps. As this is too much of an effort you decide to go for the "supposedly" easiest way, by taking nothing/everything/doing nothing at all.

Cause

There is not really a good support for those activities above by SAP standard tools.

Solution

Use the Docu Peformer for example to:

PhaseActivitiesHow to support them with the Docu PerformerPossible Saving
(on each Activity)
Analysis
  1. Create a basis for discussion with the Functional Department what is needed in terms of reporting
  2. Identify unneeded objects that can be deleted/cleaned up
  3. Check Data Flows for (also for nested ABAP/AMDP) logic that is not always immediately visible!
  4. Understand overall complexity in mapping for the whole data flow at once
  5. Identify Queries that haven't been used for a long(er) time.
  6. Understand the dependencies from one BW Object to nearly all other elements (including ABAP/AMDP)
  7. Understand what is on which system available. Are all Queries/InfoProviders/etc. transported and available in all Systems? All all emergency changes from PROD maintained in DEV as well?
  1. /wiki/spaces/DPUM191/pages/439521177
  2. There are several Functions for that:
    1. /wiki/spaces/DPUM191/pages/439520820
    2. /wiki/spaces/DPUM191/pages/437979230
    3. /wiki/spaces/DPUM191/pages/439520859
    4. /wiki/spaces/DPUM191/pages/437979250
    5. /wiki/spaces/DPUM191/pages/437979280
  3. /wiki/spaces/DPUM191/pages/439520868
  4. /wiki/spaces/DPUM191/pages/439521188
  5. Use "Grid View" with "Column Chooser" and column "Last Used Date": /wiki/spaces/DPUM191/pages/437979007
  6. /wiki/spaces/DPUM191/pages/437979254
  7. Mass comparison: /wiki/spaces/DPUM191/pages/437979240. Individual comparison: /wiki/spaces/DPUM191/pages/437979266 (can be also triggered form the mass comparison for individual elements; mass detailed comparison coming soon)
  1. 40%-60%
  2. 20%-50%
  3. 35%-45%
  4. 20%-40%
  5. ~5%
  6. 5%-15%
  7. 50%-80%
Design

coming soon...



Implementation
  1. You need to take over data models to BW/4HANA or BW on HANA while still adjusting existing naming conventions.
  2. You want to take over (some/many/all) Queries to the new and adjusted data model to secure basic processes within functional/reporting departments.
  3. You need to translate elements in the Data Warehouse to reflect two/several languages using a dictionary instead of doing this manually.
  4. You want to use consistent Naming Conventions.
  5. Go through all DTPs and ensure that they are relevant for loading and are used/implemented in process chains.
  1. /wiki/spaces/DPUM191/pages/439517267
  2. /wiki/spaces/DPUM191/pages/439517337
  3. /wiki/spaces/DPUM191/pages/439517271
  4. /wiki/spaces/DPUM191/pages/437979234
  5. Show DTPs used and not used in process chains: /wiki/spaces/DPUM191/pages/439521184
  1. 80%-95%
  2. 80%-95%
  3. 50%-70%
  4. 5%-15%
  5. 50%-70%
Testing

more coming soon...

For Bug Fixing aspects - see also Phase "Support"



Deploy
  1. Use existing documentation and specifically added information (comments) for objects to understand additionally required procedures/impacts/etc. (special loading, activation order, etc.).

more coming soon...

  1. /wiki/spaces/DPUM191/pages/437979101 + /wiki/spaces/DPUM191/pages/437978998 especially: /wiki/spaces/DPUM191/pages/437979140
  1. ~5%
Support
  1. Support general resolutions for data:
    1. You need to understand how mappings are done within Data Flows, to be able to identify errors.
    2. Here it is also important to understand what ABAP/AMDP routines do and
    3. if there are any relevant DTP/IP Filter and selections that influence processing or that has been changed due to singular events (testing, one time loading etc.) but have not been reversed.
  1. /wiki/spaces/DPUM191/pages/439520868 - here especially:
    1. /wiki/spaces/DPUM191/pages/437979272
    2. /wiki/spaces/DPUM191/pages/437979293
    3. /wiki/spaces/DPUM191/pages/439521184
  1. 15%-40%
    1. 20%-50%
    2. ~10%
    3. ~10%
Documentation
  1. Preserve knowledge for later use, changes in team structure etc.
  2. Creating documentation for different target groups (Functional Department, Audits, IT, etc.)
  1. /wiki/spaces/DPUM191/pages/437979101
  2. /wiki/spaces/DPUM191/pages/437978998 especially: /wiki/spaces/DPUM191/pages/437979140
  1. at least 15% depending how well used later!
  2. 10%-40%
  • No labels