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

  1. Call the process chain maintenance transaction. Choose Process Chain MaintenanceProcess Chain Maintenance under Administration in the Data Warehousing Workbench. The Process Chain Maintenance Planning View screen appears.

  2. In the left-hand screen area of the required Display ComponentDisplay 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.

  3. To insert a process for loading data into an InfoCube, choose Process TypesProcess Types on the left of the screen. The system displays all process categories that you can choose from.

  4. In process category Loading Process and PostprocessingLoading Process and Postprocessing, choose the application process type Execute InfoPackageExecute InfoPackage.

  5. Use drag and drop to insert this application process type into the process chain. The dialog box for inserting a process variant appears.

  6. Use input help to select the InfoPackage that you want to include in the process chain.

  7. Use input help to select the data transfer process that you want to include in the process chain.

  8. Connect the processes.

  9. 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 IndexDelete Index

  • Build IndexBuild Index

  • Build Database StatisticsBuild Database Statistics,

  • Delete Overlapping Requests from an InfoCubeDelete Overlapping Requests from an InfoCube,

  • Roll Up Filled AggregatesRoll Up Filled Aggregates and

  • Compress InfoCubeCompress 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.