chapter 3. Loading Data into the InfoCube
3.1 Creating a Source System
Select Source systems under Modelling in the left panel. In the right panel, right-click Source systems and select Create...
choose file system (because data is in the excel sheet),
then press ok and you can see the flat file in the file folder
3.2 Creating an Application Component
Select InfoSources under Modelling in the left panel. In the right panel, right-click InfoSources and select Create application component...
3.3 Creating an InfoSource for Characteristic Data
(Use the TCODE RSA1OLD to create InfoSource since the book refered to the old version but I used ECC6.0)
Right-click the newly created Application Component , and then select Create InfoSource...
after creating the infosource, right click the info source to assign the data source.
After that , you can see the infosource in detail,
the left infosource:material number and sales representive id created in the same way.
3.4 Creating InfoPackages to Load Characteristic Data
Right-click Source System you created, and then select Create InfoPackage...
choose the master data and save.
comment: the data in the excel sheet is using CSV style.
Click Start button.
3.5 Checking Loaded Characteristic Data
clck the button marked red in the picture below,
then the monitor screen will be displayed,
Green lights in the left panel indicate that the data have been loaded successfully. If you see the red light, you should check the details in the right panel.
click the PSA button that I marked red in the following,
you will see the data in the PSA.
do the same for the rest and the following is for your reference.
3.6 Entering the Master Data, Text, and Hierarchy Manually(optional)
click the info object to modify
3.7 Creating an InfoSource for Transaction Data
select transaction data and create it in the same way as master data.
then assign the data source for it.
activate it,you will see the status changed,
choose the transfer button and then use arrow to do the mapping.
click the trangle button to make a transfer rule.
3.8 Creating Update Rules for the InfoCube
3.9 Create an InfoPackage to Load Transaction Data
choose the datasource,and save it (the same way as load master data)
in the schedule tab , to click start button and then data will be loaded and you also monitor whether the data is loaded successfully or not.
Finish loading data.
last: see the data flow for your reference:
right click the infocube and choose 'display data flow'.