Creating DataSources for Transaction
Data
Use
You create a transaction data DataSource to copy the sales data from the file to the BI system.
Prerequisites
File source system PC_FILE exists.
Procedure
1. In the Modeling area of the Data Warehousing Workbench, choose DataSources.
2. In the context menu of your application component, choose Create DataSource...
3. In the next screen, enter ZD_SALES for DataSource and select Transaction Data as the Data Type DataSource.
4.
Choose 
Transfer.
The DataSource maintenance screen appears.
5. On tab page General Info. enter Sales Data as Short description.
6. Go to the tab page Extraction and define the following:
Field |
Entry/Selection |
Adapter |
Load Text-Type File from Local Workstation |
File Name |
File of your workstation, select the file Tutorial_Trans.csv. |
Header Rows to be Ignored |
2 |
Data Format |
Separated with Separator (for Example, CSV) |
Data Separator |
; |
Escape Sign |
“ |
Number format |
Direct Entry |
Thousands Separator |
. |
Decimal Point Separator |
, |
7. {0>»
8. <}0{>
9.
Go to tab page Proposal and choose 
Load Example
Data to
create a proposal for the DataSource.
11. 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.
12. Make the following changes and enhancements:
...
a. Change the data type for the following fields from CHAR to...
Field |
Data type |
CALENDERDAY |
DATS |
QUANTITY |
QUAN |
UNIT |
UNIT |
REVENUE |
CURR |
CURRENCY |
CUKY |
b. Under curr/unit, enter UNIT as the name of the referenced currency/unit field for the field QUANTITY and CURRENCY for the field REVENUE.
c. Change the Format for the field REVENUE from internal to external.
13. Activate the DataSource.
14.
Go to the tab page
Preview and check the data before the actual load process
by choosing Read Preview Data.
Result
You created the DataSource for the sales data. At activation, a table is created for the DataSource in the entry layer of the BI system, the Persistent Staging Area (PSA), and the data is stored there during the transfer.
Continue with ...
Creating Transformations for Master Data of Characteristic "Product“