Example: Single Selection for Transaction Data

The following examples illustrate how the system breaks down the selection conditions of a single selection , taking cross-characteristic selections into consideration.

The following master data for companies has been defined:

Master Data of Companies

Company

Country

Local Currency

1000

Germany

EUR

2000

Germany

EUR

3000

United States

USD

4000

France

EUR

5000

France

EUR

You want to use the single selection for the following transaction data:

Transaction Data

No.

Company

Partner

Value (in Group Currency)

1

1000

2000

100

2

1000

3000

200

3

1000

4000

300

4

2000

3000

400

5

3000

3000

500

6

4000

–

600

Example 1: Selection Conditions

Selection Conditions

Start of the navigation path Company Next navigation step Country End of the navigation path Start of the navigation path Partner Next navigation step Country End of the navigation path

Included values

all transaction data

Excluded values

–

Cross-characteristic selection

Start of the navigation path Company Next navigation step Country = Partner Next navigation step Country End of the navigation path

Selection logic

(all transaction data) AND Start of the navigation path (Company Next navigation step Country = Partner Next navigation step Country) End of the navigation path

Example 1: Result (Transaction Data Selected)

No.

Company

Partner

Value (in Group Currency)

1

1000

2000

100

5

3000

3000

500

Example 2: Selection Conditions

Selection Conditions

Start of the navigation path Company Next navigation step Local currency End of the navigation path EUR

Start of the navigation path Company Next navigation step Country End of the navigation path Start of the navigation path Partner Next navigation step Country End of the navigation path

Included values

For attribute Local Currency : Start of the navigation path Company  Next navigation step  Local currency = EUR End of the navigation path

Excluded values

–

Cross-characteristic selection

Start of the navigation path Company Next navigation step Country ≠ Partner Next navigation step Country End of the navigation path

Selection logic

Start of the navigation path (Company Next navigation step Local currency = EUR) End of the navigation path AND Start of the navigation path (Company Next navigation step Country ≠ Partner Next navigation step Country) End of the navigation path

Example 2: Result (Transaction Data Selected)

No.

Company

Partner

Value (in Group Currency)

2

1000

3000

200

4

2000

3000

400

6

4000

–

600

Example 3: Selection Conditions

Selection Conditions

Start of the navigation path Company Next navigation step Country End of the navigation path United States

Start of the navigation path Company Next navigation step Local currency End of the navigation path EUR

Company Partner

Included values

For attribute Country : Start of the navigation path Company  Next navigation step  Country = United States End of the navigation path

For attribute Local Currency : Start of the navigation path Company  Next navigation step  Local currency ≠ EUR End of the navigation path

Excluded values

–

Cross-characteristic selection

Company = Partner

Selection logic

(Company = Partner) AND Start of the navigation path (Company Next navigation step Country = United States) AND End of the navigation path Start of the navigation path (Company Next navigation step Local currency ≠ EUR) End of the navigation path

Example 3: Result (Transaction Data Selected)

No.

Company

Partner

Value (in Group Currency)

5

3000

3000

500