Example: Single Selection for Master Data

The following examples illustrate how the system breaks down the selection conditions of a single selection .

The following items have been defined:

Master Data of Financial Statement Items

Item

Dr/Cr Sign

Item Type

11 – 29

+

1: Balance sheet

31 – 39

–

2: Income statement

91 – 99

+

3: Statistical: balance sheet

Example 1

Selection Conditions

Item 15

Item 35

Included values

(all items except 15) OR (all items except 35)

Excluded values

(none)

Selection logic

(all items except 15) OR (all items except 35)

Result

Items: 11 – 99

Example 2

Selection Conditions

Item 15

Item 35

Included values

All items

Excluded values

Items 15 OR 35

Selection logic

(all items) AND NOT (items 15 OR 35)

Result

Items: 11 – 14, 16 – 34, 36 – 99

Example 3

Selection Conditions

Item 16

Item 15

Item 35

Included values

Item 16

Excluded values

Items 15 OR 35

Selection logic

(item 16) AND NOT (items 15 OR 35)

Result

Items: 16

Example 4

Selection Conditions

Item 15

Item 15

Item 35

Included values

Item 15

Excluded values

Items 15 OR 35

Selection logic

(item 15) AND NOT (items 15 OR 35)

Result

Items: (none)

Example 5

Selection Conditions

Item 11 – 19

Item 31

Item 12 – 13

Item 15

Included values

Items (11 – 19) OR 31

Excluded values

Items (12 – 13) OR 15

Selection logic

Items [(11 – 19) OR 31] AND NOT [(12–13) OR 15]

Result

Items: 11, 14, 16 – 19, 31

Example 6

Selection Conditions

Item 11 – 99

Start of the navigation path Item Next navigation step Item type End of the navigation path 2 – 3

Included values

For characteristic Item : items 11 – 99

For attribute item type : all items

Excluded values

For characteristic Item : (none)

For attribute Item type : items with item type 2 – 3

Selection logic

(items 11 – 99) AND [(all items) AND NOT (items with item type 2 – 3)]

Result

Items: 11 – 29

Example 7

Selection Conditions

Item 11 – 99

Start of the navigation path Item Next navigation step Item type End of the navigation path 1 – 2

Start of the navigation path Item Next navigation step Dr/Cr sign End of the navigation path +

Included values

For characteristic Item : items 11 – 99

For attribute Item type : items with item type 1 – 2

For attribute Dr/Cr sign : items with dr/cr sign +

Excluded values

For characteristic Item : (none)

For attribute item type : (none)

For attribute dr/cr sign : (none)

Selection logic

(items 11 – 99) AND (items with item type 1 – 2) AND (items with dr/cr sign +)

Result

Items: 11 – 29