Before we now discuss the last type of loading, the transaction data, we need an InfoCube into which the data can be loaded. Create a new SSIS package, define an OleDB source in the Sales test table and link the pipeline with a BW Loader target. Then click on the link Create Cube in the editor. The following window will open. Through the pipeline that you already linked from the source, Xtract IS already “knows” how the cube should look like. One InfoObject for each element will be needed to create a cube.
OrderID was not in the system as an InfoObject up to now, which is why it should be created by clicking the Create link:
Now only two key figures are needed: quantity and price. A fixed unit (ST for Stück, unit in German) is specified under quantity, and for price, a reference is made to the 0CURRENCY InfoObject:
The three remaining elements are defined through InfoObjects that already exist (ZPROD for product, 0CALDAY for the date and 0CURRENCY for the currency):
We still need to create a new InfoSource of the Transaction Data type. It is set up just like the cube. Only in the price field we have to make an explicit reference to the currency column (Unit Field column):
Xtract IS does not support the automatic creation of updating rules in the cube. These therefore have to be manually created. To do so, open the cube administration in the RSA1 transaction and then select Environment in the menu -> Update Rules -> Create. Select the InfoSource you just created and confirm with Enter. Save and activate the rule.