Upload Historical Data from Smart Stream using Flat File Source System.
PREREQUISITES:
INFOCUBE/INFOPROVIDER has been defined.
Steps Screenshot
1. CREATE FLAT FILE DATASOURCES
Note: InfoObjects must be defined
before creating the Data Structure.
Go to RSA1 Tcode -> DataSources
Go to File -> PC_FILE DataSources
Right click to Create DataSource.
Enter a DataSource name.
Source system should be PC_FILE and
Select Data Type of DataSource, in our
example we will use Transaction Data.
General Info tab - provides information
on the Data Source created.
Enter Short, Medium and Long
Description of Datasource.
Extraction tab – provides details of file
to be extracted.
Select Adapter Type: choose between
Local Workstation or Application
Server.
Filename - Select name of file using F4,
search for the file on your local desktop
Header rows to be ignored = ‘1’ (if file
has a header row as column titles) or
= ‘0’ (if file has no header row)
Select Data Format as – “Separated
with Separator (for ex CSV)”. Enter the
Data Separator as ‘,‘.
Proposal tab – provides a quick view of
the data in the flat file to be uploaded
Click on the ‘Load Example’ tab. The
details can be viewed in the below pane
Fields tab – provides details of all fields
used to create a data structure, to map
with the fields from Source file.
Make sure that the fields are in the
same sequence with the CSV file.
Check before you activate. If there is
error or warning message you can use
Performance Assistant.
Preview tab – gives a preview of data
on flat file loaded onto a structure.
Click on “Read Preview Data” to display
the data.
2. CREATE TRANSFORMATION
Note: InfoCube/InfoProvider must be
defined to create transformation.
Go to specific InfoCube then right click
to Create Transformation.
For the Target of Transformation,
- Enter Object Type: InfoCube (this is
our target in this scenario)
- Enter the name of the InfoCube that
we will use.
For the Source of Transformation,
- Enter Object Type: DataSource (this is
our source structure)
- Enter name of Data Source we created
and Source System will be PC_FILE.
Once the Transformation has been
created, map the fields from
DataSource to specific InfoObjects in
InfoCube.
You can use rule details such as
Formula, Routine(ABAP Program) and
other rule types to format the data for
specific InfoObject.
Save and Activate, if the mapping is
done correctly.
3. DATA TRANSFER PROCESS
Infocube -> DTP -> right click to create
The DTP name is described as :
< DataSrc/SourceSys -> InfoObject >
DTP type : Standard
Target of DTP :
Object Type : InfoCube
Name: Name of the InfoCube
Source of DTP
Object Type: DataSource
DataSource: Name of DataSource we
created.
Source System should be PC_FILE.
Extraction tab:
Select Extraction Mode: Full or Delta.
We will use Delta for this example.
Click Execute to trigger the Data
Transfer.
4. INFOPACKAGE
DataSources -> right click to Create
InfoPackage
Enter InfoPackage Description then
Save.
In Extraction tab, change the Filename
to location of the CSV File we will use.
Header rows to be ignored = ‘1’ (if file
has a header row as column titles) or
= ‘0’ (if file has no header row)
Select Data Format as – “Separated
with Separator (for ex CSV)”. Enter the
Data Separator as ‘,‘.
You may execute the InfoPackage in
Schedule tab. Click Start to execute.
