Show TOC

Creating a Semantically Partitioned ObjectLocate this document in the navigation structure

Prerequisites

In the Data Warehousing Workbench, you can deactivate the display of trees, to make more space available for large applications. In the left navigation pane, choose Hide for Large Applications.

Context

The semantically partitioned object consists of known objects, an InfoCube or a DataStore object. The semantic partitioning creates several objects with the same structure - the partitions. Here a wizard is available to help you minimize the required effort. You define the template for the partitions (the reference structure). The partitions are identical and are derived from the structure. You can only create and change the reference structure. The partitions are write-protected to make sure that they remain identical.

To keep the process of creating a semantically partitioned object as simple as possible, different objects are generated when the object is activated. The following graphic shows the objects that are generated (upper area) and the objects that you need to create yourself (lower area).

Part of data flow is generated by data flowing out of the partitions. Here an InfoSource is created as well as simple dummy transformations that are not executed by the DTP. Part of the data flow is also created by data flowing into the partitions: An InfoSource is also generated with simple dummy transformations. This InfoSource represents a data entry layer for all partitions and makes it easier for you to connect sources.

A semantically partitioned object can only be transported as a whole object. The generated objects are not transported. Instead they are generated in the target system.

Procedure

  1. You are in the Data Warehousing Workbench in the InfoProvider tree. In the InfoArea, select Create InfoCube or Create DataStore Object.
  2. Make the required entries. You can only select Standard as the type for InfoCubes. If you are using an SAP HANA database, the Optimized for SAP HANA option is set by default.
  3. Choose the property Semantically Partitioned. The system now automatically creates an "envelope" (for the semantically partitioned object) in which the different objects are merged. A screen appears where you can define the semantically partitioned object. The right area of the screen displays the InfoProvider definition. The left area of the screen contains a wizard that helps you to create the required objects.

    More information: The Wizard

  4. Define your InfoCube or DataStore object. In doing so, you define the reference structure for the partitions.
    Note

    Note that an InfoCube for a semantically partitioned object cannot contain any non-cumulative key figures.

  5. In the wizard, choose Edit Partitions. The reference structure is automatically saved.
  6. Select the partition criteria. All characteristics are allowed for an InfoCube but only key fields are allowed for a DataStore object.

    You can select a maximum of five partition criteria. Partition characteristics should have maximum stability and only a small number of changes.

  7. Define the partitions. Here you can define individual values, intervals and conditions. Choose Add Partition to create more partitions. The partitions are automatically given a name which you can change if required.
  8. Check and save the partitions. When the check is performed, the system makes sure that the partitions do not overlap.
  9. In the wizard, choose Start Activation. The objects are generated and a log is displayeds.

Results

You have now created the semantically partitioned object. The wizard helps you to perform the remaining steps.

Note

Provided that you have not loaded any data in your object, you can perform all possible types of changes in the editing screen of the reference structure.

If you have already loaded data, you can only add InfoObjects in the reference structure. However, you cannot delete any InfoObjects. In the editing screen of the partitions, you can delete empty partitions and add new partitions. You can change the partitioning criteria of existing partitions. More information: Repartitioning Semantically Partitioned Objects