Antijoin

Use

Using the antijoin, you can identify which data from an InfoProvider is not contained in another InfoProvider.

Features

With time-dependent InfoSets, the intersection of the times of the antijoin InfoProviders and the times of the inner join InfoProviders, but not of any other antijoin InfoProviders, is calculated. All antijoin leaves are independent of one another and their intersections are independent of one another.

InfoCubes and DataStore objects can be defined as pseudo time-dependent if the attributes that describe the time interval are of type Date. You can define key dates of type Date.

Restrictions:

You may not define a time derivation or key date derivation on an InfoProvider that is defined as an antijoin. You can define key dates for the characteristic 0CALDAY.
Attributes of an InfoProvider that is defined as antijoin may not be selected for the query. This is indicated in the first column.
When an InfoProvider is defined as an antijoin InfoProvider, all the attributes selected for the query are reset and are not ready for input.

Example

The InfoSet consists of a DataStore object and a characteristic.

Entries in the characteristic for cars (0VC_CAR):

0VC_CAR	0DATETO	0DATEFROM	0VC_CARCOL
BMW	31.07.2002	01.05.2001	RED
BMW	18.02.2006	01.08.2002	BLUE
HONDA	31.12.2000	01.01.2000	YELLOW
MAZDA	31.12.2000	01.01.2000	BLUE
MAZDA	31.12.2001	01.01.2001	RED
VW CONVERTIBLE	31.12.1975	01.01.1950	PINK
VW BEETLE	31.12.1980	01.01.1940	BLACK

Entries in DataStore object for car orders (0BWVOCAR):

0VC_ISQORD	0VC_ISQEMPL	0VC_CAR	0CALDAY	0VC_ISQQTY
1001	11	BMW	05.10.2001	15,000
1002	12	BMW	27.09.2002	45,000
1003	13	MAZDA	01.10.2000	5,000

Example 1:

The DataStore object is defined as antijoin. With this InfoSet, the master data that does not have an entry in the DataStore object is determined.

Result:

0VC_CAR	0DATETO	0DATEFROM	0VC_CARCOL
HONDA	31.12.2000	01.01.2000	YELLOW
VW CONVERTIBLE	31.12.1975	01.01.1950	PINK
VW BEETLE	31.12.1980	01.01.1940	BLACK

Example 2:

The DataStore object is defined as antijoin. 0CALDAY is also defined as key date.

With this InfoSet, the master data that does not have an entry in the DataStore object for the given key date is determined.

Result:

0VC_CAR	0DATETO	0DATEFROM	0VC_CARCOL
HONDA	31.12.2000	01.01.2000	YELLOW
MAZDA	31.12.2001	01.01.2001	RED
VW CONVERTIBLE	31.12.1975	01.01.1950	PINK
VW BEETLE	31.12.1980	01.01.1940	BLACK