Demo Content for the training SQLScript for BW-Consultants
Veröffentlicht am 15. Februar 2023 von | News |
This document describes the required steps to import the Transport A4HK990094 which contains the demo data model for the training “SQLScript for BW-Consultants” and a report for generating some data. Some screenshots in this document may refer to a different transport number. But A4HK990094 is the correct one.
System Requirements
Optimum: SAP BW/4HANA 2021 SP4 - The transport was crated on such a system. On other versions, the component version must be ignored during import. Post-Installation steps may be required.
Preparation steps
The source system BW_SCHEMA must exist before the import of the transport:
If BW_SCHEMA is not existing, please create a Source System of the Connection Type SAP HANA Local Database Schema, which points to the database schema of the BW system.
Import
Please tick the checkbox Ignore Invalid Component Version in the import dialog and import the transport request.
Check the Import
After a successful Imoprt, there should be four new InfoAras and some ADSOs below. The ADSOs were created with the following naming pattern:
- Prefix: ZBR_
- Exercise Number: E1, E2, E3, E4
- Suffix:
- _S - Source DSO for the Exercise
- _T0 - Sample Solution
Figure 4: Demo Content contains also some DSOs, that were created by the students of the training. They used the suffix _T<x>, where <x> is the group number.
Generation and load of the data
Execute the report ZCREATE_DEMO_DATA in transaction SA38 to generate the data. This can take some time. You can execute this step, even if the BW-Objects are inactive.
After generating the data, the DTP load in the five source ADSO for each exercise can be started:
- ZBR_E0_S
- ZBR_E1_S
- ZBR_E2_S
- ZBR_E3_S
- ZBR_E4_S
Please activate the data afterwards.
Troubleshooting
Even if the import of the request crashes, most of the content is already in the system. Due to the fact, that the BW content is required on the second day of the training, we can fix it together on the first day.
