You create two DataSources for the characteristic Product. The DataSources are required to copy the master data attributes (values) and texts for the characteristic Product from the file to the BI system.
The master data for the characteristics Product Group and Channel are later created directly in the system. No DataSources are therefore required in our scenario for these characteristics.
File source system PC_FILE exists.
Perform the following procedure for the attributes and texts for characteristic Product.
...
1. You are in the Modeling functional area of the Data Warehousing Workbench.
2. Choose DataSources.
3. From the toolbar in the right screen area, choose Choose Source System.
4. In the menu option File, select the source system with the technical name PC_FILE.
A hierarchical tree of the DataSources for this source system is displayed. The DataSources are structured semantically by application component.
5. Select Create application component... from the context menu at the root node of the DataSource tree.
6. On the next screen, enter a technical name and a description for the application component.
The application component is used to group your DataSources for this scenario.
7. In the context menu of your application component, choose Create DataSource.
8. Enter the required data on the next screen.
Input Field |
Attributes |
Texts |
DataSource |
ZD_PROD_ATTRIBUTES |
ZD_PROD_TEXTS |
Data Type DataSource |
Master Data Attributes |
Master Data Text |
9. Choose Transfer.
The DataSource maintenance screen appears.
10. Enter the required data on the tab page General Info.
Input Field |
Attributes |
Texts |
Short description |
Product – Attributes |
Product – Texts |
11. Go to the tab page Extraction and define the following:
Field |
Attributes |
Texts |
Adapter |
Load Text-Type File from Local Workstation |
Load Text-Type File from Local Workstation |
File Name |
From the files of your local host, select the file Tutorial_Prod_Attr.csv. |
From the files of your local host, select the file Tutorial_Prod_Texts.csv. |
Header Rows to be Ignored |
1 |
1 |
Data Format |
Separated with Separator (for Example, CSV) |
Separated with Separator (for Example, CSV) |
Data Separator |
; |
; |
Escape Sign |
“ |
“ |
Number format |
Direct Entry |
User Master Record |
Thousands Separator |
. |
Not applicable |
Decimal Point Separator |
, |
Not applicable |
The information on the tab page is as follows for attributes:
The information on the tab page is as follows for texts:
12. Select the tab page Proposal and choose Load Examples.
13. Using the data in the file, the system creates a field proposal for the DataSource.
14. Go to the Fields tab page.
In the dialog box, choose Yes.
The field list of the DataSource is copied from the Proposal tab page.
15. Make the following changes and enhancements:
○ For the attribute:
i. Change the data type of the field PRICE from DEC to CURR and confirm your entry.
ii. Under Curr/Unit enter CURRENCY for the referenced currency/unit field
○ For the texts:
...
i. Change the data type of the field LANGUAGE from CHAR to LANG and confirm your entry.
ii. Select Language Field as the field type for the field LANGUAGE.
The field list for attributes is as follows:
The field list for texts is as follows:
16. Activate the DataSource.
17. Go to the tab page Preview and check the data before the actual load process by choosing Read Preview Data.
You created the master data DataSources for characteristic Product. At activation, a table is created for each DataSource in the entry layer of the BI system, the persistent staging area (PSA), and the source data is stored there during the transfer.
Creating DataSources for Transaction Data