Including InfoCubes in Process Chains
Use
Process chains facilitate smooth data loading and processing.
More information: Process chain
Prerequisites
You have created an InfoPackage to load data into your DataSource and a data transfer process to load data into your InfoCube.
Procedure
-
Call the process chain maintenance transaction. Choose
Process Chain Maintenance under Administration in the Data Warehousing Workbench. The Process Chain Maintenance Planning View screen appears. -
In the left-hand screen area of the required
Display Component, navigate to the process chain in which you want to include your InfoCube. Double-click to select it. The system displays the process chain plan view in the right-hand screen area.If you cannot find a suitable process chain, create a new one. More information: Creating Process Chains.
-
To insert a process for loading data into an InfoCube, choose
Process Types on the left of the screen. The system displays all process categories that you can choose from. -
In process category
Loading Process and Postprocessing, choose the application process type
Execute InfoPackage. -
Use drag and drop to insert this application process type into the process chain. The dialog box for inserting a process variant appears.
-
Use input help to select the InfoPackage that you want to include in the process chain.
-
Use input help to select the data transfer process that you want to include in the process chain.
-
Connect the processes.
-
Save and check your process chain as described in Creating Process Chains.
Optional Steps:
You can also include the following processes in the process chain:
-
Delete Index -
Build Index -
Build Database Statistics, -
Delete Overlapping Requests from an InfoCube, -
Roll Up Filled Aggregates and -
Compress InfoCube
in the process chain.
Example
The following graphic illustrates an example of how a simple process chain is used to load data into an InfoCube.