Creating DataSources for Master Data of
Characteristic "Product"
Use
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.
Prerequisites
File source system PC_FILE exists.
Procedure
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.
Result
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.
Continue with ...
Creating DataSources for Transaction Data