A16LL
docx
keyboard_arrow_up
School
Lamar University *
*We aren’t endorsed by this school
Course
5360
Subject
Information Systems
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by LieutenantEchidna3210
Question 1: Insert a screenshot of your aDSO showing the added InfoObjects.
Question 2: What is the difference between a field and an InfoObject?
When creating applications, one works within a field, whereas an InfoObject acts as a representation of integrated pieces of information. Although a field serves as a provisional placeholder, an InfoObject embodies one of five specific attributes.
Question 3: What is the advantage of using InfoObjects instead of fields in an aDSO?
InfoObjects represent the whole company’s information while fields only have one part of the information.
Question 4: Insert a screenshot of your Data Flow and label each box with the type of object it is (not the
name).
Question 5: Why did you choose Direct Assignment for Customer?
We chose direct assignment because we are not going to make any changes to the customer.
Question 6: Can one Source object be mapped to multiple Target objects? Provide an example.
Yes, one source object can be mapped to multiple target objects. For example, when creating different reports based on the same data source, we can map the source object to multiple target objects, each with a different set of fields based on our specific reporting requirements.
Question 7: Why does the Cost of Goods Manufactured not need a Currency Key?
Because it is set to USD
Question 8: What will be the final Currency of Net Sales?
USD and Euro
Question 9: Explain, in detail, the Transformation Rule for Sales Organization.
The customer will be mapped to the sales organization based on sales date.
Question 10: Why does the Sales Data aDSO need two transformations?
One for each country. EU sales data and US sales data
Question 11: Why is ordernumber a field and not an InfoObject?
Order number is just a field because it is one specific number and not complex info.
Question 12: Why did you have to execute two DTPs?
We had to execute one for each transformation, one for US and Germany
Question 13: What would happen if you executed a DTP twice by mistake?
It would double everything.
Question 14: What is the Source object of the DTP?
DE and US
Question 15: What is the Target object of the DTP?
ADSO
Question 16: In the context of the Snowflake Schema, what type of data are you loading with these DTP?
Sales Data
Question 17: What is the difference between an aDSO and a CompositeProvider?
Composite provider is virtual data while ADSO is actual data storage.
Question 18: Is the data in a CompositeProvider persistent?
No, it is only persistent in ADSO.
Question 19: Include a screenshot of your CompositeProvider Data Preview showing the Customer drill down.
Question 20: What object in all of SAP BW/4HANA represents the Snowflake Schema?
The composite provider
Question 21: List the process (at least 10 steps) of building and populating a BW/4HANA 2.0 Data Warehouse. Refer to all previous exercises.
1. Create the key figure infoObjects
2. Create characteristic infoObjects
3. Create data source
4. Create data flow
5. Create transformation
6. Create data transfer process and load process
7. Create data source to load transaction data
8. Create an ADSO
9. Create transformation
10. Create data transfer process and load process
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help