Create an InfoPackage to Load Transaction Data - SAP BW

Now we are ready to create an InfoPackage to load the transaction data. In this InfoPackage,we will specify how and when to load data.

Work Instructions
Step 1. Right-click Source System–demo: flat file,and then select Create InfoPackage….
Work Instructions

Step 2. Select DataSource InfoSource Demo: IC_DEMOBC,enter a description for the InfoPackage,and then click Work Instructionsto continue.
Work Instructions

Step 3. Under the Select data tab,note the fields we selected in Screen. We can use the selection condition on 0CALDAY to load 1999 data first,2000 data second,and 2001 data last. If we do not enter anything,all of the data will be loaded together in one data load request. Because we do not have a large volume of data,we load them all together.
Administrator work bench modelling

Note:0CALDAY (Calendar day) is the characteristic in Screen that represents the Transaction Date in Table. We also included it in the InfoSource definition.

Step 4. Under the External data tab,select options as shown in the screen,and enter a file name with a path. The file contains the data from Table.
Administrator work bench modelling

Step 5. Under the Data targets tab,select the option Select data targets,and then select the first row for our InfoCube IC_DEMOBC.
Administrator work bench modelling

Note:If the InfoSource appears in the update rules for other InfoCubes,all of the InfoCubes will be listed in the table. We can then specify into which InfoCubes we want to load the data.

Step 6:Under the Schedule tab,select the option Start data load immediately,and then clickClick to load the data.
Administrator work bench modelling

Result:

A status message Data was requested will appear at the bottom of Screen.

Note:We can check whether the data were loaded successfully by using BW Monitor as shown in Screen "Checking InfoCube Contents," and "InfoCube Contents," both describe techniques for checking the InfoCube contents to confirm that the data loading process worked correctly.Table shows the sales data for our example. In the table,CS,EA,and DZ are abbreviations for Case,Each,and Dozen,respectively. The IO_REV column will hold the sales revenue data,which will be calculated by the transfer rule.
SALES DATA
SALES DATASALES DATA


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BW Topics