Summary
You want would like to either prepare or analyze your current SAP BW system for the migration to move to "BW on HANA" or BW/4HANA. You have now (one/several) of those challenges to?
Challenges to be met:
- Identify Objects entities that are not no longer needed anymore, to preserve save effort and valuable memory storage space?.
- Align Discuss with the functional business department how many of those tenthsthe tens, hundredthshundreds, or thousands of Queries should be taken over/queries are still needed ?You need to reflect and have to be considered for the migration.
- Reflect new requirements in data models. InfoProviders need to must be adjusted?.
- While you talk are talking to your business department, they want to take over (parts/all) of the old Queries , so that they can continue their work?.
- You need have to rebuild Data Flows Streams and therefore need to understand complexities the complexity within the flows and what actually happens?
Errors
...
Problems
Many of the above tasks have to be done manually because there is no real support through standard SAP tools.
Who likes to copy and paste information into Excel and stays focused concentrate on doing that this (without errorerrors) for hundreds of elements?!
Of course, errors can creep in here by doing making mistakes in the manual steps. As Since this is too much of an effort, you decide to go for on the "supposedly" easiest way , by taking nothing/everything/doing doing nothing, all, or 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:products of the Performer Suite.
Example
Phase | Activities | How to support them with the Docu Performer Possible SavingSuite | Time-saving potential (on with each Activityactivity) |
---|
Analysis (System Scout) | - Create a basis for discussion with the Functional Department about what is needed in terms of reporting
- Identify unneeded objects that can be deleted/cleaned up
- Check Data Flows for (also for nested ABAP/AMDP) logic that is not always immediately visible!
- Understand the overall complexity in mapping, for the whole data flow at once
- Identify Queries that haven't have not been used for a long(er) time.
- Understand the dependencies from one BW Object to nearly all other elements (including ABAP/AMDP). The usage must also be checked in frontend objects (BO, SAC) to find out which Queries are relevant for the migration as they are used as data sources.
- Understand what is on which system is available. Are all Queries/InfoProviders/etc. transported and available in all Systems? All Are all emergency changes from PROD maintained in DEV as well?/wiki/spaces/DPUM191/pages/439521177
| - Matrix of Usage
- There are several Functions System Scout functions for that:
- /wiki/spaces/DPUM191/pages/439520820
- /wiki/spaces/DPUM191/pages/437979230
- /wiki/spaces/DPUM191/pages/439520859
- /wiki/spaces/DPUM191/pages/437979250
- /wiki/spaces/DPUM191/pages/437979280
- /wiki/spaces/DPUM191/pages/439520868
- /wiki/spaces/DPUM191/pages/439521188
- InfoProvider without Data Flow
- Data Loads and Usages
- Inactive Entities
- Unused InfoObjects
- Variable Analyzer
- Data Flow Analysis
- Mapping analysis in the data flow for individual IOBJs:
Data Lineage Analysis for all IOBJs - Use "Grid View" with "Column Chooser" and the column "Last Used Date": /wiki/spaces/DPUM191/pages/437979007/wiki/spaces/DPUM191/pages/437979254 Column Chooser
- Usage of BW Entities
- 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) System Comparison.
Individual comparison: Compare BW Entities
| - 40%-60%
- 20%-50%
- 35%-45%
- 20%-40%
- ~5%
- 5%-15%
- 50%-80%
|
---|
Design | coming soon... If you have a good idea, please let us know how we can support you even more and create a feature request! | Implementation | Implementation (Migration Booster & Translation Steward) | - You need to take over data models to BW/4HANA or BW on HANA while still adjusting existing naming conventions.
- You want to take over (some/many/all) Queries to the new and adjusted data model to secure basic processes within functional/reporting departments. Before that, it must be clarified with the business user which Queries should be considered for the new BW/4HANA system.
- You need to translate elements in the Data Warehouse to reflect two/several languages using a dictionary instead of doing this manually.
- You want to use consistent Naming Conventions.
- Go through all DTPs and ensure that they are relevant for loading and are used/implemented in process chains.
| - /wiki/spaces/DPUM191/pages/439517267
- /wiki/spaces/DPUM191/pages/439517337
- /wiki/spaces/DPUM191/pages/439517271
- /wiki/spaces/DPUM191/pages/437979234Migrate InfoProvider & InfoObjects
- Collect & import objects from a data flow
- Renaming and remodeling of objects
- Export modeled objects to SAP
- Copy Reporting Elements and optionally create a backup of a Query, which can be restored at a later point in time in the new BW/4HANA system.
- Translate the newly created objects
- Check Naming Conventions of BW Entities with System Scout (also possible from transports)
- Show DTPs used and not used in process chains: /wiki/spaces/DPUM191/pages/439521184 Show DTPs and InfoPackages incl. Filters
| - 80%-95%
- 80%-95%
- 50%-70%
- 5%-15%
- 50%-70%
|
---|
Testing | more coming soon... For Bug Fixing aspects - see also Phase "Support" If you have more good ideas, please let us know how we can support you even more and create a feature request!
| Deploy | Deploy (Docu Performer) | - 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... If you have a good idea, please let us know how we can support you even more and create a a feature-request!
| - /wiki/spaces/DPUM191/pages/437979101 + /wiki/spaces/DPUM191/pages/437978998 especially: /wiki/spaces/DPUM191/pages/437979140BW Commenting + BW Documentation especially: Scenarios
| - ~5%
|
---|
Support (System Scout) | - Support general resolutions for data:
- You need to understand how mappings are done within Data Flows, to be able to identify errors.
- Here it is also important to understand what ABAP/AMDP routines do and...
- ...if there are any relevant DTP/IP Filter and selections that influence processing or that has have been changed due to singular events (testing, one-time loading, etc.) but have not been reversed.
| - /wiki/spaces/DPUM191/pages/439520868 Data Flow Analysis - here especially:
- /wiki/spaces/DPUM191/pages/437979272
- /wiki/spaces/DPUM191/pages/437979293
- /wiki/spaces/DPUM191/pages/439521184Mapping Analysis of InfoObjects
- Look-Up Analysis
- Show DTPs and InfoPackages incl. Filters
| - 15%-40%
- 20%-50%
- ~10%
- ~10%
|
---|
Documentation (Docu Performer) | - Preserve knowledge for later use, changes in team structure, etc.
- Creating documentation for different target groups (Functional Department, Audits, IT, etc.)
| - /wiki/spaces/DPUM191/pages/437979101
- /wiki/spaces/DPUM191/pages/437978998 especially: /wiki/spaces/DPUM191/pages/437979140BW Commenting
- BW Documentation especially: Scenarios
| - at least 15% depending on how well it is used later!.
- 10%-40%
|
---|