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.
Step 1. Right-click Source System–demo: flat file,and then select Create InfoPackage….
Step 2. Select DataSource InfoSource Demo: IC_DEMOBC,enter a description for the InfoPackage,and then click to continue.
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.
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.
Step 5. Under the Data targets tab,select the option Select data targets,and then select the first row for our InfoCube IC_DEMOBC.
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 click to load the data.
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.
SAP BW Related Interview Questions
|SAP BI Interview Questions||SAP WM Interview Questions|
|SAP BO Interview Questions||SAP Netweaver Interview Questions|
|SAP BODS Interview Questions||SAP Webi Interview Questions|
|SAP Web Dynpro Interview Questions||SAP BDC Interview Questions|
|SAP BW on HANA Interview Questions|
Sap Bw Tutorial
Business Scenario And Sap Bw
Creating An Infocube
Loading Data Into The Infocube
Checking Data Quality
Creating Queries And Workbooks
Managing User Authorization
Aggregates And Multi-cubes
Operational Data Store (ods)
Generic R/3 Data Extraction
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.