Thursday, 7 June 2012

3.9. Create an InfoPackage to Load Transaction Data


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

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

SCREEN 3.66
2.
Select DataSource InfoSource Demo: IC_DEMOBC, enter a description for the InfoPackage, and then click  to continue.

SCREEN 3.67
3.
Under the Select data tab, note the fields we selected in Screen 3.56. 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.

SCREEN 3.68
Note
0CALDAY (Calendar day) is the characteristic in Screen 2.28 that represents the Transaction Date in Table 1.4. We also included it in the InfoSource definition.
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 fromTable 3.3.

SCREEN 3.69
5.
Under the Data targets tab, select the option Select data targets, and then select the first row for our InfoCube IC_DEMOBC.

SCREEN 3.70
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.
6.
Under the Schedule tab, select the option Start data load immediately, and then click  to load the data.

SCREEN 3.71