Bw Training - 6 Production Support

Process Chains

1

Introduction Dat aLo ad Mon it or

Load into PSA Drop Indexes

Load into ODS

Start Activate Data in ODS

Roll up Aggregates

Build DB Statistics

Dat aTa rge t Ma int aina nc e

Load into Cube Build Indexes 2

InfoCube Maintenance

3

Requests in the InfoCube InfoPackage InfoCube Request no....1 (01.01.01) Record 1 | Request no. 11 | Data1| Data2|... Record 2 | Request no. 12 | Data1| Data2|... Record 3 | Request no. 13 | Data1| Data2|... Record 4 | Request no. 14 | Data1| Data2|...

Request no....2 (02.01.01) Record 1 | Request no.21 | Data1| Data2|... ..... Request no....n (12.01.01) | Data1| Data2|...

Source system Vienna.conf.032499

Upload 1

Upload 2 Upload 3

100 50 0

InfoCube A

Aggregate 1 of Aggregate 2 of InfoCube A InfoCube A

Aggregate 3 of InfoCube A

1 Update (New data not available for queries)

Vienna.conf.032499

East West North 3.

3

New data available after Roll Up

1.

Roll Up of the InfoCube

2 Roll Up (data added to aggregates) Request-No....1 (01.01.01) Record 1 | Request no. 11 | Data1| Data2|... Record 2 | Request no. 12 | Data1| Data2|... Record 3 | Request no. 13 | Data1| Data2|... Record 4 | Request no. 14 | Data1| Data2|...

Compression of the InfoCube

InfoCube

Loss of Request ID´s !!!

Request no....1 (01.01.01) Record | Request | Costs ---------------------------------------------------Record 1 | Request no. 11 | 500 Record 2 | Request no. 12 | 1000 Record 3 | Request no. 13 | 2000 Record 4 | Request no. 14 | 3000

Request no....2 (01.01.01) Record | Request |Revenue ---------------------------------------------------Record 1 | Request no. 21 | 1000 Record 2 | Request no. 22 | 2000 Record 3 | Request no. 23 | 3000 Record 4 | Request no. 24 | 4000

Vienna.conf.032499

(Fact table after compression) Record | Date | Costs | Revenue -----------------------------------------------------------------Record 1 | 01.01.01 | 500 | 1000 Record 2 | 01.01.01 | 1000 | 2000 Record 3 | 01.01.01 | 2000 | 3000 Record 4 | 01.01.01 | 3000 | 4000

Rebuilding the InfoCube

InfoCube B

InfoCube A

Request-No....1 (01.01.01) Record 1 | Request no. 11 | Data1| Data2|... Record 2 | Request no. 12 | Data1| Data2|... Record 3 | Request no. 13 | Data1| Data2|... Record 4 | Request no. 14 | Data1| Data2|...

Request no....2 (02.01.01) Record 1 | Request no.21 | Data1| Data2|... ..... Request no....n (12.01.01) | Data1| Data2|...

Vienna.conf.032499

Rebuilding

Rebuilding Rebuilding