The process for uploading data is more or less the same irrespective of the type of source system. This process is described in outline below. For more information about each step, see the SAP Library for SAP NetWeaver under SAP NetWeaver Library ® SAP NetWeaver by Key Capability ® Integration Information by Key Capability ® Business Intelligence ® Data Warehousing ® Data Warehousing Workbench.
You have made the necessary setting for the source systems in the current system and in the source system. For more information, see Source System.
1. You create an InfoArea.
a. On the SAP Easy Access screen, choose Demand Planning ® Environment ® Data Warehousing Workbench.
b. In the modeling tree on the left, choose Data Targets.
c. Right-click the Data Targets node on the right and choose Create InfoArea.
d. Enter a name and a description for the InfoArea.
e. Choose Enter.
2. If necessary, you create an InfoCube.
3. You now define the source system.
This step depends on the type of source system for the data.
For more information, see Setting Up the System Infrastructure.
4. If necessary, you create an application component.
5. You create an InfoSource for this application component.
Here you decide whether to maintain transaction data or master data. In general, data for use in Demand Planning is transaction data. Master data consists of attributes, texts, and hierarchies and is stored in a characteristic.
For more information, see InfoSource.
6. You now assign the source system that you created in step 3 to the InfoSource.
You define the transfer structure, transfer rules, and communication structure. The transfer structure defines how the data is transferred from the data source. The communication structure defines how data is imported into the InfoCubes. If you only have one data source for an InfoSource, there is no difference between the transfer structure and the communication structure.
For more information, see Creating Source Systems.
7. You create update rules for the InfoCube.
The update rules determine how the data is uploaded from the communication structure of the InfoSource to the individual InfoCubes. For a description of transfer rules, see Update Rules.
8. You create an InfoPackage.
An InfoPackage contains, for example, the following data:
○ When the data is to be uploaded, for instance, immediately or as a background job
○ Details about the external data such as the location of flat files
○ Selection criteria
○ The target InfoCube(s)
You can also use InfoPackage groups to schedule several InfoPackages together.
The data is transferred to the InfoCube. You can also display a log – which you can call from the Data Warehousing Workbench – for the order generated for the job in the manager. To do so, you select the InfoCube and choose the manager from the context menu. Here you can also check the contents of the InfoCube by selecting the InfoCube in the top section of the screen and choosing Contents.